using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace OAM { public partial class frm_MeetingItem : Form { public string HMeetNumber; public string HMeet; public bool zt; public Int64 HInterID; public frm_MeetingItem() { InitializeComponent(); } public Int64 iInterID = 0; private void cmdCancel_Click(object sender, EventArgs e) { this.Close(); } private void cmdOK_Click(object sender, EventArgs e) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); if (DBUtility.ClsPub.isStrNull(txtHMeet.Text) == "") { MessageBox.Show("ûÓмÈëÏîÄ¿Ãû³Æ"); return; } if (DBUtility.ClsPub.isStrNull(txtHMeetNumber.Text) == "") { MessageBox.Show("ûÓмÈëÏîÄ¿´úÂë"); return; } if (zt == false) { //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); oCn.RunProc("update oa_meetingitem set HNumber='" + txtHMeetNumber.Text + "'" + ",HName='" + txtHMeet.Text + "'" + " where HItemID=" + HInterID); MessageBox.Show("Ð޸ijɹ¦£¡"); //DBUtility.ClsPub.SaveGridView(grdFJ, this.Name, DBUtility.ClsPub.AppPath); this.Close(); //MessageBox.Show("ÏîÄ¿" + txtHMeet.Text + "ÐÞ¸ÄÍê³É"); } else { if (iInterID == 0) { oCn.RunProc("insert into oa_meetingitem (HNumber,HName,HRemark,HStopflag) values" + "('" + txtHMeetNumber.Text.Trim() + "','" + txtHMeet.Text.Trim() + "','',0)"); } else { oCn.RunProc("Update oa_meetingitem set HNumber='" + txtHMeetNumber.Text.Trim() + "', " + " HName='" + txtHMeet.Text.Trim() + "' where HInterID=" + iInterID.ToString()); } MessageBox.Show("ÐÂÔö³É¹¦£¡"); txtHMeet.Text = ""; txtHMeetNumber.Text = ""; this.Close(); } } private void frm_MeetingItem_Load(object sender, EventArgs e) { if (zt == false) { txtHMeet.Text = HMeet; txtHMeetNumber.Text = HMeetNumber; } else { txtHMeet.Text = HMeet; txtHMeetNumber.Text = HMeetNumber; } } } }