/// <summary>
/// Hàm insert Loại xét nghiệm
/// </summary>
/// <param name="pitems"></param>
/// <returns></returns>
public static string InsertTestTypeList(TTestTypeList pitems)
{
int i = 0;
Query queryRs = TTestTypeList.CreateQuery();
try
{
if (
!TTestTypeList.FetchByParameter(TTestTypeList.Columns.TestTypeId, Comparison.Equals,
pitems.TestTypeId).Read())
{
pitems.IsNew = true;
pitems.Save(i);
return(queryRs.GetMax(TTestTypeList.Columns.TestTypeId).ToString());
}
else
{
return("-1");
//throw new Exception(string.Format("Name:{0} Đã tồn tại", pitems.IPAddress));
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
txtID.Text = txtID.Text.ToUpper();
if (ValidData())
{
switch (vAction)
{
case action.Insert:
var obj = new TTestTypeList();
obj.TestTypeName = Utility.sDbnull(txtName.Text);
obj.IntOrder = Utility.ByteDbnull(txtSequence.Value);
obj.Abbreviation = Utility.sDbnull(txtAbbreviation.Text);
obj.Note = Utility.sDbnull(txtDesc.Text);
obj.Price = Utility.DecimaltoDbnull(txtPrice.Value);
obj.PrintDetail = Utility.ByteDbnull(ckbPrintDetail.Checked ? 1 : 0);
obj.IsNew = true;
obj.Save();
drList = dtList.NewRow();
drList[TTestTypeList.Columns.TestTypeId] =
TTestTypeList.CreateQuery().GetMax(TTestTypeList.Columns.TestTypeId);
ApplyData2Datarow();
dtList.Rows.InsertAt(drList, 0);
dtList.AcceptChanges();
txtID.Text = Utility.sDbnull(drList[TTestTypeList.Columns.TestTypeId]);
vAction = action.Update;
break;
case action.Update:
new Update(TTestTypeList.Schema.Name).Set(TTestTypeList.Columns.TestTypeName).EqualTo(
txtName.Text).
Set(TTestTypeList.Columns.IntOrder).EqualTo(txtSequence.Value).
Set(TTestTypeList.Columns.Abbreviation).EqualTo(txtAbbreviation.Text).
Set(TTestTypeList.Columns.Note).EqualTo(txtDesc.Text).
Set(TTestTypeList.Columns.Price).EqualTo(txtPrice.Value).
Set(TTestTypeList.Columns.PrintDetail).EqualTo(
Utility.ByteDbnull(ckbPrintDetail.Checked ? 1 : 0)).
Where(TTestTypeList.Columns.TestTypeId).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).
Execute();
ApplyData2Datarow();
drList.AcceptChanges();
break;
}
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
