FrmUpdateEquMsg.cs 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. using DevComponents.DotNetBar;
  2. using System;
  3. using System.Data;
  4. using WCS_Client.UC;
  5. namespace WCS_Client.Frm.MBtn_Monitor
  6. {
  7. public partial class FrmUpdateEquMsg : Office2007Form
  8. {
  9. private DataRow dr = null;
  10. public FrmUpdateEquMsg(DataRow datarow)
  11. {
  12. InitializeComponent();
  13. dr = datarow;
  14. txtEqu_No.Text = datarow["DEVICECODE"].ToString();
  15. txtEqu_PlcName.Text = datarow["Equ_PlcName"].ToString();
  16. txtEqu_Area.Text = datarow["Equ_Area"].ToString();
  17. txtEqu_Type.Text = datarow["Equ_Type"].ToString();
  18. txtEqu_Notes.Text = datarow["Equ_Notes"].ToString();
  19. }
  20. private void btnCancel_Click_1(object sender, EventArgs e)
  21. {
  22. this.Close();
  23. }
  24. private void btnUpdateP_Click_1(object sender, EventArgs e)
  25. {
  26. var enuipmentinfo = new WCS_EQUIPMENTINFO();
  27. enuipmentinfo.Equ_Notes = txtEqu_Notes.Text.Trim();
  28. string result = TryCachHelper.TryExecute((db) =>
  29. {
  30. if (db.Updateable<WCS_EQUIPMENTINFO>()
  31. .UpdateColumns(it => new WCS_EQUIPMENTINFO
  32. {
  33. Equ_Notes = enuipmentinfo.Equ_Notes
  34. })
  35. .Where(v => v.Equ_No == txtEqu_No.Text).ExecuteCommand() < 0)
  36. {
  37. throw new Exception(string.Format("设备编号[{0}]修改备注信息失败!", txtEqu_No.Text));
  38. }
  39. });
  40. if (string.IsNullOrWhiteSpace(result))
  41. {
  42. result = string.Format("修改机械码垛信息成功");
  43. }
  44. MessageUtil.ShowTips(result);
  45. }
  46. }
  47. }