/// <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(DmucKieukham obj, int intSTTCu, ref string ActResult)
{
try
{
ActionResult _act = isExistedRecord(obj.MaKieukham);
if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception)
{
ActResult = _act.ToString();
return;
}
//B1: Tim ban ghi co STT=STT moi
DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi));
if (v_lstDmuc.Count > 0)
{
new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu)
.Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(v_lstDmuc[0].IdKieukham).Execute();
}
obj.IsNew = true;
obj.Save();
ActResult = ActionResult.Success.ToString();
}
catch
{
ActResult = ActionResult.Exception.ToString();
}
}
public void Insert(string MaKieukham,string TenKieukham,decimal? DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,short? SttHthi,string MaDoituongkcb,string NhomBaocao,byte? TrangThai,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua)
{
DmucKieukham item = new DmucKieukham();
item.MaKieukham = MaKieukham;
item.TenKieukham = TenKieukham;
item.DonGia = DonGia;
item.PhuthuDungtuyen = PhuthuDungtuyen;
item.PhuthuTraituyen = PhuthuTraituyen;
item.SttHthi = SttHthi;
item.MaDoituongkcb = MaDoituongkcb;
item.NhomBaocao = NhomBaocao;
item.TrangThai = TrangThai;
item.NguoiTao = NguoiTao;
item.NgayTao = NgayTao;
item.NguoiSua = NguoiSua;
item.NgaySua = NgaySua;
item.Save(UserName);
}
/// <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(DmucKieukham obj, int intSTTCu, ref string ActResult)
{
try
{
ActionResult _act = isExistedRecord(obj.MaKieukham);
if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception)
{
ActResult = _act.ToString();
return;
}
//B1: Tim ban ghi co STT=STT moi
DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi));
if (v_lstDmuc.Count > 0)
{
new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu)
.Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(v_lstDmuc[0].IdKieukham).Execute();
}
obj.IsNew = true;
obj.Save();
ActResult = ActionResult.Success.ToString();
}
catch
{
ActResult = ActionResult.Exception.ToString();
}
}
