public bool UpdateRecord(Model.Management.Master.SiteMaster_stm_Info infoObject)
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
SiteMaster_stm stm = new SiteMaster_stm();
try
{
stm = db.SiteMaster_stms.SingleOrDefault(t => t.stm_iRecordID == infoObject.stm_iRecordID);
if (stm != null)
{
stm.stm_cBuildingNumber = infoObject.stm_cBuildingNumber;
stm.stm_cName = infoObject.stm_cName;
stm.stm_cNumber = infoObject.stm_cNumber;
stm.stm_cRemark = infoObject.stm_cRemark;
stm.stm_cLast = infoObject.stm_cLast;
stm.stm_dLastDate = infoObject.stm_dLastDate.Value;
db.SubmitChanges();
}
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool InsertRecord(Model.Management.Master.SiteMaster_stm_Info infoObject)
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
SiteMaster_stm stm = new SiteMaster_stm();
try
{
stm = Common.General.CopyObjectValue <Model.Management.Master.SiteMaster_stm_Info, SiteMaster_stm>(infoObject);
db.SiteMaster_stms.InsertOnSubmit(stm);
db.SubmitChanges();
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public List <Model.Management.Master.SiteMaster_stm_Info> SearchRecords(Model.IModel.IModelObject MDobject)
{
string sqlString = string.Empty;
string whereString = string.Empty;
sqlString = "SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString() + Environment.NewLine;
sqlString += " stm.stm_iRecordID," + Environment.NewLine;
sqlString += " stm.stm_cNumber," + Environment.NewLine;
sqlString += " bdm.bdm_cName AS BuildingName," + Environment.NewLine;
sqlString += " stm.stm_cName," + Environment.NewLine;
sqlString += " stm.stm_cRemark, " + Environment.NewLine;
sqlString += " stm.stm_cAdd," + Environment.NewLine;
sqlString += " stm.stm_dAddDate," + Environment.NewLine;
sqlString += " stm.stm_cLast," + Environment.NewLine;
sqlString += " stm.stm_dLastDate " + Environment.NewLine;
sqlString += " FROM SiteMaster_stm stm" + Environment.NewLine;
sqlString += " LEFT JOIN BuildingMaster_bdm bdm" + Environment.NewLine;
sqlString += " ON stm.stm_cBuildingNumber=bdm.bdm_cNumber" + Environment.NewLine;
model.SiteMaster_stm_Info stm_info = null;
stm_info = MDobject as model.SiteMaster_stm_Info;
if (stm_info != null)
{
whereString = " WHERE 1=1 ";
if (stm_info.stm_cBuildingNumber.Trim() != "")
{
whereString += " AND stm_cBuildingNumber='" + stm_info.stm_cBuildingNumber.Trim() + "'" + Environment.NewLine;
}
if (stm_info.stm_cNumber.Trim() != "")
{
if (stm_info.stm_cNumber.ToString().Contains("*") || stm_info.stm_cNumber.ToString().Contains("?"))
{
whereString += " AND stm_cNumber LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(stm_info.stm_cNumber) + "'";
}
else
{
whereString += "AND stm_cNumber = N'" + stm_info.stm_cNumber.ToString().Trim() + "'";
}
}
if (stm_info.stm_cName.Trim() != "")
{
if (stm_info.stm_cName.ToString().Contains("*") || stm_info.stm_cName.ToString().Contains("?"))
{
whereString += " AND stm_cName LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(stm_info.stm_cName) + "'";
}
else
{
whereString += "AND stm_cName = N'" + stm_info.stm_cName.ToString().Trim() + "'";
}
}
}
sqlString += whereString;
IEnumerable <model.SiteMaster_stm_Info> infos = null;
List <model.SiteMaster_stm_Info> infoList = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <model.SiteMaster_stm_Info>(sqlString, new object[] { });
if (infos != null)
{
infoList = infos.ToList <model.SiteMaster_stm_Info>();
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(infoList);
}