public Model.Management.Master.SchoolMaster_scm_Info GetRecord_Last()
{
IQueryable <SchoolMaster_scm> taQuery = null;
Model.Management.Master.SchoolMaster_scm_Info tab = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
taQuery =
(from ta in db.SchoolMaster_scm
orderby ta.scm_iRecordID descending
select ta).Take(1);
foreach (SchoolMaster_scm t in taQuery)
{
tab = Common.General.CopyObjectValue <SchoolMaster_scm, Model.Management.Master.SchoolMaster_scm_Info>(t);
break;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(tab);
}
public bool UpdateRecord(Model.Management.Master.SchoolMaster_scm_Info infoObject)
{
SchoolMaster_scm tab = new SchoolMaster_scm();
bool isSuccess = false;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
tab = db.SchoolMaster_scm.SingleOrDefault(t => t.scm_cNumber == infoObject.scm_cNumber);
if (tab != null)
{
tab.scm_cName = infoObject.scm_cName;
tab.scm_cRemark = infoObject.scm_cRemark;
tab.scm_cLast = infoObject.scm_cLast;
tab.scm_dLastDate = infoObject.scm_dLastDate;
//tab=Common.General.SetDataToLingQEntity(tab, infoObject);
}
db.SubmitChanges();
isSuccess = true;
}
}
catch (Exception Ex)
{
throw Ex;
}
return(isSuccess);
}
private bool InsertRecord(Model.Management.Master.SchoolMaster_scm_Info infoObject)
{
bool tabB = _schoolMasterDA.IsExistRecord((infoObject as SchoolMaster_scm_Info).scm_cNumber);
if (!tabB)
{
return(_schoolMasterDA.InsertRecord(infoObject));
}
return(false);
}
public Model.Management.Master.SchoolMaster_scm_Info GetRecord_Previous(Model.Base.DataBaseCommandInfo commandInfo)
{
string RecordID = null;
IQueryable <SchoolMaster_scm> taQuery = null;
Model.Management.Master.SchoolMaster_scm_Info tab = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
if (commandInfo.KeyInfoList != null)
{
//foreach (var t in commandInfo.KeyInfoList)
//{
// if (t.Key == "scm_iRecordID")
// {
// RecordID = t.KeyValue.ToString();
// break;
// }
//}
RecordID = commandInfo.KeyInfoList[0].KeyValue.ToString();
taQuery =
(from ta in db.SchoolMaster_scm
where ta.scm_iRecordID < Convert.ToInt32(RecordID)
orderby ta.scm_iRecordID descending
select ta).Take(1);
if (taQuery.Count() > 0)
{
foreach (SchoolMaster_scm t in taQuery)
{
tab = Common.General.CopyObjectValue <SchoolMaster_scm, SchoolMaster_scm_Info>(t);
break;
}
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(tab);
}
public bool InsertRecord(Model.Management.Master.SchoolMaster_scm_Info infoObject)
{
SchoolMaster_scm tab = null;
bool isSuccess = false;
tab = Common.General.CopyObjectValue <SchoolMaster_scm_Info, SchoolMaster_scm>(infoObject);
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
db.SchoolMaster_scm.InsertOnSubmit(tab);
db.SubmitChanges();
isSuccess = true;
}
}
catch (Exception Ex)
{
throw Ex;
}
return(isSuccess);
}
public Model.Management.Master.SchoolMaster_scm_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
model.SchoolMaster_scm_Info info = null;
SchoolMaster_scm tab = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
info = new model.SchoolMaster_scm_Info();
tab = db.SchoolMaster_scm.SingleOrDefault(t => t.scm_iRecordID == (KeyObject as SchoolMaster_scm_Info).RecordID);
}
}
catch (Exception Ex)
{
throw Ex;
}
if (tab != null)
{
info = Common.General.CopyObjectValue <SchoolMaster_scm, SchoolMaster_scm_Info>(tab);
}
return(info);
}
private bool UpdateRecord(Model.Management.Master.SchoolMaster_scm_Info infoObject)
{
return(_schoolMasterDA.UpdateRecord(infoObject));
}
