public ArticleTypeDefine_atd_Info GetTreeRoot(string codeMasterDefineKey2) { ArticleTypeDefine_atd_Info treeRootInfo = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { CodeMaster_cmt root = db.CodeMaster_cmts.FirstOrDefault(t => t.cmt_cKey1 == DefineConstantValue.CodeMasterDefine.KEY1_SIOT_ARTICLETYPEDEFINE && t.cmt_cKey2 == codeMasterDefineKey2.ToString()); if (root != null) { treeRootInfo = new ArticleTypeDefine_atd_Info(); treeRootInfo.atd_cTypeNum = root.cmt_cKey2; treeRootInfo.atd_cDescript = root.cmt_cValue; treeRootInfo.atd_lValid = true; } } } catch (Exception Ex) { throw Ex; } return(treeRootInfo); }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; CodeMaster_cmt_Info info = new CodeMaster_cmt_Info(); info = KeyObject as CodeMaster_cmt_Info; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { CodeMaster_cmt delTab = db.CodeMaster_cmts.SingleOrDefault(t => t.cmt_iRecordID == info.cmt_iRecordID); if (delTab != null) { db.CodeMaster_cmts.DeleteOnSubmit(delTab); db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } return(isSuccess); }
public bool UpdateRecord(CodeMaster_cmt_Info infoObject) { bool isSuccess = false; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { CodeMaster_cmt query = db.CodeMaster_cmts.SingleOrDefault(t => t.cmt_iRecordID == infoObject.cmt_iRecordID); if (query != null) { query.cmt_cKey1 = infoObject.cmt_cKey1; query.cmt_cKey2 = infoObject.cmt_cKey2; query.cmt_cValue = infoObject.cmt_cValue; query.cmt_fNumber = infoObject.cmt_fNumber; query.cmt_cRemark = infoObject.cmt_cRemark; query.cmt_cRemark2 = infoObject.cmt_cRemark2; query.cmt_cLast = infoObject.cmt_cLast; query.cmt_dLastDate = infoObject.cmt_dLastDate; db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } return(isSuccess); }
public CodeMaster_cmt_Info GetRecord_Last() { CodeMaster_cmt_Info info; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { CodeMaster_cmt query = db.CodeMaster_cmts.OrderByDescending(t => t.cmt_iRecordID).FirstOrDefault(); info = Common.General.CopyObjectValue <CodeMaster_cmt, CodeMaster_cmt_Info>(query); } } catch (Exception Ex) { throw Ex; } return(info); }
public CodeMaster_cmt_Info GetRecord_Next(Model.Base.DataBaseCommandInfo commandInfo) { CodeMaster_cmt_Info info; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { CodeMaster_cmt query = db.CodeMaster_cmts .Where(t => t.cmt_iRecordID > Convert.ToInt32(commandInfo.KeyInfoList[0].KeyValue)) .OrderBy(t => t.cmt_iRecordID) .FirstOrDefault(); info = Common.General.CopyObjectValue <CodeMaster_cmt, CodeMaster_cmt_Info>(query); } } catch (Exception Ex) { throw Ex; } return(info); }
public CodeMaster_cmt_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { CodeMaster_cmt_Info info = new CodeMaster_cmt_Info(); try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { CodeMaster_cmt disTab = db.CodeMaster_cmts.SingleOrDefault(t => t.cmt_iRecordID == ((KeyObject) as CodeMaster_cmt_Info).cmt_iRecordID); if (disTab != null) { info = Common.General.CopyObjectValue <CodeMaster_cmt, CodeMaster_cmt_Info>(disTab); } } } catch (Exception Ex) { throw Ex; } return(info); }
public bool IsExistRecord(object KeyObject) { CodeMaster_cmt_Info info = new CodeMaster_cmt_Info(); info = KeyObject as CodeMaster_cmt_Info; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { CodeMaster_cmt query = db.CodeMaster_cmts.SingleOrDefault(t => t.cmt_cKey1 == info.cmt_cKey1 && t.cmt_cKey2 == info.cmt_cKey2); if (query != null) { return(true); } } } catch (Exception Ex) { throw Ex; } return(false); }
public bool InsertRecord(CodeMaster_cmt_Info infoObject) { bool isSuccess = false; CodeMaster_cmt_Info info = new CodeMaster_cmt_Info(); info = infoObject; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { CodeMaster_cmt newTab = Common.General.CopyObjectValue <CodeMaster_cmt_Info, CodeMaster_cmt>(info); db.CodeMaster_cmts.InsertOnSubmit(newTab); db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return(isSuccess); }