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);
}
}
/// <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 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;
}
}