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");
}
}
