public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode) { Model.General.ReturnValueInfo returnValue = new Model.General.ReturnValueInfo(); ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info(); returnValue.messageText = ""; info = itemEntity as ListColumnsMaster_lcm_Info; switch (EditMode) { case Common.DefineConstantValue.EditStateEnum.OE_Insert: bool isExist = false; isExist = _ListColumnsMasterDA.IsExistRecord(info); if (!isExist) { returnValue.boolValue = _ListColumnsMasterDA.InsertRecord(info); } else { returnValue.boolValue = false; returnValue.messageText = "数据重复!"; } break; case Common.DefineConstantValue.EditStateEnum.OE_Update: returnValue.boolValue = _ListColumnsMasterDA.UpdateRecord(info); break; case Common.DefineConstantValue.EditStateEnum.OE_Delete: returnValue.boolValue = _ListColumnsMasterDA.DeleteRecord(info); break; default: break; } return returnValue; }
public ListColumnsMaster_lcm_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info(); using (MainDBDataContext db = new MainDBDataContext()) { ListColumnsMaster_lcm disTab = db.ListColumnsMaster_lcm.SingleOrDefault(t => t.lcm_iRecordID == ((KeyObject) as ListColumnsMaster_lcm_Info).lcm_iRecordID); if (disTab != null) { info = Common.General.CopyObjectValue<ListColumnsMaster_lcm, ListColumnsMaster_lcm_Info>(disTab); } } return info; }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info(); info = KeyObject as ListColumnsMaster_lcm_Info; using (MainDBDataContext db = new MainDBDataContext()) { ListColumnsMaster_lcm delTab = db.ListColumnsMaster_lcm.SingleOrDefault(t => t.lcm_iRecordID == info.lcm_iRecordID); if (delTab != null) { db.ListColumnsMaster_lcm.DeleteOnSubmit(delTab); db.SubmitChanges(); isSuccess = true; } } return isSuccess; }
public List<ListColumnsMaster_lcm_Info> FindRecord(ListColumnsMaster_lcm_Info info) { return SearchRecords(info); }
public bool UpdateRecord(ListColumnsMaster_lcm_Info infoObject) { bool isSuccess = false; try { using (MainDBDataContext db = new MainDBDataContext()) { ListColumnsMaster_lcm query = db.ListColumnsMaster_lcm.SingleOrDefault(t => t.lcm_iRecordID == infoObject.lcm_iRecordID); if (query != null) { query.lcm_cValueFormat = infoObject.lcm_cValueFormat; query.lcm_cName = infoObject.lcm_cName; query.lcm_iWidth = infoObject.lcm_iWidth; query.lcm_iSeq = infoObject.lcm_iSeq; query.lcm_lIsActive = infoObject.lcm_lIsActive; query.lcm_cLastBy = infoObject.lcm_cLastBy; query.lcm_dLastDate = infoObject.lcm_dLastDate; db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public List<ListColumnsMaster_lcm_Info> SearchRecords(Model.IModel.IModelObject searchCondition) { List<ListColumnsMaster_lcm_Info> list = new List<ListColumnsMaster_lcm_Info>(); ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info(); info = searchCondition as ListColumnsMaster_lcm_Info; StringBuilder sqlString = new StringBuilder(); sqlString.AppendLine("SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString()); sqlString.AppendLine("*"); sqlString.AppendLine("FROM dbo.ListColumnsMaster_lcm"); sqlString.AppendLine("WHERE 1=1"); if (info.lcm_cMainType != "") { sqlString.AppendLine("AND lcm_cMainType='" + info.lcm_cMainType + "'"); } if (info.lcm_cSubType != "") { sqlString.AppendLine("AND lcm_cSubType='" + info.lcm_cSubType + "'"); } if (info.lcm_cValue != "") { sqlString.AppendLine("AND lcm_cSubType='" + info.lcm_cValue + "'"); } IEnumerable<ListColumnsMaster_lcm_Info> infos = null; using (MainDBDataContext db = new MainDBDataContext()) { infos = db.ExecuteQuery<ListColumnsMaster_lcm_Info>(sqlString.ToString(), new object[] { }); if (infos != null) { list = infos.ToList<ListColumnsMaster_lcm_Info>(); } } return list; }
public bool IsExistRecord(object KeyObject) { ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info(); info = KeyObject as ListColumnsMaster_lcm_Info; using (MainDBDataContext db = new MainDBDataContext()) { ListColumnsMaster_lcm query = db.ListColumnsMaster_lcm.First(); if (query != null) { return true; } } return false; }
public bool InsertRecord(ListColumnsMaster_lcm_Info infoObject) { bool isSuccess = false; ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info(); info = infoObject; using (MainDBDataContext db = new MainDBDataContext()) { ListColumnsMaster_lcm newTab = Common.General.CopyObjectValue<ListColumnsMaster_lcm_Info, ListColumnsMaster_lcm>(info); db.ListColumnsMaster_lcm.InsertOnSubmit(newTab); db.SubmitChanges(); isSuccess = true; } return isSuccess; }
public List<ListColumnsMaster_lcm_Info> FindRecord(ListColumnsMaster_lcm_Info info) { return _ListColumnsMasterDA.FindRecord(info); }