public List <Model.Management.Master.SchoolMaster_scm_Info> SearchRecords(Model.IModel.IModelObject MDobject) { SchoolMaster_scm_Info info = null; IQueryable <SchoolMaster_scm> taQuery = null; info = Common.General.CopyObjectValue <Model.IModel.IModelObject, SchoolMaster_scm_Info>(MDobject); List <Model.Management.Master.SchoolMaster_scm_Info> list = new List <SchoolMaster_scm_Info>(); try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { taQuery = db.SchoolMaster_scm.Take(Common.DefineConstantValue.ListRecordMaxCount); if (info.scm_cName.ToString() != "") { if (info.scm_cName.ToString().IndexOf("*") != -1 || info.scm_cName.ToString().IndexOf("?") != -1) { taQuery = from t in taQuery where SqlMethods.Like(t.scm_cName, info.scm_cName.ToString().Replace("*", "%").Replace("?", "_")) select t; } else { taQuery = taQuery.Where(t => t.scm_cName.Contains(info.scm_cName)); } } if (info.scm_cNumber.ToString() != "") { if (info.scm_cNumber.ToString().IndexOf("*") != -1 || info.scm_cNumber.ToString().IndexOf("?") != -1) { taQuery = from t in taQuery where SqlMethods.Like(t.scm_cNumber, info.scm_cNumber.ToString().Replace("*", "%").Replace("?", "_")) select t; } else { taQuery = taQuery.Where(t => t.scm_cNumber.Contains(info.scm_cNumber)); } } if (taQuery != null) { foreach (SchoolMaster_scm t in taQuery.ToList()) { info = Common.General.CopyObjectValue <SchoolMaster_scm, SchoolMaster_scm_Info>(t); list.Add(info); } } } } catch (Exception Ex) { throw Ex; } return(list); }
public Model.Management.Master.SchoolMaster_scm_Info GetRecord_Next(Model.Base.DataBaseCommandInfo commandInfo) { SchoolMaster_scm_Info info = null; try { info = this._schoolMasterDA.GetRecord_Next(commandInfo); } catch (Exception Ex) { throw Ex; } return(info); }
public Model.Management.Master.SchoolMaster_scm_Info GetRecord_Last() { SchoolMaster_scm_Info info = null; try { info = this._schoolMasterDA.GetRecord_Last(); } catch (Exception Ex) { throw Ex; } return(info); }
public Model.IModel.IModelObject GetTableFieldLenght() { LocalGeneral general = new LocalGeneral(); SchoolMaster_scm_Info info = null; try { info = general.GetTableFieldLenght <SchoolMaster_scm_Info>("SchoolMaster_scm"); } catch (Exception Ex) { throw Ex; } return(info); }