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