private void cmdAccept_Click(object sender, EventArgs e)
{
try
{
QueryCommand cmd = DmucNoiKCBBD.CreateQuery().BuildCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandSql = "Select * from dmuc_noiKCBBD WHERE ma_kcbbd='" + txtMa.Text + "' AND ma_diachinh='" + txtMaThanhPho.Text.Trim() + "'";
DataTable temdt = DataService.GetDataSet(cmd).Tables[0];
if (temdt.Rows.Count <= 0)
{
DmucNoiKCBBD newItem = new DmucNoiKCBBD();
newItem.MaDiachinh = txtMaThanhPho.Text.Trim();
newItem.MaKcbbd = txtMa.Text.Trim();
newItem.TenKcbbd = txtTen.Text.Trim();
newItem.SttHthi = 9999;
newItem.IsNew = true;
newItem.Save();
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
Utility.ShowMsg(string.Format("Mã {0}: đang thuộc về nơi KCBBĐ {1}. Mời bạn kiểm tra lại", txtMa, Utility.sDbnull(temdt.Rows[0]["ten_kcbbd"].ToString(), "")));
txtMa.Focus();
}
}
catch
{
}
}
private void cmdAccept_Click(object sender, EventArgs e)
{
try
{
QueryCommand cmd = DmucNoiKCBBD.CreateQuery().BuildCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandSql = "Select * from dmuc_noiKCBBD WHERE ma_kcbbd='" + txtMa.Text + "' AND ma_diachinh='" + txtMaThanhPho.Text.Trim() + "'";
DataTable temdt = DataService.GetDataSet(cmd).Tables[0];
if (temdt.Rows.Count <= 0)
{
DmucNoiKCBBD newItem = new DmucNoiKCBBD();
newItem.MaDiachinh = txtMaThanhPho.Text.Trim();
newItem.MaKcbbd = txtMa.Text.Trim();
newItem.TenKcbbd = txtTen.Text.Trim();
newItem.SttHthi = 9999;
newItem.IsNew = true;
newItem.Save();
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
Utility.ShowMsg(string.Format("Mã {0}: đang thuộc về nơi KCBBĐ {1}. Mời bạn kiểm tra lại", txtMa, Utility.sDbnull(temdt.Rows[0]["ten_kcbbd"].ToString(), "")));
txtMa.Focus();
}
}
catch
{
}
}
/// <summary>
/// hàm thực hiện kiểm tra thông tin của phần Update
/// </summary>
/// <returns></returns>
private bool InValiUpdateData()
{
if (string.IsNullOrEmpty(txtClinicCode.Text))
{
Utility.SetMsgError(errorProvider1, txtClinicCode, "Bạn phải nhập mã KCBBĐ");
txtClinicCode.Focus();
return(false);
}
if (string.IsNullOrEmpty(txtDieaseName.Text))
{
Utility.SetMsgError(errorProvider2, txtDieaseName, "Bạn phải nhập tên KCBBĐ");
txtClinicCode.Focus();
return(false);
}
if (cboSurveys.SelectedIndex <= -1)
{
Utility.SetMsgError(errorProvider3, cboSurveys, "Bạn phải chọn địa chính");
cboSurveys.Focus();
return(false);
}
DmucNoiKCBBDCollection objDmucNoiKCBBDCollection = new DmucNoiKCBBDController().FetchByQuery(
DmucNoiKCBBD.CreateQuery().AddWhere(DmucNoiKCBBD.Columns.MaKcbbd, Comparison.Equals, txtClinicCode.Text)
.AND(DmucNoiKCBBD.Columns.IdKcbbd, Comparison.NotEquals, Utility.Int32Dbnull(txtClinic_ID.Text, -1)).AND
(DmucNoiKCBBD.Columns.MaDiachinh, Comparison.Equals, Utility.sDbnull(cboSurveys.SelectedValue, "")));
if (objDmucNoiKCBBDCollection.Count() > 0)
{
Utility.ShowMsg("Đã tồn tại mã khám chữa bệnh này");
txtClinicCode.Focus();
return(false);
}
if (objDmucNoiKCBBDCollection.Count() > 0)
{
Utility.ShowMsg("Đã tồn tại tên khám chữa bệnh này");
txtDieaseName.Focus();
return(false);
}
DmucNoiKCBBDCollection objClinicCollection = new DmucNoiKCBBDController().FetchByQuery(
DmucNoiKCBBD.CreateQuery().AddWhere(DmucNoiKCBBD.Columns.TenKcbbd, Comparison.Equals, txtDieaseName.Text).AND(
DmucNoiKCBBD.Columns.IdKcbbd, Comparison.NotEquals, Utility.Int32Dbnull(txtClinic_ID.Text, -1)).AND(
DmucNoiKCBBD.Columns.MaDiachinh, Comparison.Equals, Utility.sDbnull(cboSurveys.SelectedValue, "")));
if (objClinicCollection.Count() > 0)
{
Utility.ShowMsg("Đã tồn tại tên khám chữa bệnh này");
txtDieaseName.Focus();
return(false);
}
return(true);
}
private void GetData()
{
DmucNoiKCBBD objDisease = DmucNoiKCBBD.FetchByID(Utility.Int32Dbnull(txtClinic_ID.Text, -1));
if (objDisease != null)
{
txtsDesc.Text = objDisease.MotaThem;
txtClinicCode.Text = objDisease.MaKcbbd;
txtDieaseName.Text = objDisease.TenKcbbd;
cboSurveys.SelectedIndex = Utility.GetSelectedIndex(cboSurveys,
objDisease.MaDiachinh.ToString());
txtIntOrder.Value = Utility.Int16Dbnull(objDisease.SttHthi, 1);
}
}
/// <summary>
/// hàm thực hiện chèn thêm thông tin
/// </summary>
private void PerformActionInsert()
{
DmucNoiKCBBD.Insert(Utility.sDbnull(cboSurveys.SelectedValue, ""), txtClinicCode.Text, Utility.sDbnull(txtDieaseName.Text, ""), Utility.Int16Dbnull(txtIntOrder.Text, 1), txtsDesc.Text, "");
DataRow dr = globalVariables.gv_dtDmucNoiKCBBD.NewRow();
dr[DmucNoiKCBBD.Columns.IdKcbbd] = Utility.Int32Dbnull(_Query.GetMax(DmucNoiKCBBD.Columns.IdKcbbd), -1);
dr[DmucNoiKCBBD.Columns.MaKcbbd] = txtClinicCode.Text;
dr[DmucNoiKCBBD.Columns.TenKcbbd] = Utility.sDbnull(txtDieaseName.Text, "");
dr[DmucNoiKCBBD.Columns.MaDiachinh] = Utility.sDbnull(cboSurveys.SelectedValue, "");
dr[DmucNoiKCBBD.Columns.MotaThem] = Utility.sDbnull(txtsDesc.Text, "");
dr[DmucNoiKCBBD.Columns.SttHthi] = Utility.Int16Dbnull(txtIntOrder.Text, 1);
dr[DmucDiachinh.Columns.TenDiachinh] = Utility.sDbnull(cboSurveys.Text, "");
globalVariables.gv_dtDmucNoiKCBBD.Rows.Add(dr);
Utility.GotoNewRowJanus(grdList, DmucNoiKCBBD.Columns.MaKcbbd, txtClinicCode.Text);
this.Close();
}
public void Insert(string MaDiachinh,string MaKcbbd,string TenKcbbd,short? SttHthi,string MotaThem,string DiaChi)
{
DmucNoiKCBBD item = new DmucNoiKCBBD();
item.MaDiachinh = MaDiachinh;
item.MaKcbbd = MaKcbbd;
item.TenKcbbd = TenKcbbd;
item.SttHthi = SttHthi;
item.MotaThem = MotaThem;
item.DiaChi = DiaChi;
item.Save(UserName);
}
public void Update(int IdKcbbd,string MaDiachinh,string MaKcbbd,string TenKcbbd,short? SttHthi,string MotaThem,string DiaChi)
{
DmucNoiKCBBD item = new DmucNoiKCBBD();
item.MarkOld();
item.IsLoaded = true;
item.IdKcbbd = IdKcbbd;
item.MaDiachinh = MaDiachinh;
item.MaKcbbd = MaKcbbd;
item.TenKcbbd = TenKcbbd;
item.SttHthi = SttHthi;
item.MotaThem = MotaThem;
item.DiaChi = DiaChi;
item.Save(UserName);
}
