/// <summary>
/// Hàm xóa dữ liệu bảng Manufacture
/// </summary>
/// <param name="pid"></param>
public static void DeleteManuafacture(int pid)
{
if (LManufacture.FetchByID(pid) != null)
{
LManufacture.Delete(pid);
}
}
private void LoadData()
{
LManufacture objManufacture = LManufacture.FetchByID(txtID.Text);
if (objManufacture != null)
{
txtName.Text = Utility.sDbnull(objManufacture.SName, "");
txtDesc.Text = Utility.sDbnull(objManufacture.SDesc, "");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
txtID.Text = txtID.Text.ToUpper();
LManufacture objManufacture;
if (ValidData())
{
switch (txtID.Text)
{
case "-1":
var obj = new LManufacture();
obj.SName = Utility.sDbnull(txtName.Text);
obj.SDesc = Utility.sDbnull(txtDesc.Text);
obj.IsNew = true;
obj.Save();
txtID.Text = Utility.sDbnull(LManufacture.CreateQuery().GetMax(LManufacture.Columns.Id));
objManufacture = LManufacture.FetchByID(Utility.Int32Dbnull(txtID.Text, -1));
if (objManufacture != null)
{
DataRow newDr = dtList.NewRow();
Utility.FromObjectToDatarow(objManufacture, ref newDr);
dtList.Rows.Add(newDr);
}
break;
default:
new Update(LManufacture.Schema.Name).Set(LManufacture.Columns.SName).EqualTo(txtName.Text).
Set(LManufacture.Columns.SDesc).EqualTo(txtDesc.Text).
Where(LManufacture.Columns.Id).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).
Execute();
objManufacture = LManufacture.FetchByID(Utility.Int32Dbnull(txtID.Text, -1));
if (objManufacture != null)
{
DataRow newDr = Utility.GetDataRow(dtList, LManufacture.Columns.Id, objManufacture.Id);
Utility.FromObjectToDatarow(objManufacture, ref newDr);
newDr.AcceptChanges();
}
break;
}
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
/// <summary>
/// Hàm update dữ liệu bảng Manufacture
/// </summary>
/// <param name="pitems"></param>
public static void UpdateManuafacture(LManufacture pitems)
{
try
{
if (LManufacture.FetchByID(pitems.Id) != null)
{
pitems.IsNew = false;
pitems.Save();
}
}
catch (Exception ex)
{
throw ex;
}
}
