FormEditSystemParameter.cs 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573
  1. using ProjectBase.Data.BaseDAL;
  2. using ProjectBase.Data.Logs;
  3. using ProjectBase.Util;
  4. using SIMDP.BLL;
  5. using SIMDP.Model;
  6. using SIMDP.Util;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.ComponentModel;
  10. using System.Data;
  11. using System.Drawing;
  12. using System.Linq;
  13. using System.Text;
  14. using System.Threading.Tasks;
  15. using System.Windows.Forms;
  16. namespace SIMDP
  17. {
  18. public partial class FormEditSystemParameter : DevExpress.XtraEditors.XtraForm
  19. {
  20. private MoSystemParameter moSystemPara = null;
  21. public FormEditSystemParameter(MoSystemParameter systemPara)
  22. {
  23. InitializeComponent();
  24. InitControls();
  25. moSystemPara = systemPara;
  26. }
  27. private void FormEditSystemParameter_Load(object sender, EventArgs e)
  28. {
  29. if (moSystemPara != null)
  30. {
  31. this.textEditParaName.EditValue = moSystemPara.ParameterName;
  32. this.textEditParaValue.EditValue = moSystemPara.ParameterValue;
  33. this.dateEditPara.EditValue = moSystemPara.ParameterTime;
  34. this.lookUpEditParaType.EditValue = Convert.ToInt32(moSystemPara.ParameterType) ;
  35. this.checkEditValid.Checked = moSystemPara.ParameterValid;
  36. this.richTextBoxParaDescription.Text = moSystemPara.ParameterDescription;
  37. this.textEditParaUnit.EditValue = moSystemPara.ParameterUnit;
  38. }
  39. }
  40. /// <summary>
  41. /// 初始化控件
  42. /// </summary>
  43. private void InitControls()
  44. {
  45. //下拉框--参数类型
  46. BindingSource bsParaType = new BindingSource();
  47. bsParaType.DataSource = SysEnvironment.dirSysParameterType;
  48. this.lookUpEditParaType.Properties.DataSource = bsParaType;
  49. this.lookUpEditParaType.Properties.ValueMember = "Key";
  50. this.lookUpEditParaType.Properties.DisplayMember = "Value";
  51. this.lookUpEditParaType.Properties.NullText = null;
  52. //下拉框--参数范围参考条件
  53. BindingSource bsCondition = new BindingSource();
  54. bsCondition.DataSource = SysEnvironment.dirSysParameterData;
  55. this.lookUpEditCondition.Properties.DataSource = bsCondition;
  56. this.lookUpEditCondition.Properties.ValueMember = "Key";
  57. this.lookUpEditCondition.Properties.DisplayMember = "Value";
  58. this.lookUpEditCondition.Properties.NullText = null;
  59. }
  60. /// <summary>
  61. /// 保存
  62. /// </summary>
  63. /// <param name="sender"></param>
  64. /// <param name="e"></param>
  65. private void SimpleButtonSave_Click(object sender, EventArgs e)
  66. {
  67. if (!Validation())
  68. {
  69. return;
  70. }
  71. if (!ParameterTypeValidation())
  72. return;
  73. if (!ParameterDataValidation())
  74. return;
  75. try
  76. {
  77. MoSystemParameter mo = new MoSystemParameter();
  78. mo.ParameterName = this.textEditParaName.EditValue.ToString();
  79. mo.ParameterValue = this.textEditParaValue.EditValue.ToString();
  80. mo.ParameterTime = Convert.ToDateTime(this.dateEditPara.EditValue);
  81. mo.ParameterUnit = this.textEditParaUnit.EditValue.ToString();
  82. mo.ParameterType = this.lookUpEditParaType.EditValue.ToString();
  83. mo.ParameterValid = this.checkEditValid.Checked;
  84. mo.ParameterScope = this.textEditStart.EditValue != null? this.textEditStart.EditValue.ToString() : "";
  85. if (this.textEditStart.EditValue != null && this.textEditEnd.EditValue != null)
  86. mo.ParameterScope += "~";
  87. mo.ParameterScope += this.textEditEnd.EditValue != null? this.textEditEnd.EditValue.ToString() : "";
  88. mo.ParameterDescription = this.richTextBoxParaDescription.Text;
  89. //BlSystemParameter bl = new BlSystemParameter();
  90. bool bOK = false;
  91. if (moSystemPara == null)
  92. bOK = BLLFactory<BlSystemParameter>.Instance.Insert(mo);
  93. else
  94. {
  95. mo.ParameterId = moSystemPara.ParameterId;
  96. bOK = BLLFactory<BlSystemParameter>.Instance.Update(mo, mo.ParameterId);
  97. }
  98. if (!bOK)
  99. {
  100. DevExpress.XtraEditors.XtraMessageBox.Show("系统参数编辑失败!");
  101. }
  102. else
  103. {
  104. DevExpress.XtraEditors.XtraMessageBox.Show("系统参数编辑成功!");
  105. this.Close();
  106. }
  107. }
  108. catch (Exception ex)
  109. {
  110. DevExpress.XtraEditors.XtraMessageBox.Show("保存系统参数相关信息失败。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  111. LogHelper.log.Error(string.Format("保存系统相关信息出现错误:{0}", ex));
  112. }
  113. }
  114. /// <summary>
  115. /// 参数值的类型改变
  116. /// </summary>
  117. /// <param name="sender"></param>
  118. /// <param name="e"></param>
  119. private void LookUpEditParaType_EditValueChanged(object sender, EventArgs e)
  120. {
  121. if (this.lookUpEditParaType.EditValue != null &&!string.IsNullOrEmpty(this.lookUpEditParaType.EditValue.ToString()))
  122. {
  123. this.lookUpEditCondition.EditValue= null;
  124. this.lookUpEditCondition.ItemIndex = -1;
  125. int paraType = Convert.ToInt32(this.lookUpEditParaType.EditValue);
  126. switch (paraType)
  127. {
  128. case 0:
  129. this.lookUpEditCondition.Enabled = false;
  130. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
  131. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
  132. this.textEditParaValue.Properties.NullValuePromptShowForEmptyValue = true;
  133. this.textEditParaValue.Properties.NullValuePrompt = "请输入文本";
  134. break;
  135. case 1:
  136. this.lookUpEditCondition.Enabled = true;
  137. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  138. this.layoutControlItemMin.Text = "最小值(*):";
  139. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  140. this.layoutControlItemMax.Text = "最大值(*):";
  141. this.textEditStart.Properties.NullValuePromptShowForEmptyValue = true;
  142. this.textEditStart.Properties.NullValuePrompt = "请输入小于3位小数的数值";
  143. this.textEditEnd.Properties.NullValuePromptShowForEmptyValue = true;
  144. this.textEditEnd.Properties.NullValuePrompt = "请输入小于3位小数的数值";
  145. this.textEditParaValue.Properties.NullValuePromptShowForEmptyValue = true;
  146. this.textEditParaValue.Properties.NullValuePrompt = "请输入小于3位小数的数值";
  147. break;
  148. case 2:
  149. this.lookUpEditCondition.Enabled = true;
  150. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  151. this.layoutControlItemMin.Text = "最小值(*):";
  152. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  153. this.layoutControlItemMax.Text = "最大值(*):";
  154. this.textEditStart.Properties.NullValuePromptShowForEmptyValue = true;
  155. this.textEditStart.Properties.NullValuePrompt = "请输入整数";
  156. this.textEditEnd.Properties.NullValuePromptShowForEmptyValue = true;
  157. this.textEditEnd.Properties.NullValuePrompt = "请输入整数";
  158. this.textEditParaValue.Properties.NullValuePromptShowForEmptyValue = true;
  159. this.textEditParaValue.Properties.NullValuePrompt = "请输入整数";
  160. break;
  161. case 3:
  162. this.lookUpEditCondition.Enabled = true;
  163. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  164. this.layoutControlItemMin.Text = "开始时间(*):";
  165. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  166. this.layoutControlItemMax.Text = "结束时间(*):";
  167. this.textEditStart.Properties.NullValuePromptShowForEmptyValue = true;
  168. this.textEditStart.Properties.NullValuePrompt = "00:00:00";
  169. this.textEditEnd.Properties.NullValuePromptShowForEmptyValue = true;
  170. this.textEditEnd.Properties.NullValuePrompt = "00:00:00";
  171. this.textEditParaValue.Properties.NullValuePromptShowForEmptyValue = true;
  172. this.textEditParaValue.Properties.NullValuePrompt = "00:00:00";
  173. break;
  174. case 4:
  175. this.lookUpEditCondition.Enabled = true;
  176. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  177. this.layoutControlItemMin.Text = "开始日期(*):";
  178. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  179. this.layoutControlItemMax.Text = "结束日期(*):";
  180. this.textEditStart.Properties.NullValuePromptShowForEmptyValue = true;
  181. this.textEditStart.Properties.NullValuePrompt = "0000/00/00";
  182. this.textEditEnd.Properties.NullValuePromptShowForEmptyValue = true;
  183. this.textEditEnd.Properties.NullValuePrompt = "0000/00/00";
  184. this.textEditParaValue.Properties.NullValuePromptShowForEmptyValue = true;
  185. this.textEditParaValue.Properties.NullValuePrompt = "0000/00/00";
  186. break;
  187. default:
  188. break;
  189. }
  190. }
  191. }
  192. /// <summary>
  193. /// 取值条件改变
  194. /// </summary>
  195. /// <param name="sender"></param>
  196. /// <param name="e"></param>
  197. private void LookUpEditCodition_EditValueChanged(object sender, EventArgs e)
  198. {
  199. if (this.lookUpEditCondition.EditValue != null && !string.IsNullOrEmpty(this.lookUpEditCondition.EditValue.ToString()))
  200. {
  201. int paraType = Convert.ToInt32(this.lookUpEditCondition.EditValue);
  202. switch (paraType)
  203. {
  204. case 1:
  205. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  206. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  207. break;
  208. case 2:
  209. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  210. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  211. break;
  212. case 3:
  213. case 4:
  214. case 5:
  215. case 6:
  216. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  217. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
  218. break;
  219. case 7:
  220. case 8:
  221. this.layoutControlItemMin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
  222. this.layoutControlItemMax.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
  223. break;
  224. default:
  225. break;
  226. }
  227. }
  228. }
  229. /// <summary>
  230. /// 参数值验证
  231. /// </summary>
  232. /// <param name="sender"></param>
  233. /// <param name="e"></param>
  234. private void TextEditParaValue_EditValueChanged(object sender, EventArgs e)
  235. {
  236. //if (string.IsNullOrEmpty(this.lookUpEditParaType.EditValue.ToString()))
  237. //{
  238. // DevExpress.XtraEditors.XtraMessageBox.Show("请先选择系统参数值类型!");
  239. // return;
  240. //}
  241. //if (string.IsNullOrEmpty(this.lookUpEditCondition.EditValue.ToString()))
  242. //{
  243. // DevExpress.XtraEditors.XtraMessageBox.Show("请先选择系统参数值范围取值条件!");
  244. // return;
  245. //}
  246. //ParameterTypeValidation();
  247. //ParameterDataValidation();
  248. }
  249. /// <summary>
  250. /// 验证输入的值的类型
  251. /// </summary>
  252. /// <returns></returns>
  253. private bool ParameterTypeValidation()
  254. {
  255. int paraType = Convert.ToInt32(this.lookUpEditParaType.EditValue);
  256. bool bOK = false;
  257. switch (paraType)
  258. {
  259. case 0:
  260. bOK = true;
  261. break;
  262. case 1:
  263. bOK = TypeValidation.IsNumerical(this.textEditParaValue.EditValue.ToString());
  264. break;
  265. case 2:
  266. bOK = TypeValidation.IsInteger(this.textEditParaValue.EditValue.ToString());
  267. break;
  268. case 3:
  269. bOK = TypeValidation.IsTime(this.textEditParaValue.EditValue.ToString());
  270. break;
  271. case 4:
  272. bOK = TypeValidation.IsDate(this.textEditParaValue.EditValue.ToString());
  273. break;
  274. default:
  275. bOK = true;
  276. break;
  277. }
  278. if (!bOK)
  279. {
  280. DevExpress.XtraEditors.XtraMessageBox.Show("输入的值的类型不符合取值条件!");
  281. return false;
  282. }
  283. return true;
  284. }
  285. /// <summary>
  286. /// 验证输入的值
  287. /// /// </summary>
  288. /// <returns></returns>
  289. private bool ParameterDataValidation()
  290. {
  291. int paraType = Convert.ToInt32(this.lookUpEditParaType.EditValue);
  292. int paraCondition = Convert.ToInt32(this.lookUpEditCondition.EditValue);
  293. bool bOK = false;
  294. switch (paraCondition)
  295. {
  296. case 1: //介于
  297. {
  298. if (paraType == 1)//数值比较
  299. {
  300. if (Convert.ToDecimal(this.textEditParaValue.Text) >= Convert.ToDecimal(this.textEditStart.Text) &&
  301. Convert.ToDecimal(this.textEditParaValue.Text) <= Convert.ToDecimal(this.textEditEnd.Text))
  302. {
  303. bOK = true;
  304. }
  305. }
  306. else if (paraType == 2)//整型比较
  307. {
  308. if (Convert.ToInt32(this.textEditParaValue.Text) >= Convert.ToInt32(this.textEditStart.Text) &&
  309. Convert.ToInt32(this.textEditParaValue.Text) <= Convert.ToInt32(this.textEditEnd.Text))
  310. {
  311. bOK = true;
  312. }
  313. }
  314. else //时间和日期比较
  315. {
  316. if ((0 <= this.textEditParaValue.EditValue.ToString().CompareTo(this.textEditStart.EditValue.ToString())) &&
  317. (0 >= this.textEditParaValue.EditValue.ToString().CompareTo(this.textEditEnd.EditValue.ToString())))
  318. {
  319. bOK = true;
  320. }
  321. }
  322. break;
  323. }
  324. case 2: //未介于
  325. {
  326. if (paraType == 1)//数值比较
  327. {
  328. if (Convert.ToDecimal(this.textEditParaValue.Text) < Convert.ToDecimal(this.textEditStart.Text) ||
  329. Convert.ToDecimal(this.textEditParaValue.Text) > Convert.ToDecimal(this.textEditEnd.Text))
  330. {
  331. bOK = true;
  332. }
  333. }
  334. else if (paraType == 2)//整型比较
  335. {
  336. if (Convert.ToInt32(this.textEditParaValue.Text) < Convert.ToInt32(this.textEditStart.Text) ||
  337. Convert.ToInt32(this.textEditParaValue.Text) > Convert.ToInt32(this.textEditEnd.Text))
  338. {
  339. bOK = true;
  340. }
  341. }
  342. else //时间和日期比较
  343. {
  344. if (0 > this.textEditParaValue.EditValue.ToString().CompareTo(this.textEditStart.EditValue.ToString()) ||
  345. 0 < this.textEditParaValue.EditValue.ToString().CompareTo(this.textEditEnd.EditValue.ToString()))
  346. {
  347. bOK = true;
  348. }
  349. }
  350. break;
  351. }
  352. case 3: //等于
  353. {
  354. if (this.textEditParaValue.EditValue.Equals(this.textEditStart.EditValue))
  355. {
  356. bOK = true;
  357. }
  358. break;
  359. }
  360. case 4: //不等于
  361. {
  362. if (!this.textEditParaValue.EditValue.Equals(this.textEditStart.EditValue))
  363. {
  364. bOK = true;
  365. }
  366. break;
  367. }
  368. case 5: //大于
  369. {
  370. if (paraType == 1)//数值比较
  371. {
  372. if (Convert.ToDecimal(this.textEditParaValue.Text) > Convert.ToDecimal(this.textEditStart.Text))
  373. {
  374. bOK = true;
  375. }
  376. }
  377. else if (paraType == 2)//整型比较
  378. {
  379. if (Convert.ToInt32(this.textEditParaValue.Text) > Convert.ToInt32(this.textEditStart.Text))
  380. {
  381. bOK = true;
  382. }
  383. }
  384. else //时间和日期比较
  385. {
  386. if (0 < this.textEditParaValue.EditValue.ToString().CompareTo(this.textEditStart.EditValue.ToString()))
  387. {
  388. bOK = true;
  389. }
  390. }
  391. break;
  392. }
  393. case 6: //大于等于
  394. {
  395. if (paraType == 1)//数值比较
  396. {
  397. if (Convert.ToDecimal(this.textEditParaValue.Text) >= Convert.ToDecimal(this.textEditStart.Text))
  398. {
  399. bOK = true;
  400. }
  401. }
  402. else if (paraType == 2)//整型比较
  403. {
  404. if (Convert.ToInt32(this.textEditParaValue.Text) >= Convert.ToInt32(this.textEditStart.Text))
  405. {
  406. bOK = true;
  407. }
  408. }
  409. else //时间和日期比较
  410. {
  411. if (0 <= this.textEditParaValue.EditValue.ToString().CompareTo(this.textEditStart.EditValue.ToString()))
  412. {
  413. bOK = true;
  414. }
  415. }
  416. break;
  417. }
  418. case 7: //小于
  419. {
  420. if (paraType == 1)//数值比较
  421. {
  422. if (Convert.ToDecimal(this.textEditParaValue.Text) < Convert.ToDecimal(this.textEditEnd.Text))
  423. {
  424. bOK = true;
  425. }
  426. }
  427. else if (paraType == 2)//整型比较
  428. {
  429. if (Convert.ToInt32(this.textEditParaValue.Text) < Convert.ToInt32(this.textEditEnd.Text))
  430. {
  431. bOK = true;
  432. }
  433. }
  434. else //时间和日期比较
  435. {
  436. if (0 > this.textEditParaValue.EditValue.ToString().CompareTo(this.textEditEnd.EditValue.ToString()))
  437. {
  438. bOK = true;
  439. }
  440. }
  441. break;
  442. }
  443. case 8: //小于等于
  444. {
  445. if (paraType == 1)//数值比较
  446. {
  447. if (Convert.ToDecimal(this.textEditParaValue.Text) <= Convert.ToDecimal(this.textEditEnd.Text))
  448. {
  449. bOK = true;
  450. }
  451. }
  452. else if (paraType == 2)//整型比较
  453. {
  454. if (Convert.ToInt32(this.textEditParaValue.Text) <= Convert.ToInt32(this.textEditEnd.Text))
  455. {
  456. bOK = true;
  457. }
  458. }
  459. else //时间和日期比较
  460. {
  461. if (0 >= this.textEditParaValue.EditValue.ToString().CompareTo(this.textEditEnd.EditValue.ToString()))
  462. {
  463. bOK = true;
  464. }
  465. }
  466. break;
  467. }
  468. default:
  469. bOK = true;
  470. break;
  471. }
  472. if (!bOK)
  473. {
  474. DevExpress.XtraEditors.XtraMessageBox.Show("输入的值不符合取值范围!");
  475. return false;
  476. }
  477. return true;
  478. }
  479. /// <summary>
  480. /// 验证必填项是否为空
  481. /// </summary>
  482. /// <returns></returns>
  483. private bool Validation()
  484. {
  485. if (string.IsNullOrEmpty(this.textEditParaName.Text))
  486. {
  487. DevExpress.XtraEditors.XtraMessageBox.Show("请先输入用户参数名称!");
  488. return false;
  489. }
  490. if (this.dateEditPara.EditValue == null || string.IsNullOrEmpty(this.dateEditPara.Text))
  491. {
  492. DevExpress.XtraEditors.XtraMessageBox.Show("请先选择生效日期!");
  493. return false;
  494. }
  495. if (this.lookUpEditParaType.EditValue == null || string.IsNullOrEmpty(this.lookUpEditParaType.EditValue.ToString()))
  496. {
  497. DevExpress.XtraEditors.XtraMessageBox.Show("请先选择用户参数值类型!");
  498. return false;
  499. }
  500. int paraType = Convert.ToInt32(this.lookUpEditParaType.EditValue);
  501. if (paraType != 0 && this.lookUpEditCondition.EditValue == null)
  502. {
  503. DevExpress.XtraEditors.XtraMessageBox.Show("请先选择用户参数值范围取值条件!");
  504. return false;
  505. }
  506. if (this.layoutControlItemMin.Visible)
  507. {
  508. int index = this.layoutControlItemMin.Text.IndexOf("*");
  509. string str = this.layoutControlItemMin.Text.Substring(0, index - 1);
  510. if (string.IsNullOrEmpty(this.textEditStart.Text))
  511. {
  512. DevExpress.XtraEditors.XtraMessageBox.Show(string.Format("请先输入{0}!", str));
  513. return false;
  514. }
  515. }
  516. if (this.layoutControlItemMax.Visible)
  517. {
  518. int index = this.layoutControlItemMax.Text.IndexOf("*");
  519. string str = this.layoutControlItemMax.Text.Substring(0, index - 1);
  520. if (string.IsNullOrEmpty(this.textEditEnd.Text))
  521. {
  522. DevExpress.XtraEditors.XtraMessageBox.Show(string.Format("请先输入{0}!", str));
  523. return false;
  524. }
  525. }
  526. if (string.IsNullOrEmpty(this.textEditParaValue.Text))
  527. {
  528. DevExpress.XtraEditors.XtraMessageBox.Show("请先输入参数值!");
  529. return false;
  530. }
  531. if (string.IsNullOrEmpty(this.textEditParaUnit.Text))
  532. {
  533. DevExpress.XtraEditors.XtraMessageBox.Show("请先输入参数单位!");
  534. return false;
  535. }
  536. return true;
  537. }
  538. }
  539. }