public void Update_EN_IN_ContactCheckup(string OrderNumber ,string EN, string Payor) { ExcData exc = new ExcData(); string SQL = @"UPDATE [Patient] SET [Episode] = '" + EN + "' WHERE [Episode] = '" + OrderNumber + "'"; try { exc.ExecData(SQL); } catch (Exception ex) { ex.ToString(); //MessageBox.Show("Cannot update EN :" + EN + " in Contact Database"); } }
private void btUpdate_Click(object sender, EventArgs e) { exc = new ExcData(); string SQL = "update tblProchklistMapPackage set StatusFlag = 'D' where ProChkList = '" + gvProchklistMapPackage.CurrentRow.Cells["ProChkList"].Value.ToString() + "' and PackageCode = '" + gvProchklistMapPackage.CurrentRow.Cells["PackageCode"].Value.ToString() + "'"; if(exc.ExecData(SQL) == false) { MessageBox.Show("Cannot delete this package"); } BindProchklistMapPackage(ddlProChkList.SelectedValue.ToString()); }
private void btSave_Click(object sender, EventArgs e) { exc = new ExcData(); string SQL = string.Empty; string SQLChk = string.Empty; int NowRow = 0; foreach (DataGridViewRow row in gvPackage.Rows) { //Loop ทำงานเฉพาะคนที่ Check Box if (Convert.ToBoolean(row.Cells["Check"].Value) == true) { SQLChk = "SELECT * FROM [tblProchklistMapPackage] where ProChkList = '" + ddlProChkList.SelectedValue.ToString() + "' and PackageCode = '" + gvPackage.Rows[NowRow].Cells["Code"].Value.ToString() + "' and StatusFlag = 'A'"; DataTable dtChk = new DataTable(); dtChk = exc.data_Table(SQLChk); if (dtChk.Rows.Count <= 0 || dtChk == null) { SQL = "INSERT INTO [tblProchklistMapPackage]([ProChkList] ,[PackageCode] ,[StatusFlag])" + " VALUES('" + ddlProChkList.SelectedValue.ToString() + "' ,'" + gvPackage.Rows[NowRow].Cells["Code"].Value.ToString() + "' ,'A')"; if (exc.ExecData(SQL) == false) { MessageBox.Show("Save package code : " + gvPackage.Rows[NowRow].Cells["Code"].Value.ToString() + " failed."); } } } NowRow++; } BindProchklistMapPackage(ddlProChkList.SelectedValue.ToString()); }
public void Update_TblPatientList(string Forename, string Surname, string DOE, string DOB) { ExcData exc = new ExcData(); string SQL = @"UPDATE [tblPatientList] SET [STS] = 'C' WHERE [Forename] = '" + Forename.Trim() +"' and [Surname] = '" + Surname.Trim() +"' and [DOE] = '" + DOE +"' and [DOB] = '" + DOB +"'"; try { exc.ExecData(SQL); } catch (Exception ex) { ex.ToString(); //MessageBox.Show("Cannot update EN :" + EN + " in Contact Database"); } }