public Model.SysMaster.DepartmentMaster_dpm_Info GetRecord_Previous(Model.Base.DataBaseCommandInfo commandInfo) { Model.SysMaster.DepartmentMaster_dpm_Info info = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { string iRecordId = string.Empty; foreach (var id in commandInfo.KeyInfoList) { iRecordId = id.KeyValue; break; } IQueryable <DepartmentMaster_dpm> taQuery = (from dpms in db.DepartmentMaster_dpms where dpms.dpm_iRecordID < Convert.ToInt32(iRecordId) orderby dpms.dpm_iRecordID descending select dpms).Take(1); if (taQuery.Count() > 0) { foreach (var t in taQuery) { info = Common.General.CopyObjectValue <DepartmentMaster_dpm, model.DepartmentMaster_dpm_Info>(t); } } return(info); } } catch (Exception Ex) { return(info); } }
public Model.SysMaster.DepartmentMaster_dpm_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { Model.SysMaster.DepartmentMaster_dpm_Info dpm = new Model.SysMaster.DepartmentMaster_dpm_Info(); Model.SysMaster.DepartmentMaster_dpm_Info info = new Model.SysMaster.DepartmentMaster_dpm_Info(); dpm = KeyObject as Model.SysMaster.DepartmentMaster_dpm_Info; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { IQueryable <DepartmentMaster_dpm> taQuery = (from dpms in db.DepartmentMaster_dpms where dpms.dpm_iRecordID == dpm.dpm_iRecordID //orderby dpms.dpm_iRecordID ascending select dpms).Take(1); if (taQuery != null) { foreach (var t in taQuery) //foreach (DepartmentMaster_dpm t in taQuery) { info = Common.General.CopyObjectValue <DepartmentMaster_dpm, model.DepartmentMaster_dpm_Info>(t); } } return(info); } } catch (Exception Ex) { throw Ex; } }
public Model.SysMaster.DepartmentMaster_dpm_Info GetRecord_Last() { try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { IQueryable <DepartmentMaster_dpm> taQuery = (from dpms in db.DepartmentMaster_dpms orderby dpms.dpm_iRecordID descending select dpms).Take(1); Model.SysMaster.DepartmentMaster_dpm_Info info = new Model.SysMaster.DepartmentMaster_dpm_Info(); if (taQuery.Count() > 0) { foreach (var t in taQuery) { info = Common.General.CopyObjectValue <DepartmentMaster_dpm, model.DepartmentMaster_dpm_Info>(t); } } return(info); } } catch (Exception Ex) { throw Ex; } }
public Model.IModel.IModelObject GetTableFieldLenght() { LocalGeneral general = new LocalGeneral(); model.DepartmentMaster_dpm_Info info = null; try { info = general.GetTableFieldLenght <model.DepartmentMaster_dpm_Info>("DepartmentMaster_dpm"); } catch (Exception Ex) { throw Ex; } return(info); }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { Model.SysMaster.DepartmentMaster_dpm_Info info = null; try { info = KeyObject as Model.SysMaster.DepartmentMaster_dpm_Info; using (VPMSDBDataContext db = new VPMSDBDataContext()) { DepartmentMaster_dpm dpm = db.DepartmentMaster_dpms.Single <DepartmentMaster_dpm>(i => i.dpm_iRecordID == info.dpm_iRecordID); db.DepartmentMaster_dpms.DeleteOnSubmit(dpm); db.SubmitChanges(); return(true); } } catch (Exception Ex) { throw Ex; } }
public bool InsertRecord(Model.SysMaster.DepartmentMaster_dpm_Info infoObject) { using (VPMSDBDataContext db = new VPMSDBDataContext()) { DepartmentMaster_dpm dpm = new DepartmentMaster_dpm(); try { dpm = Common.General.CopyObjectValue <model.DepartmentMaster_dpm_Info, DepartmentMaster_dpm>(infoObject); db.DepartmentMaster_dpms.InsertOnSubmit(dpm); db.SubmitChanges(); return(true); } catch (Exception Ex) { throw Ex; } } }
public bool UpdateRecord(Model.SysMaster.DepartmentMaster_dpm_Info infoObject) { using (VPMSDBDataContext db = new VPMSDBDataContext()) { //DepartmentMaster_dpm dpm = new DepartmentMaster_dpm(); try { //dpm = db.DepartmentMaster_dpms.SingleOrDefault(t => t.dpm_iRecordID == infoObject.dpm_iRecordID); //model.DepartmentMaster_dpm_Info info = new Model.SysMaster.DepartmentMaster_dpm_Info(); //info = Common.General.CopyObjectValue<DepartmentMaster_dpm, Model.SysMaster.DepartmentMaster_dpm_Info>(dpm); string sqlString = string.Empty; IEnumerable <Model.SysMaster.DepartmentMaster_dpm_Info> IEdpm = null; sqlString += "UPDATE DepartmentMaster_dpm" + Environment.NewLine; sqlString += " SET dpm_cNumber='" + infoObject.dpm_cNumber + "'," + Environment.NewLine; sqlString += " dpm_cName='" + infoObject.dpm_cName + "'," + Environment.NewLine; sqlString += " dpm_cRemark='" + infoObject.dpm_cRemark + "'," + Environment.NewLine; sqlString += " dpm_cLast='" + infoObject.dpm_cLast + "'," + Environment.NewLine; sqlString += " dpm_dLastDate='" + infoObject.dpm_dLastDate.Value.ToString(DefineConstantValue.gc_DateTimeFormat) + "'" + Environment.NewLine; sqlString += " WHERE dpm_iRecordID='" + infoObject.dpm_iRecordID + "'"; IEdpm = db.ExecuteQuery <Model.SysMaster.DepartmentMaster_dpm_Info>(sqlString, new object[] { }); //if (dpm != null) //{ // dpm.dpm_cName = infoObject.dpm_cName; // dpm.dpm_cNumber = infoObject.dpm_cNumber; // dpm.dpm_cRemark = infoObject.dpm_cRemark; // dpm.dpm_cLast = infoObject.dpm_cLast; // dpm.dpm_dLastDate = infoObject.dpm_dLastDate.Value; // db.SubmitChanges(); //} return(true); } catch (Exception Ex) { throw Ex; } } }
public List <Model.SysMaster.DepartmentMaster_dpm_Info> SearchRecords(Model.IModel.IModelObject MDobject) { string sqlString = string.Empty; string whereString = string.Empty; sqlString = "SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString() + Environment.NewLine; sqlString += " dpm_iRecordID," + Environment.NewLine; sqlString += " dpm_cNumber," + Environment.NewLine; sqlString += " dpm_cName," + Environment.NewLine; sqlString += " dpm_cRemark, " + Environment.NewLine; sqlString += " dpm_cAdd," + Environment.NewLine; sqlString += " dpm_dAddDate," + Environment.NewLine; sqlString += " dpm_cLast," + Environment.NewLine; sqlString += " dpm_dLastDate " + Environment.NewLine; sqlString += " FROM DepartmentMaster_dpm" + Environment.NewLine; model.DepartmentMaster_dpm_Info dpm_info = null; dpm_info = MDobject as model.DepartmentMaster_dpm_Info; if (dpm_info != null) { whereString = " WHERE 1=1 "; if (dpm_info.dpm_cNumber.Trim() != "") { if (dpm_info.dpm_cNumber.ToString().Contains("*") || dpm_info.dpm_cNumber.ToString().Contains("?")) { whereString += " AND dpm_cNumber LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(dpm_info.dpm_cNumber) + "'"; } else { whereString += "AND dpm_cNumber = N'" + dpm_info.dpm_cNumber.ToString().Trim() + "'"; } } if (dpm_info.dpm_cName.Trim() != "") { if (dpm_info.dpm_cName.ToString().Contains("*") || dpm_info.dpm_cName.ToString().Contains("?")) { whereString += " AND dpm_cName LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(dpm_info.dpm_cName) + "'"; } else { whereString += "AND dpm_cName = N'" + dpm_info.dpm_cName.ToString().Trim() + "'"; } } } sqlString += whereString; IEnumerable <model.DepartmentMaster_dpm_Info> infos = null; List <Model.SysMaster.DepartmentMaster_dpm_Info> infoList = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { infos = db.ExecuteQuery <model.DepartmentMaster_dpm_Info>(sqlString, new object[] { }); if (infos != null) { infoList = infos.ToList <Model.SysMaster.DepartmentMaster_dpm_Info>(); } } } catch (Exception Ex) { throw Ex; } return(infoList); }