/// <summary> /// Insert một bản ghi vào bảng Danh mục dùng chung /// </summary> /// <param name="obj"></param> /// <returns></returns> public void InsertList(DmucChung obj, int intSTTCu, ref string ActResult) { try { ActionResult _act = isExistedRecord(obj.Ma, obj.Loai); if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception) { ActResult = _act.ToString(); return; } //B1: Tim ban ghi co STT=STT moi DmucChungCollection v_lstDmuc = new DmucChungController().FetchByQuery(DmucChung.CreateQuery().AddWhere(DmucChung.Columns.SttHthi, Comparison.Equals, obj.SttHthi).AND(DmucChung.Columns.Loai, Comparison.Equals, obj.Loai)); if (v_lstDmuc.Count > 0) { new Update(DmucChung.Schema).Set(DmucChung.Columns.SttHthi).EqualTo(intSTTCu) .Where(DmucChung.Columns.Ma).IsEqualTo(v_lstDmuc[0].Ma) .And(DmucChung.Columns.Loai).IsEqualTo(v_lstDmuc[0].Loai).Execute(); } obj.IsNew = true; obj.Save(); if (Utility.Byte2Bool(obj.TrangthaiMacdinh)) { new Update(DmucChung.Schema).Set(DmucChung.Columns.TrangthaiMacdinh).EqualTo(0) .Where(DmucChung.Columns.Ma).IsNotEqualTo(obj.Ma) .And(DmucChung.Columns.Loai).IsEqualTo(obj.Loai).Execute(); } ActResult = ActionResult.Success.ToString(); } catch { ActResult = ActionResult.Exception.ToString(); } }
/// <summary> /// Update một bản ghi vào bảng Danh mục dùng chung /// </summary> /// <param name="obj"></param> /// <returns></returns> public void UpdateList(DmucChung obj, string strOldCode, int intSTTCu, ref string ActResult) { try { ActionResult _act = isExistedRecord4Update(obj.Loai, obj.Ma, strOldCode); if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception) { ActResult = _act.ToString(); return; } //B1: Tim ban ghi co STT=STT moi DmucChungCollection v_lstDmuc = new DmucChungController().FetchByQuery(DmucChung.CreateQuery().AddWhere(DmucChung.Columns.SttHthi, Comparison.Equals, obj.SttHthi).AND(DmucChung.Columns.Loai, Comparison.Equals, obj.Loai)); if (v_lstDmuc.Count > 0) { new Update(DmucChung.Schema).Set(DmucChung.Columns.SttHthi).EqualTo(intSTTCu) .Where(DmucChung.Columns.Ma).IsEqualTo(v_lstDmuc[0].Ma) .And(DmucChung.Columns.Loai).IsEqualTo(v_lstDmuc[0].Loai).Execute(); } if (Utility.Byte2Bool(obj.TrangthaiMacdinh)) { new Update(DmucChung.Schema).Set(DmucChung.Columns.TrangthaiMacdinh).EqualTo(0) .Where(DmucChung.Columns.Ma).IsNotEqualTo(obj.Ma) .And(DmucChung.Columns.Loai).IsEqualTo(obj.Loai).Execute(); } int record = new Update(DmucChung.Schema) .Set(DmucChung.Columns.Ma).EqualTo(obj.Ma) .Set(DmucChung.Columns.Ten).EqualTo(obj.Ten) .Set(DmucChung.Columns.VietTat).EqualTo(obj.VietTat) .Set(DmucChung.Columns.SttHthi).EqualTo(obj.SttHthi) .Set(DmucChung.Columns.MotaThem).EqualTo(obj.MotaThem) .Set(DmucChung.Columns.TrangThai).EqualTo(obj.TrangThai) .Set(DmucChung.Columns.TrangthaiMacdinh).EqualTo(obj.TrangthaiMacdinh) .Set(DmucChung.Columns.NgaySua).EqualTo(obj.NgaySua) .Set(DmucChung.Columns.NguoiSua).EqualTo(obj.NguoiSua) .Where(DmucChung.Columns.Ma).IsEqualTo(strOldCode). And(DmucChung.Columns.Loai).IsEqualTo(obj.Loai).Execute(); if (record > 0) { ActResult = ActionResult.Success.ToString(); } else { ActResult = ActionResult.Error.ToString(); } } catch { ActResult = ActionResult.Exception.ToString(); } }
public short GetMaxSTT(string m_strListType) { try { DmucChungCollection CollectionData = new DmucChungController().FetchByQuery(DmucChung.CreateQuery().AddWhere(DmucChung.Columns.Loai, Comparison.Equals, m_strListType)); int shtMaxSTT = 0; //Phải kiểm tra nếu Có dữ liệu mới lấy STT hiện tại=MaxSTT+1 if (CollectionData.Count > 0) { shtMaxSTT = CollectionData.Max(c => c.SttHthi); } return(Convert.ToInt16(shtMaxSTT + 1)); } catch { return(Convert.ToInt16(1)); } }
public ActionResult isExistedRecord4Update(string Loai, string MaMoi, string MaCu) { try { DmucChungCollection v_obj = new DmucChungController().FetchByQuery(DmucChung.CreateQuery() .AddWhere(DmucChung.Columns.Ma, Comparison.NotEquals, MaCu) .AND(DmucChung.Columns.Loai, Comparison.Equals, Loai)); List <DmucChung> q = (from p in v_obj where p.Ma == MaMoi select p).ToList <DmucChung>(); if (q.Count() > 0) { return(ActionResult.ExistedRecord); } return(ActionResult.Success); } catch { return(ActionResult.Exception); } }