/// <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; } }
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 Insert dữ liệu vào bảng Manufacture /// </summary> /// <param name="pitems"></param> /// <returns></returns> public static string InsertManufacture(LManufacture pitems) { int i = 0; Query queryRs = LManufacture.CreateQuery(); try { if (!LManufacture.FetchByParameter(LManufacture.Columns.Id, Comparison.Equals, pitems.Id).Read()) { pitems.IsNew = true; pitems.Save(i); return(queryRs.GetMax(LManufacture.Columns.Id).ToString()); } else { return("-1"); //throw new Exception(string.Format("Name:{0} Đã tồn tại", pitems.IPAddress)); } } catch (Exception ex) { throw ex; } }
public void Insert(string SName,string SDesc) { LManufacture item = new LManufacture(); item.SName = SName; item.SDesc = SDesc; item.Save(UserName); }
public void Update(short Id,string SName,string SDesc) { LManufacture item = new LManufacture(); item.MarkOld(); item.IsLoaded = true; item.Id = Id; item.SName = SName; item.SDesc = SDesc; item.Save(UserName); }