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