public bool InsertRecord(Sys_UserPurview_usp_Info infoObject)
{
Sys_UserPurview_usp_Info uspInfo = new Sys_UserPurview_usp_Info();
Sys_FormMaster_fom_Info formInfo = new Sys_FormMaster_fom_Info();
Sys_UserMaster_usm_Info userInfo = null;
Sys_RoleMaster_rlm_Info roleInfo = null;
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
try
{
formInfo = infoObject.formMasterList[0];
DelUserPurview(infoObject);
for (int i = 0; i < infoObject.userMasterList.Count; i++)
{
for (int j = 0; j < infoObject.userMasterList[i].functionMasterList.Count; j++)
{
Sys_UserPurview_usp uspUser = new Sys_UserPurview_usp();
uspUser = Common.General.CopyObjectValue <Sys_UserPurview_usp_Info, Sys_UserPurview_usp>(infoObject);
userInfo = new Sys_UserMaster_usm_Info();
userInfo = infoObject.userMasterList[i];
uspUser.usp_cUserLoginID = userInfo.usm_cUserLoginID;
uspUser.usp_cPurviewCode = infoObject.userMasterList[i].functionMasterList[j].fum_cFunctionNumber + formInfo.fom_cFormNumber;
uspUser.usp_cAdd = infoObject.usp_cAdd;
uspUser.usp_cLast = infoObject.usp_cLast;
uspUser.usp_dAddDate = infoObject.usp_dAddDate.Value;
uspUser.usp_dLastDate = infoObject.usp_dLastDate.Value;
db.Sys_UserPurview_usps.InsertOnSubmit(uspUser);
}
}
for (int i = 0; i < infoObject.roleMasterList.Count; i++)
{
for (int j = 0; j < infoObject.roleMasterList[i].functionMasterList.Count; j++)
{
Sys_UserPurview_usp uspUser = new Sys_UserPurview_usp();
uspUser = Common.General.CopyObjectValue <Sys_UserPurview_usp_Info, Sys_UserPurview_usp>(infoObject);
roleInfo = new Sys_RoleMaster_rlm_Info();
roleInfo = infoObject.roleMasterList[i];
uspUser.usp_cRoleID = roleInfo.rlm_cRoleID;
uspUser.usp_cPurviewCode = infoObject.roleMasterList[i].functionMasterList[j].fum_cFunctionNumber + formInfo.fom_cFormNumber;
uspUser.usp_cAdd = infoObject.usp_cAdd;
uspUser.usp_cLast = infoObject.usp_cLast;
uspUser.usp_dAddDate = infoObject.usp_dAddDate.Value;
uspUser.usp_dLastDate = infoObject.usp_dLastDate.Value;
db.Sys_UserPurview_usps.InsertOnSubmit(uspUser);
}
}
db.SubmitChanges();
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
Sys_RoleMaster_rlm_Info info = null;
try
{
info = KeyObject as Sys_RoleMaster_rlm_Info;
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_RoleMaster_rlm rlm = db.Sys_RoleMaster_rlms.Single <Sys_RoleMaster_rlm>(i => i.rlm_iRecordID == info.rlm_iRecordID);
for (int i = 0; i < rlm.Sys_UserRoles_usrs.Count; i++)
{
Sys_UserRoles_usr sta = rlm.Sys_UserRoles_usrs[i];
db.Sys_UserRoles_usrs.DeleteOnSubmit(sta);
}
db.Sys_RoleMaster_rlms.DeleteOnSubmit(rlm);
db.SubmitChanges();
return(true);
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public Sys_RoleMaster_rlm_Info GetRecord_Last()
{
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
IQueryable <Sys_RoleMaster_rlm> taQuery =
(from ta in db.Sys_RoleMaster_rlms
orderby ta.rlm_iRecordID descending
select ta).Take(1);
Sys_RoleMaster_rlm_Info info = new Sys_RoleMaster_rlm_Info();
if (taQuery.Count() > 0)
{
foreach (var 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 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 (VPMSDBDataContext db = new VPMSDBDataContext())
{
IQueryable <Sys_RoleMaster_rlm> taQuery =
(from ta in db.Sys_RoleMaster_rlms
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 Sys_RoleMaster_rlm_Info GetRecord_Next(Model.Base.DataBaseCommandInfo commandInfo)
{
Sys_RoleMaster_rlm_Info info = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
string iRecordId = string.Empty;
foreach (var id in commandInfo.KeyInfoList)
{
iRecordId = id.KeyValue;
break;
}
IQueryable <Sys_RoleMaster_rlm> taQuery =
(from ta in db.Sys_RoleMaster_rlms
where ta.rlm_iRecordID > Convert.ToInt32(iRecordId)
orderby ta.rlm_iRecordID ascending
select ta).Take(1);
if (taQuery.Count() > 0)
{
foreach (var t in taQuery)
{
info = Common.General.CopyObjectValue <Sys_RoleMaster_rlm, Sys_RoleMaster_rlm_Info>(t);
FindUserRole(info);
}
}
return(info);
}
}
catch (Exception Ex)
{
return(info);
}
}
public Sys_RoleMaster_rlm_Info GetRecord_First()
{
Sys_RoleMaster_rlm_Info info = null;
try
{
info = this._sysRoleMasterDA.GetRecord_First();
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
public Model.IModel.IModelObject GetTableFieldLenght()
{
LocalGeneral general = new LocalGeneral();
Sys_RoleMaster_rlm_Info info = null;
try
{
info = general.GetTableFieldLenght <Sys_RoleMaster_rlm_Info>("Sys_RoleMaster_rlm");
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
public bool InsertRecord(Sys_RoleMaster_rlm_Info infoObject)
{
if (infoObject == null)
{
return(false);
}
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_RoleMaster_rlm rlm = new Sys_RoleMaster_rlm();
try
{
rlm = Common.General.CopyObjectValue <Sys_RoleMaster_rlm_Info, Sys_RoleMaster_rlm>(infoObject);
if (infoObject.userMasterList != null && infoObject.userMasterList.Count > 0)
{
for (int i = 0; i < infoObject.userMasterList.Count; i++)
{
Sys_UserMaster_usm_Info usmInfo = infoObject.userMasterList[i];
Sys_UserRoles_usr item = new Sys_UserRoles_usr();
item.usr_cUserLoginID = usmInfo.usm_cUserLoginID;
item.usr_cRoleID = infoObject.rlm_cRoleID;
//courseitem.cum_cNumber;
rlm.Sys_UserRoles_usrs.Add(item);
//db.Sys_UserRoles_usrs.InsertOnSubmit(item);
}
}
db.Sys_RoleMaster_rlms.InsertOnSubmit(rlm);
db.SubmitChanges();
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public Model.IModel.IModelObject DisplayRecord(Model.IModel.IModelObject itemEntity)
{
if (itemEntity == null)
{
return(null);
}
else
{
Sys_RoleMaster_rlm_Info info = null;
try
{
info = this._sysRoleMasterDA.DisplayRecord(itemEntity);
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
}
public Sys_RoleMaster_rlm_Info GetRecord_Next(Model.Base.DataBaseCommandInfo commandInfo)
{
Sys_RoleMaster_rlm_Info info = null;
if (commandInfo.KeyInfoList == null)
{
return(info);
}
else
{
try
{
info = this._sysRoleMasterDA.GetRecord_Next(commandInfo);
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
}
private Sys_RoleMaster_rlm_Info FindUserRole(Sys_RoleMaster_rlm_Info info)
{
string sqlString = string.Empty;
sqlString += "SELECT usm_cUserLoginID,usm_cChaName " + Environment.NewLine;
sqlString += "FROM Sys_UserMaster_usm " + Environment.NewLine;
sqlString += "LEFT JOIN Sys_UserRoles_usr" + Environment.NewLine;
sqlString += "ON usm_cUserLoginID=usr_cUserLoginID" + Environment.NewLine;
sqlString += "LEFT JOIN Sys_RoleMaster_rlm" + Environment.NewLine;
sqlString += "ON rlm_cRoleID=usr_cRoleID WHERE rlm_cRoleID='" + info.rlm_cRoleID + "'";
IEnumerable <Sys_UserMaster_usm_Info> infos = null;
List <Sys_UserMaster_usm_Info> infoList = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <Sys_UserMaster_usm_Info>(sqlString, new object[] { });
if (infos != null)
{
infoList = infos.ToList <Sys_UserMaster_usm_Info>();
}
foreach (Sys_UserMaster_usm_Info t in infoList)
{
info.userMasterList.Add(t);
}
return(info);
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode)
{
bool b;
Model.General.ReturnValueInfo msg = new Model.General.ReturnValueInfo();
Sys_RoleMaster_rlm_Info info = null;
info = itemEntity as Sys_RoleMaster_rlm_Info;
if (info == null)
{
msg.boolValue = false;
msg.messageText = "传入的数据为空！";
return(msg);
}
try
{
switch (EditMode)
{
case Common.DefineConstantValue.EditStateEnum.OE_Delete:
b = this._sysRoleMasterDA.DeleteRecord(info);
if (b == true)
{
msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_RecordByDelete;
}
break;
case Common.DefineConstantValue.EditStateEnum.OE_Insert:
b = this._sysRoleMasterDA.IsExistRecord(info);
if (b == false)
{
this._sysRoleMasterDA.InsertRecord(info);
}
else
{
msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_AddFail + " 角色ID重復！";
}
break;
case Common.DefineConstantValue.EditStateEnum.OE_Update:
b = this._sysRoleMasterDA.UpdateRecord(info);
//if (b == true)
//{
// msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_UpdateSuccess;
//}
//else
//{
// msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_UpdateFail;
//}
break;
}
}
catch (Exception Ex)
{
throw Ex;
}
return(msg);
}
public List <Sys_RoleMaster_rlm_Info> SearchRecords(Model.IModel.IModelObject searchCondition)
{
string sqlString = string.Empty;
string whereString = string.Empty;
sqlString = "SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString() + Environment.NewLine;
sqlString += " rlm_iRecordID," + Environment.NewLine;
sqlString += " rlm_cRoleID," + Environment.NewLine;
sqlString += " rlm_cRoleDesc," + Environment.NewLine;
//sqlString += " usm_cPasswork," + Environment.NewLine;
//sqlString += " usm_cEMail," + Environment.NewLine;
//sqlString += " (CASE usm_iLock WHEN 1 THEN N'已锁' WHEN 0 THEN N'未锁' END) AS iLock," + Environment.NewLine;
//sqlString += " usm_cRemark," + Environment.NewLine;
sqlString += " rlm_cAdd," + Environment.NewLine;
sqlString += " rlm_dAddDate," + Environment.NewLine;
sqlString += " rlm_cLast," + Environment.NewLine;
sqlString += " rlm_dLastDate " + Environment.NewLine;
sqlString += " FROM Sys_RoleMaster_rlm" + Environment.NewLine;
Sys_RoleMaster_rlm_Info info = null;
info = searchCondition as Sys_RoleMaster_rlm_Info;
if (info != null)
{
whereString = " WHERE 1=1 ";
if (info.rlm_cRoleID.Trim() != "")
{
if (info.rlm_cRoleID.ToString().Contains("*") || info.rlm_cRoleID.ToString().Contains("?"))
{
whereString += " AND rlm_cRoleID LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(info.rlm_cRoleID) + "'";
}
else
{
whereString += "AND rlm_cRoleID = N'" + info.rlm_cRoleID.ToString().Trim() + "'";
}
}
}
sqlString += whereString;
IEnumerable <Sys_RoleMaster_rlm_Info> infos = null;
List <Sys_RoleMaster_rlm_Info> infoList = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <Sys_RoleMaster_rlm_Info>(sqlString, new object[] { });
if (infos != null)
{
infoList = infos.ToList <Sys_RoleMaster_rlm_Info>();
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(infoList);
}
public bool UpdateRecord(Sys_RoleMaster_rlm_Info infoObject)
{
string sqlString = string.Empty;
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_RoleMaster_rlm rlm = new Sys_RoleMaster_rlm();
Sys_RoleMaster_rlm_Info info = new Sys_RoleMaster_rlm_Info();
try
{
rlm = db.Sys_RoleMaster_rlms.SingleOrDefault(t => t.rlm_iRecordID == infoObject.rlm_iRecordID);
for (int i = 0; i < rlm.Sys_UserRoles_usrs.Count; i++)
{
Sys_UserRoles_usr sta = rlm.Sys_UserRoles_usrs[i];
db.Sys_UserRoles_usrs.DeleteOnSubmit(sta);
}
info = Common.General.CopyObjectValue <Sys_RoleMaster_rlm, Sys_RoleMaster_rlm_Info>(rlm);
IEnumerable <Sys_RoleMaster_rlm_Info> IErlm = null;
IEnumerable <Sys_UserRoles_usr_Info> IEusr = null;
sqlString += "UPDATE Sys_RoleMaster_rlm" + Environment.NewLine;
sqlString += " SET rlm_cRoleID='" + infoObject.rlm_cRoleID + "'," + Environment.NewLine;
sqlString += " rlm_cRoleDesc='" + infoObject.rlm_cRoleDesc + "'," + Environment.NewLine;
sqlString += " rlm_cLast='" + infoObject.rlm_cLast + "'," + Environment.NewLine;
sqlString += " rlm_dLastDate='" + infoObject.rlm_dLastDate.Value.ToString(DefineConstantValue.gc_DateTimeFormat) + "'" + Environment.NewLine;
sqlString += " WHERE rlm_iRecordID='" + infoObject.rlm_iRecordID + "'";
IErlm = db.ExecuteQuery <Sys_RoleMaster_rlm_Info>(sqlString, new object[] { });
sqlString = string.Empty;
sqlString += "DELETE FROM Sys_UserRoles_usr WHERE usr_cRoleID='" + infoObject.rlm_cRoleID + "'";
IEusr = db.ExecuteQuery <Sys_UserRoles_usr_Info>(sqlString, new object[] { });
if (infoObject.userMasterList != null && infoObject.userMasterList.Count > 0)
{
for (int i = 0; i < infoObject.userMasterList.Count; i++)
{
sqlString = string.Empty;
Sys_UserMaster_usm_Info usmInfo = infoObject.userMasterList[i];
sqlString += "INSERT INTO Sys_UserRoles_usr" + Environment.NewLine;
sqlString += "(usr_cUserLoginID, usr_cRoleID)" + Environment.NewLine;
sqlString += " VALUES " + Environment.NewLine;
sqlString += "('" + usmInfo.usm_cUserLoginID + "','" + infoObject.rlm_cRoleID + "')";
IEusr = db.ExecuteQuery <Sys_UserRoles_usr_Info>(sqlString, new object[] { });
}
}
//if (rlm != null)
//{
// //usm = Common.General.SetDataToLingQEntity(usm, infoObject);//时间溢出
// rlm.rlm_cRoleDesc = infoObject.rlm_cRoleDesc;
// rlm.rlm_cLast = infoObject.rlm_cLast;
// rlm.rlm_dLastDate = infoObject.rlm_dLastDate.Value;
// if (infoObject.userMasterList != null && infoObject.userMasterList.Count > 0)
// {
// for (int i = 0; i < infoObject.userMasterList.Count; i++)
// {
// Sys_UserMaster_usm_Info usmInfo = infoObject.userMasterList[i];
// Sys_UserRoles_usr item = new Sys_UserRoles_usr();
// item.usr_cUserLoginID = usmInfo.usm_cUserLoginID;
// item.usr_cRoleID = infoObject.rlm_cRoleID;
// //courseitem.cum_cNumber;
// rlm.Sys_UserRoles_usrs.Add(item);
// //db.Sys_UserRoles_usrs.InsertOnSubmit(item);
// }
// }
// db.SubmitChanges();
//}
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
