| using System; | 
| using System.Collections.Generic; | 
| using System.ComponentModel; | 
| using System.Data; | 
| using System.Drawing; | 
| using System.Text; | 
| using System.Windows.Forms; | 
|   | 
| namespace APSM | 
| { | 
|     public partial class Sc_ICMOSortBillListDlg : Form | 
|     { | 
|         public Sc_ICMOSortBillListDlg() | 
|         { | 
|             InitializeComponent(); | 
|         } | 
|   | 
|         public long HInterID = 0; | 
|         SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); | 
|   | 
|         private void cmdCancel_Click(object sender, EventArgs e) | 
|         { | 
|             this.Visible = false; | 
|         } | 
|   | 
|         private void cmdOK_Click(object sender, EventArgs e) | 
|         { | 
|             if (SubSave()) | 
|             { | 
|                 MessageBox.Show("Ð޸ijɹ¦£¡", "Ìáʾ"); | 
|             } | 
|             this.Visible = false; | 
|         } | 
|   | 
|         private bool SubSave() | 
|         { | 
|             try | 
|             { | 
|                 oCn.BeginTran(); | 
|                 oCn.RunProc("update Sc_ICMOBillStatus_Tmp set HRemark='" + txtHRemark.Text.Trim() + "' where HInterid=" + HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 oCn.Commit(); | 
|                 return true; | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 MessageBox.Show("ÐÞ¸Äʧ°Ü£¡ÔÒò£º" + e.Message.ToString(), "Ìáʾ"); | 
|                 oCn.RollBack(); | 
|                 return false; | 
|             } | 
|         } | 
|   | 
|         private void Sc_ICMOSortBillListDlg_Load(object sender, EventArgs e) | 
|         { | 
|             SubShow(); | 
|         } | 
|   | 
|         private void SubShow() | 
|         { | 
|             try | 
|             { | 
|                 //²éѯÖ÷±í | 
|                 DataSet Ds; | 
|                 Ds = oCn.RunProcReturn("Select * from Sc_ICMOBillStatus_Tmp Where HInterid=" + HInterID.ToString(), "Sc_ICMOBillStatus_Tmp"); | 
|                 if (Ds.Tables[0].Rows.Count == 0) | 
|                 { | 
|                     MessageBox.Show("µ¥¾ÝδÕÒµ½£¡", "Ìáʾ"); | 
|                     return; | 
|                 } | 
|                 txtHRemark.Text = Ds.Tables[0].Rows[0]["HRemark"].ToString(); | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 MessageBox.Show("ÐÞ¸Äʧ°Ü£¡ÔÒò£º" + e.Message.ToString(), "Ìáʾ"); | 
|                 return; | 
|             } | 
|         } | 
|     } | 
| } |