public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
Sys_FunctionMaster_fum_Info info = null;
try
{
info = KeyObject as Sys_FunctionMaster_fum_Info;
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
Sys_FunctionMaster_fum fum = db.Sys_FunctionMaster_fum.Single<Sys_FunctionMaster_fum>(i => i.fum_iRecordID == info.fum_iRecordID);
//for (int i = 0; i < fum.Sys_FormPurview_frps.Count; i++)
//{
// Sys_FormPurview_frp sta = fum.Sys_FormPurview_frps[i];
// db.Sys_FormPurview_frps.DeleteOnSubmit(sta);
//}
db.Sys_FunctionMaster_fum.DeleteOnSubmit(fum);
db.SubmitChanges();
return true;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public Model.SysMaster.Sys_UserMaster_usm_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
Sys_UserMaster_usm_Info usm = new Sys_UserMaster_usm_Info();
Sys_UserMaster_usm_Info info = new Sys_UserMaster_usm_Info();
usm = KeyObject as Sys_UserMaster_usm_Info;
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IQueryable<Sys_UserMaster_usm> taQuery =
(from ta in db.Sys_UserMaster_usm
where ta.usm_iRecordID == usm.usm_iRecordID
select ta).Take(1);
if (taQuery != null)
{
foreach (Sys_UserMaster_usm t in taQuery)
{
info = Common.General.CopyObjectValue<Sys_UserMaster_usm, Sys_UserMaster_usm_Info>(t);
FindUserRole(info);
}
}
return info;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public List<UserCardPair_ucp_Info> AllRecords()
{
List<UserCardPair_ucp_Info> listPairInfo = null;
try
{
StringBuilder sbSQL = new StringBuilder();
sbSQL.AppendLine("SELECT ");
sbSQL.AppendLine("* FROM UserCardPair_ucp WHERE 1 = 1");
sbSQL.AppendLine("AND ucp_lIsActive = 1");
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IEnumerable<UserCardPair_ucp_Info> query = db.ExecuteQuery<UserCardPair_ucp_Info>(sbSQL.ToString(), new object[] { });
if (query != null)
{
listPairInfo = query.ToList<UserCardPair_ucp_Info>();
}
}
}
catch (Exception ex)
{
throw ex;
}
return listPairInfo;
}
public List<MealBookingHistory_mbh_Info> AllRecords()
{
List<MealBookingHistory_mbh_Info> listPairInfo = null;
try
{
StringBuilder sbSQL = new StringBuilder();
sbSQL.AppendLine("SELECT ");
sbSQL.AppendLine("* FROM MealBookingHistory_mbh WHERE 1 = 1");
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IEnumerable<MealBookingHistory_mbh_Info> query = db.ExecuteQuery<MealBookingHistory_mbh_Info>(sbSQL.ToString(), new object[] { });
if (query != null)
{
listPairInfo = query.ToList<MealBookingHistory_mbh_Info>();
}
}
}
catch (Exception ex)
{
throw ex;
}
return listPairInfo;
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
Sys_RoleMaster_rlm_Info info = null;
try
{
info = KeyObject as Sys_RoleMaster_rlm_Info;
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
Sys_RoleMaster_rlm rlm = db.Sys_RoleMaster_rlm.Single<Sys_RoleMaster_rlm>(i => i.rlm_iRecordID == info.rlm_iRecordID);
for (int i = 0; i < rlm.Sys_UserRoles_usr.Count; i++)
{
Sys_UserRoles_usr sta = rlm.Sys_UserRoles_usr[i];
db.Sys_UserRoles_usr.DeleteOnSubmit(sta);
}
db.Sys_RoleMaster_rlm.DeleteOnSubmit(rlm);
db.SubmitChanges();
return true;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public Sys_FormMaster_fom_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
Sys_FormMaster_fom_Info frm = new Sys_FormMaster_fom_Info();
Sys_FormMaster_fom_Info info = null;
frm = KeyObject as Sys_FormMaster_fom_Info;
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IQueryable<Sys_FormMaster_fom> taQuery =
(from ta in db.Sys_FormMaster_fom
where ta.fom_iRecordID == frm.fom_iRecordID
select ta).Take(1);
if (taQuery != null)
{
foreach (Sys_FormMaster_fom t in taQuery)
{
info = Common.General.CopyObjectValue<Sys_FormMaster_fom, Sys_FormMaster_fom_Info>(t);
FindFormPurview(info);
}
}
return info;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public PaymentUDMealState_pms_Info DisplayRecord(IModelObject KeyObject)
{
PaymentUDMealState_pms_Info displayInfo = KeyObject as PaymentUDMealState_pms_Info;
if (displayInfo != null)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
PaymentUDMealState_pms displayData = db.PaymentUDMealState_pms.FirstOrDefault(t => t.pms_cRecordID == displayInfo.pms_cRecordID);
if (displayData != null)
{
displayInfo = Common.General.CopyObjectValue<PaymentUDMealState_pms, PaymentUDMealState_pms_Info>(displayData);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
return displayInfo;
}
public ReturnValueInfo DeleteRecord(IModelObject KeyObject)
{
ReturnValueInfo returnInfo = new ReturnValueInfo(false);
PaymentUDMealState_pms_Info deleteInfo = KeyObject as PaymentUDMealState_pms_Info;
if (deleteInfo != null)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
PaymentUDMealState_pms deleteData = db.PaymentUDMealState_pms.FirstOrDefault(t => t.pms_cRecordID == deleteInfo.pms_cRecordID);
if (deleteData != null)
{
db.PaymentUDMealState_pms.DeleteOnSubmit(deleteData);
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
}
catch (Exception Ex)
{
returnInfo.messageText = Ex.Message;
}
}
return returnInfo;
}
public List<Sys_UserMaster_usm_Info> SearchRecords(Sys_UserMaster_usm_Info infoObj)
{
List<Sys_UserMaster_usm_Info> listReturn = null;
try
{
string strSql = "select * from dbo.Sys_UserMaster_usm where 1=1 ";
if(infoObj != null)
{
if (!String.IsNullOrEmpty(infoObj.usm_cUserLoginID))
{
strSql += " and usm_cUserLoginID like %'" + infoObj.usm_cUserLoginID + "'% ";
}
}
IEnumerable<Sys_UserMaster_usm_Info> infos = null;
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
infos = db.ExecuteQuery<Sys_UserMaster_usm_Info>(strSql, new object[] { });
if (infos != null)
{
listReturn = infos.ToList();
}
}
}
catch
{
throw;
}
return listReturn;
}
public List<BlacklistChangeRecord_blc_Info> AllRecords()
{
List<BlacklistChangeRecord_blc_Info> listRecord = null;
try
{
StringBuilder sbSQL = new StringBuilder();
sbSQL.AppendLine(" SELECT blc_cRecordID,blc_iCardNo,blc_cOperation,blc_cOptReason,blc_lIsFinished,blc_cAdd ");
sbSQL.AppendLine(" ,blc_dAddDate,blc_dFinishDate,cus_cIdentityNum as IdentityNum ");
sbSQL.AppendLine(" FROM BlacklistChangeRecord_blc WITH(NOLOCK) ");
sbSQL.AppendLine(" JOIN UserCardPair_ucp WITH(NOLOCK) ON ucp_iCardNo=blc_iCardNo ");
sbSQL.AppendLine(" JOIN CardUserMaster_cus WITH(NOLOCK) ON cus_cRecordID=ucp_cCUSID ");
sbSQL.AppendLine(" WHERE blc_lIsFinished=0 ");
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IEnumerable<BlacklistChangeRecord_blc_Info> query = db.ExecuteQuery<BlacklistChangeRecord_blc_Info>(sbSQL.ToString(), new object[] { });
if (query != null)
{
listRecord = query.ToList<BlacklistChangeRecord_blc_Info>();
}
}
}
catch (Exception ex)
{
throw ex;
}
return listRecord;
}
public List<CardUserAccountDetail_cuad_Info> AllRecords()
{
List<CardUserAccountDetail_cuad_Info> listRecord = null;
try
{
StringBuilder sbSQL = new StringBuilder();
sbSQL.AppendLine("SELECT ");
sbSQL.AppendLine("* FROM CardUserAccountDetail_cuad WHERE 1 = 1");
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IEnumerable<CardUserAccountDetail_cuad_Info> query = db.ExecuteQuery<CardUserAccountDetail_cuad_Info>(sbSQL.ToString(), new object[] { });
if (query != null)
{
listRecord = query.ToList<CardUserAccountDetail_cuad_Info>();
}
}
}
catch (Exception ex)
{
throw ex;
}
return listRecord;
}
public Sys_RoleMaster_rlm_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
Sys_RoleMaster_rlm_Info rlm = new Sys_RoleMaster_rlm_Info();
Sys_RoleMaster_rlm_Info info = new Sys_RoleMaster_rlm_Info();
rlm = KeyObject as Sys_RoleMaster_rlm_Info;
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IQueryable<Sys_RoleMaster_rlm> taQuery =
(from ta in db.Sys_RoleMaster_rlm
where ta.rlm_iRecordID == rlm.rlm_iRecordID
//orderby dpms.dpm_iRecordID ascending
select ta).Take(1);
if (taQuery != null)
{
//foreach (var t in taQuery)
foreach (Sys_RoleMaster_rlm t in taQuery)
{
info = Common.General.CopyObjectValue<Sys_RoleMaster_rlm, Sys_RoleMaster_rlm_Info>(t);
FindUserRole(info);
}
}
return info;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public List<Model.HHZX.ConsumerDevice.ConsumeMachineMaster_cmm_Info> AllRecords()
{
List<ConsumeMachineMaster_cmm_Info> listRecordInfo = null;
try
{
StringBuilder sbSQL = new StringBuilder();
sbSQL.AppendLine("SELECT TOP");
sbSQL.AppendLine(Common.DefineConstantValue.ListRecordMaxCount.ToString());
sbSQL.AppendLine("* FROM ConsumeMachineMaster_cmm WHERE 1 = 1");
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IEnumerable<ConsumeMachineMaster_cmm_Info> query = db.ExecuteQuery<ConsumeMachineMaster_cmm_Info>(sbSQL.ToString(), new object[] { });
if (query != null)
{
listRecordInfo = query.ToList<ConsumeMachineMaster_cmm_Info>();
}
}
}
catch (Exception ex)
{
throw ex;
}
return listRecordInfo;
}
public Model.HHZX.ConsumerDevice.ConsumeMachineMaster_cmm_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
ConsumeMachineMaster_cmm_Info resInfo = null;
try
{
ConsumeMachineMaster_cmm_Info infoObject = KeyObject as ConsumeMachineMaster_cmm_Info;
if (infoObject != null)
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
ConsumeMachineMaster_cmm record = db.ConsumeMachineMaster_cmm.Where(x => x.cmm_cRecordID == infoObject.cmm_cRecordID).FirstOrDefault();
if (record != null)
{
resInfo = Common.General.CopyObjectValue<ConsumeMachineMaster_cmm, ConsumeMachineMaster_cmm_Info>(record);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return resInfo;
}
public Model.General.ReturnValueInfo InsertRecord(Model.HHZX.ConsumerDevice.ConsumeMachineMaster_cmm_Info infoObject)
{
ReturnValueInfo rvInfo = new ReturnValueInfo();
try
{
if (infoObject != null)
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
ConsumeMachineMaster_cmm record = Common.General.CopyObjectValue<ConsumeMachineMaster_cmm_Info, ConsumeMachineMaster_cmm>(infoObject);
if (record != null)
{
db.ConsumeMachineMaster_cmm.InsertOnSubmit(record);
db.SubmitChanges();
rvInfo.boolValue = true;
rvInfo.ValueObject = infoObject;
}
else
{
rvInfo.messageText = "TransEntity is null";
}
}
}
else
{
rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull;
}
}
catch (Exception ex)
{
rvInfo.isError = true;
rvInfo.messageText = ex.Message;
}
return rvInfo;
}
public PayRecord_prd_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
PayRecord_prd_Info showInfo = KeyObject as PayRecord_prd_Info;
if (showInfo != null)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
PayRecord_prd displayData = db.PayRecord_prd.FirstOrDefault(t => t.prd_cRecordID == showInfo.prd_cRecordID);
if (displayData != null)
{
showInfo = Common.General.CopyObjectValue<PayRecord_prd, PayRecord_prd_Info>(displayData);
}
else
{
showInfo = null;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
return showInfo;
}
public ReturnValueInfo DeleteRecord(IModelObject KeyObject)
{
ReturnValueInfo rvInfo = new ReturnValueInfo();
DepartmentMaster_dpm_Info searchInfo = KeyObject as DepartmentMaster_dpm_Info;
if (searchInfo == null)
{
rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull;
rvInfo.isError = true;
return rvInfo;
}
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
List<DepartmentMaster_dpm> listDept = db.DepartmentMaster_dpm.Where(x => x.dpm_RecordID == searchInfo.dpm_RecordID).ToList();
if (listDept != null)
{
db.DepartmentMaster_dpm.DeleteAllOnSubmit(listDept);
db.SubmitChanges();
rvInfo.boolValue = true;
}
}
}
catch (Exception ex)
{
rvInfo.messageText = ex.Message;
rvInfo.isError = true;
}
return rvInfo;
}
public List<DeductionBalance_Info> SearchRecords(Model.IModel.IModelObject searchCondition)
{
List<DeductionBalance_Info> returnList = new List<DeductionBalance_Info>();
try
{
DeductionBalance_Info searchInfo = searchCondition as DeductionBalance_Info;
StringBuilder sbSQL = new StringBuilder();
sbSQL.AppendLine("select *,cua_fCurrentBalance as Balance ");
sbSQL.AppendLine("from dbo.PreConsumeRecord_pcs");
sbSQL.AppendLine("join dbo.CardUserAccount_cua on cua_cRecordID = pcs_cAccountID");
sbSQL.AppendLine("join dbo.CardUserMaster_cus on cus_cRecordID = cua_cCUSID");
sbSQL.AppendLine("join dbo.ClassMaster_csm on csm_cRecordID = cus_cClassID");
sbSQL.AppendLine("join dbo.UserCardPair_ucp on ucp_cCUSID = cus_cRecordID and ucp_dReturnTime is null");
sbSQL.AppendLine(" where pcs_cConsumeType = 'SetMealCost' and pcs_lIsSettled = 1");
if (searchInfo != null)
{
if (searchInfo.ClassID != Guid.Empty)
{
sbSQL.AppendLine("AND csm_cRecordID ='" + searchInfo.ClassID.ToString() + "'");
}
if (searchInfo.CardNo > 0)
{
sbSQL.AppendLine("AND ucp_iCardNo ='" + searchInfo.CardNo.ToString() + "'");
}
if (!String.IsNullOrEmpty(searchInfo.ChaName))
{
sbSQL.AppendLine("AND cus_cChaName like N'%" + searchInfo.ChaName.ToString() + "%'");
}
if (!String.IsNullOrEmpty(searchInfo.StudentID))
{
sbSQL.AppendLine("AND cus_cStudentID ='" + searchInfo.StudentID.ToString() + "'");
}
sbSQL.AppendLine("AND pcs_dConsumeDate between '" + searchInfo.FromTime.ToString("yyyy/MM/dd") + "' and '" + searchInfo.ToTime.ToString("yyyy/MM/dd") + "'");
sbSQL.AppendLine("order by pcs_dConsumeDate desc");
}
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IEnumerable<DeductionBalance_Info> query = db.ExecuteQuery<DeductionBalance_Info>(sbSQL.ToString(), new object[] { });
if (query != null)
{
returnList = query.ToList<DeductionBalance_Info>();
}
}
}
catch
{
}
return returnList;
}
public ReturnValueInfo DeleteRecord(IModelObject KeyObject)
{
ReturnValueInfo returnInfo = new ReturnValueInfo(false);
GradeMaster_gdm_Info deleteInfo = KeyObject as GradeMaster_gdm_Info;
if (deleteInfo != null)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
GradeMaster_gdm deleteData = db.GradeMaster_gdm.FirstOrDefault(t => t.gdm_cRecordID == deleteInfo.gdm_cRecordID);
if (deleteData != null)
{
IEnumerable<ClassMaster_csm> classe = from t in db.ClassMaster_csm
where t.csm_cGDMID == deleteInfo.gdm_cRecordID
select t;
if (classe != null && classe.Count() > 0)
{
returnInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_DeleteObjectHaveContectData;
}
else
{
db.GradeMaster_gdm.DeleteOnSubmit(deleteData);
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
else
{
returnInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_DeleteDataNull;
}
}
}
catch (Exception Ex)
{
returnInfo.messageText = Ex.Message;
}
}
else
{
returnInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_DeleteDataNull;
}
return returnInfo;
}
/// <summary>
/// 取得日志
/// </summary>
/// <param name="p_strIP">IP</param>
/// <param name="p_strSystemName">系统名</param>
/// <param name="p_strModel">模组</param>
/// <param name="p_strType">类型</param>
/// <param name="p_strOperator">操作人</param>
/// <returns></returns>
public List<LogDetail_lgd_Info> GetLogs(string p_strIP, string p_strSystemName, string p_strModel, string p_strType, string p_strOperator)
{
StringBuilder l_strSQL = new StringBuilder();
l_strSQL.AppendLine("Select Top 200 lgd_iID,");
l_strSQL.AppendLine("lgd_cIpAddr,");
l_strSQL.AppendLine("lgd_cSysName,");
l_strSQL.AppendLine("lgd_cClassMethodName,");
l_strSQL.AppendLine("lgd_cLogType,");
l_strSQL.AppendLine("lgd_cLogMessage,");
l_strSQL.AppendLine("lgd_cRemark,");
l_strSQL.AppendLine("lgd_cOperator,");
l_strSQL.AppendLine("lgd_dOperateDateTime");
l_strSQL.AppendLine("From LogDetail_lgd");
l_strSQL.AppendLine("Where 1=1");
if (p_strIP != "")
{
l_strSQL.AppendLine("And lgd_cIpAddr = '" + p_strIP + "'");
}
if (p_strSystemName != "")
{
l_strSQL.AppendLine("And lgd_cSysName = '" + p_strSystemName + "'");
}
if (p_strModel != "")
{
l_strSQL.AppendLine("And lgd_cClassMethodName = '" + p_strModel + "'");
}
if (p_strType != "")
{
l_strSQL.AppendLine("And lgd_cLogType = '" + p_strType + "'");
}
if (p_strOperator != "")
{
l_strSQL.AppendLine("And lgd_cOperator = '" + p_strOperator + "'");
}
l_strSQL.AppendLine("Order By lgd_dOperateDateTime Desc");
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
return db.ExecuteQuery<LogDetail_lgd_Info>(l_strSQL.ToString(), new object[] { }).ToList();
}
}
public ReturnValueInfo BatchDeleteRecords(PaymentUDGeneralSetting_pus_Info searchInfo)
{
ReturnValueInfo rvInfo = new ReturnValueInfo();
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
List<PaymentUDGeneralSetting_pus> searchData = db.PaymentUDGeneralSetting_pus.Where(x => 1 == 1).ToList();
PaymentUDGeneralSetting_pus_Info query = searchInfo as PaymentUDGeneralSetting_pus_Info;
if (query != null)
{
if (query.pus_cCardUserID != null)
{
searchData = searchData.Where(t => t.pus_cCardUserID == query.pus_cCardUserID).ToList();
}
if (query.pus_cClassID != null)
{
searchData = searchData.Where(t => t.pus_cClassID == query.pus_cClassID).ToList();
}
if (query.pus_cGradeID != null)
{
searchData = searchData.Where(t => t.pus_cGradeID == query.pus_cGradeID).ToList();
}
if (query.pus_iWeek != null && query.pus_iWeek != -1)
{
searchData = searchData.Where(t => t.pus_iWeek == query.pus_iWeek).ToList();
}
}
else
{
rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull;
return rvInfo;
}
db.PaymentUDGeneralSetting_pus.DeleteAllOnSubmit(searchData);
db.SubmitChanges();
rvInfo.boolValue = true;
}
}
catch (Exception ex)
{
rvInfo.isError = true;
rvInfo.messageText = ex.Message;
}
return rvInfo;
}
public bool SaveRecord(Sys_UserMaster_usm_Info infoObj)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
LinqToSQLModel.Sys_UserMaster_usm newTab = Common.General.CopyObjectValue<Sys_UserMaster_usm_Info, LinqToSQLModel.Sys_UserMaster_usm>(infoObj);
db.Sys_UserMaster_usm.InsertOnSubmit(newTab);
db.SubmitChanges();
}
return true;
}
catch
{
throw;
}
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
Sys_FormMaster_fom_Info info = null;
try
{
info = KeyObject as Sys_FormMaster_fom_Info;
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
Sys_FormMaster_fom frm = db.Sys_FormMaster_fom.Single<Sys_FormMaster_fom>(i => i.fom_iRecordID == info.fom_iRecordID);
for (int i = 0; i < frm.Sys_FormPurview_frp.Count; i++)
{
Sys_FormPurview_frp sta = frm.Sys_FormPurview_frp[i];
db.Sys_FormPurview_frp.DeleteOnSubmit(sta);
}
if (frm != null)
{
frm.fom_lVaild = false;
IEnumerable<Sys_FormMaster_fom> subMenu = from t in db.Sys_FormMaster_fom
where t.fom_iParentID == frm.fom_iRecordID
select t;
if (subMenu != null && subMenu.Count() > 0)
{
foreach (Sys_FormMaster_fom item in subMenu)
{
item.fom_lVaild = false;
}
}
}
//db.Sys_FormMaster_fom.DeleteOnSubmit(frm);
db.SubmitChanges();
return true;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public List<GradeMaster_gdm_Info> AllRecords()
{
List<GradeMaster_gdm_Info> allRecords = null;
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IEnumerable<GradeMaster_gdm> allDatas = from t in db.GradeMaster_gdm
orderby t.gdm_dAddDate ascending
select t;
if (allDatas != null && allDatas.Count() > 0)
{
allRecords = new List<GradeMaster_gdm_Info>();
foreach (GradeMaster_gdm item in allDatas)
{
GradeMaster_gdm_Info addInfo = Common.General.CopyObjectValue<GradeMaster_gdm, GradeMaster_gdm_Info>(item);
CardUserMaster_cus staff = db.CardUserMaster_cus.FirstOrDefault(t => t.cus_cRecordID == item.gdm_cPraepostorID);
if (staff != null)
{
addInfo.gdm_cPraepostorName = staff.cus_cChaName;
addInfo.gdm_cPraepostorPhone = staff.cus_cContractPhone;
}
allRecords.Add(addInfo);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return allRecords;
}
public CodeMaster_cmt_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
CodeMaster_cmt_Info info = new CodeMaster_cmt_Info();
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
CodeMaster_cmt disTab = db.CodeMaster_cmt.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 List<ClassMaster_csm_Info> AllRecords()
{
List<ClassMaster_csm_Info> allRecords = null;
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
IEnumerable<ClassMaster_csm> allData = from t in db.ClassMaster_csm
orderby t.csm_dAddDate ascending
select t;
if (allData != null && allData.Count() > 0)
{
allRecords = new List<ClassMaster_csm_Info>();
foreach (ClassMaster_csm item in allData)
{
ClassMaster_csm_Info addInfo = Common.General.CopyObjectValue<ClassMaster_csm, ClassMaster_csm_Info>(item);
CardUserMaster_cus masterInfo = db.CardUserMaster_cus.FirstOrDefault(t => t.cus_cRecordID == addInfo.csm_cMasterID);
if (masterInfo != null)
{
addInfo.csm_cMasterName = masterInfo.cus_cChaName;
}
allRecords.Add(addInfo);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return allRecords;
}
public bool DeleteRecord(int id)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
var ret_usm = from usm in db.Sys_UserMaster_usm where usm.usm_iRecordID == id select usm;
if (ret_usm.Count() > 0)
{
db.Sys_UserMaster_usm.DeleteAllOnSubmit(ret_usm);
db.SubmitChanges();
}
}
return true;
}
catch
{
throw;
}
}
public List<DepartmentMaster_dpm_Info> AllRecords()
{
List<DepartmentMaster_dpm_Info> listReturn = null;
try
{
StringBuilder sbSQL = new StringBuilder();
sbSQL.AppendLine("SELECT * FROM DepartmentMaster_dpm");
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
listReturn = db.ExecuteQuery<DepartmentMaster_dpm_Info>(sbSQL.ToString(), new object[] { }).ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return listReturn;
}
public ReturnValueInfo DeleteRecord(IModelObject KeyObject)
{
ReturnValueInfo rvInfo = new ReturnValueInfo();
try
{
CardUserAccountDetail_cuad_Info infoObject = KeyObject as CardUserAccountDetail_cuad_Info;
if (infoObject != null)
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
CardUserAccountDetail_cuad record = db.CardUserAccountDetail_cuad.Where(x => x.cuad_cRecordID == infoObject.cuad_cRecordID).FirstOrDefault();
if (record != null)
{
db.CardUserAccountDetail_cuad.DeleteOnSubmit(record);
db.SubmitChanges();
rvInfo.boolValue = true;
rvInfo.ValueObject = infoObject;
}
else
{
rvInfo.messageText = "GetEntity is null";
}
}
}
else
{
rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull;
}
}
catch (Exception ex)
{
rvInfo.isError = true;
rvInfo.messageText = ex.Message;
}
return rvInfo;
}
public ReturnValueInfo DeleteRecord(IModelObject KeyObject)
{
ReturnValueInfo rvInfo = new ReturnValueInfo();
try
{
MealBookingHistory_mbh_Info infoObject = KeyObject as MealBookingHistory_mbh_Info;
if (infoObject != null)
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
MealBookingHistory_mbh history = db.MealBookingHistory_mbh.Where(x => x.mbh_cRecordID == infoObject.mbh_cRecordID).FirstOrDefault();
if (history != null)
{
db.MealBookingHistory_mbh.DeleteOnSubmit(history);
db.SubmitChanges();
rvInfo.boolValue = true;
rvInfo.ValueObject = infoObject;
}
else
{
rvInfo.messageText = "GetEntity is null";
}
}
}
else
{
rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull;
}
}
catch (Exception ex)
{
rvInfo.isError = true;
rvInfo.messageText = ex.Message;
}
return rvInfo;
}