private void GetRoleUser(DataRightsRole_drr_Info Entity)
{
if (Entity != null)
{
List <Sys_UserMaster_usm_Info> usmList = new List <Sys_UserMaster_usm_Info>();
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
IEnumerable <DataRightsRoleUser_dru> tab = from t in db.DataRightsRoleUser_drus
where t.dru_cRoleNumber == Entity.drr_cNumber
select t;
if (tab != null && tab.Count() > 0)
{
foreach (DataRightsRoleUser_dru item in tab)
{
Sys_UserMaster_usm usmTab = db.Sys_UserMaster_usms.SingleOrDefault(t => t.usm_cUserLoginID == item.dur_cUserLoginID);
if (usmTab != null)
{
Sys_UserMaster_usm_Info tempInfo = null;
tempInfo = Common.General.CopyObjectValue <Sys_UserMaster_usm, Sys_UserMaster_usm_Info>(usmTab);
usmList.Add(tempInfo);
}
}
}
}
Entity.RoleUserList = usmList;
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public List <Sys_UserMaster_usm_Info> GetAllSysUserList()
{
List <Sys_UserMaster_usm_Info> returnList = new List <Sys_UserMaster_usm_Info>();
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
IEnumerable <Sys_UserMaster_usm> tab = from t in db.Sys_UserMaster_usms
where t.usm_iLock == false
orderby t.usm_dAddDate descending
select t;
if (tab != null)
{
foreach (Sys_UserMaster_usm item in tab)
{
Sys_UserMaster_usm_Info tempInfo = null;
tempInfo = Common.General.CopyObjectValue <Sys_UserMaster_usm, Sys_UserMaster_usm_Info>(item);
returnList.Add(tempInfo);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(returnList);
}
public Model.SysMaster.Sys_UserMaster_usm_Info GetRecord_Last()
{
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
IQueryable <Sys_UserMaster_usm> taQuery =
(from ta in db.Sys_UserMaster_usms
orderby ta.usm_iRecordID descending
select ta).Take(1);
Sys_UserMaster_usm_Info info = new Sys_UserMaster_usm_Info();
if (taQuery.Count() > 0)
{
foreach (var 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 <Sys_UserMaster_usm_Info> GetRoleUserList(DataRightsRole_drr_Info Entity)
{
List <Sys_UserMaster_usm_Info> returnList = new List <Sys_UserMaster_usm_Info>();
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
IEnumerable <Sys_UserMaster_usm> tab = from b in db.Sys_UserMaster_usms
join t in db.DataRightsRoleUser_drus
on b.usm_cUserLoginID equals t.dur_cUserLoginID
where t.dru_cRoleNumber == Entity.drr_cNumber
select b;
foreach (Sys_UserMaster_usm item in tab)
{
Sys_UserMaster_usm_Info info = new Sys_UserMaster_usm_Info();
info = Common.General.CopyObjectValue <Sys_UserMaster_usm, Sys_UserMaster_usm_Info>(item);
returnList.Add(info);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(returnList);
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
Sys_UserMaster_usm_Info info = null;
try
{
info = KeyObject as Sys_UserMaster_usm_Info;
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_UserMaster_usm usm = db.Sys_UserMaster_usms.Single <Sys_UserMaster_usm>(i => i.usm_iRecordID == info.usm_iRecordID);
for (int i = 0; i < usm.Sys_UserRoles_usrs.Count; i++)
{
Sys_UserRoles_usr sta = usm.Sys_UserRoles_usrs[i];
db.Sys_UserRoles_usrs.DeleteOnSubmit(sta);
}
db.Sys_UserMaster_usms.DeleteOnSubmit(usm);
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 (VPMSDBDataContext db = new VPMSDBDataContext())
{
IQueryable <Sys_UserMaster_usm> taQuery =
(from ta in db.Sys_UserMaster_usms
where ta.usm_iRecordID == usm.usm_iRecordID
//orderby dpms.dpm_iRecordID ascending
select ta).Take(1);
if (taQuery != null)
{
//foreach (var t in taQuery)
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 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 Sys_UserMaster_usm_Info FindPermission(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 (VPMSDBDataContext db = new VPMSDBDataContext())
{
IQueryable <Sys_UserMaster_usm> taQuery =
(from ta in db.Sys_UserMaster_usms
where ta.usm_cUserLoginID == usm.usm_cUserLoginID && ta.usm_cPasswork == usm.usm_cPasswork
//orderby dpms.dpm_iRecordID ascending
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);
FindForm(info);
FindFunction(info);
}
}
return(info);
}
}
catch
{
throw;
}
}
public Model.SysMaster.Sys_UserMaster_usm_Info GetRecord_Next(Model.Base.DataBaseCommandInfo commandInfo)
{
Sys_UserMaster_usm_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_UserMaster_usm> taQuery =
(from ta in db.Sys_UserMaster_usms
where ta.usm_iRecordID > Convert.ToInt32(iRecordId)
orderby ta.usm_iRecordID ascending
select ta).Take(1);
if (taQuery.Count() > 0)
{
foreach (var t in taQuery)
{
info = Common.General.CopyObjectValue <Sys_UserMaster_usm, Sys_UserMaster_usm_Info>(t);
FindUserRole(info);
}
}
return(info);
}
}
catch (Exception Ex)
{
return(info);
}
}
private Sys_UserMaster_usm_Info FindAllFunction(Sys_UserMaster_usm_Info info)
{
string sqlString = string.Empty;
sqlString += "SELECT * " + Environment.NewLine;
sqlString += "FROM Sys_FunctionMaster_fum " + Environment.NewLine;
IEnumerable <Sys_FunctionMaster_fum_Info> infos = null;
List <Sys_FunctionMaster_fum_Info> infoList = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <Sys_FunctionMaster_fum_Info>(sqlString, new object[] { });
if (infos != null)
{
infoList = infos.ToList <Sys_FunctionMaster_fum_Info>();
}
foreach (Sys_FunctionMaster_fum_Info t in infoList)
{
info.functionMasterList.Add(t);
}
return(info);
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public List <DataRightsRole_drr_Info> GetUserRoleList(Sys_UserMaster_usm_Info Entity)
{
List <DataRightsRole_drr_Info> returnList = new List <DataRightsRole_drr_Info>();
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
IEnumerable <DataRightsRole_drr> tab = from t in db.DataRightsRoleUser_drus
join d in db.DataRightsRole_drrs
on t.dru_cRoleNumber equals d.drr_cNumber
//into data
where t.dur_cUserLoginID == Entity.usm_cUserLoginID
select d;
if (tab != null && tab.Count() > 0)
{
foreach (DataRightsRole_drr item in tab)
{
DataRightsRole_drr_Info info = new DataRightsRole_drr_Info();
info = Common.General.CopyObjectValue <DataRightsRole_drr, DataRightsRole_drr_Info>(item);
returnList.Add(info);
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(returnList);
}
public List <DataRightsRole_drr_Info> GetUserRoleList(Sys_UserMaster_usm_Info Entity)
{
try
{
return(_dataRightsRoleDA.GetUserRoleList(Entity));
}
catch (Exception Ex)
{
throw Ex;
}
}
public Sys_UserMaster_usm_Info FindAllPermission(Sys_UserMaster_usm_Info usm)
{
try
{
FindAllForm(usm);
FindAllFunction(usm);
return(usm);
}
catch
{
throw;
}
}
public Sys_UserMaster_usm_Info GetRecord_First()
{
Sys_UserMaster_usm_Info info = null;
try
{
info = this._sysUserMasterDA.GetRecord_First();
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
public TreeNodeInfo[] CheckUser(Sys_UserMaster_usm_Info userInfo)
{
TreeNodeInfo[] treeNodeInfos = null;
if (userInfo.usm_cUserLoginID.ToUpper() == "SA")
{
treeNodeInfos = GetMenuTreeNodes();
}
else
{
treeNodeInfos = GetMenuTreeNodes(userInfo);
}
return(treeNodeInfos);
}
public TreeNodeInfo[] GetMenuTreeNodes(Sys_UserMaster_usm_Info userInfo)
{
TreeNodeInfo[] treeNodeInfos = null;
try
{
treeNodeInfos = _systemMenuDA.GetMenuTreeNodes(userInfo);
}
catch
{
throw;
}
return(treeNodeInfos);
}
public Model.IModel.IModelObject GetTableFieldLenght()
{
LocalGeneral general = new LocalGeneral();
Sys_UserMaster_usm_Info info = null;
try
{
info = general.GetTableFieldLenght <Sys_UserMaster_usm_Info>("Sys_UserMaster_usm");
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
private Sys_UserMaster_usm_Info FindAllForm(Sys_UserMaster_usm_Info info)
{
string sqlString = string.Empty;
sqlString += "SELECT * " + Environment.NewLine;
sqlString += "FROM Sys_FormMaster_fom" + Environment.NewLine;
//sqlString += "FROM Sys_FormMaster_fom WHERE fom_iWebForm='false'" + Environment.NewLine;
IEnumerable <Sys_FormMaster_fom_Info> infos = null;
List <Sys_FormMaster_fom_Info> infoList = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <Sys_FormMaster_fom_Info>(sqlString, new object[] { });
if (infos != null)
{
infoList = infos.ToList <Sys_FormMaster_fom_Info>();
}
Sys_UserMaster_usm_Info cond = new Sys_UserMaster_usm_Info();
//// 请处理
cond.usm_cUserLoginID = info.usm_cUserLoginID;
//////
foreach (Sys_FormMaster_fom_Info t in infoList)
{
info.formMasterList.Add(t);
//////////////////////// 请处理
cond.formMasterList.Clear();
cond.formMasterList.Add(t);
t.functionMaster = SearchRecords(cond)[0].functionMasterList;
//////////////////////
}
return(info);
}
}
catch (Exception Ex)
{
throw Ex;
}
}
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_UserMaster_usm_Info info = null;
try
{
info = this._sysUserMasterDA.DisplayRecord(itemEntity);
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
}
public Model.IModel.IModelObject DisplayRecord(Model.IModel.IModelObject itemEntity)
{
if (itemEntity == null)
{
return(null);
}
else
{
Sys_UserMaster_usm_Info info = null;
try
{
info = itemEntity as Sys_UserMaster_usm_Info;
info.usm_cPasswork = Common.General.MD5(info.usm_cPasswork);
if (info.usm_cUserLoginID.ToUpper() == "SA")
{
if (info.usm_cPasswork == Common.General.MD5(DateTime.Now.ToString(DefineConstantValue.gc_PwdDateFormat)))
{
info = this._loginFormDA.FindAllPermission(info);
//info = this._loginFormDA.DisplayRecord(info);
return(info);
}
else
{
info = null;
return(info);
}
}
else
{
//info = this._loginFormDA.DisplayRecord(itemEntity);
info = this._loginFormDA.FindPermission(itemEntity);
}
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
}
public Sys_UserMaster_usm_Info GetRecord_Next(Model.Base.DataBaseCommandInfo commandInfo)
{
Sys_UserMaster_usm_Info info = null;
if (commandInfo.KeyInfoList == null)
{
return(info);
}
else
{
try
{
info = this._sysUserMasterDA.GetRecord_Next(commandInfo);
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
}
public Model.General.ReturnValueInfo Login(Model.IModel.IModelObject itemEntity)
{
Model.General.ReturnValueInfo msg = new Model.General.ReturnValueInfo();
Sys_UserMaster_usm_Info userInfo = null;
try
{
userInfo = DisplayRecord(itemEntity) as Sys_UserMaster_usm_Info;
if (userInfo == null)
{
msg.boolValue = false;
msg.messageText = "密码错误，请确认您是管理员身份！";
}
else
{
if (userInfo.usm_cUserLoginID == "")
{
msg.boolValue = false;
msg.messageText = "用户名或密码错误！";
}
else
{
msg.boolValue = true;
if (userInfo.usm_iLock == true)
{
msg.messageText = "账户被锁，请与管理员联系！";
}
msg.ValueObject = userInfo;
}
}
return(msg);
}
catch (Exception Ex)
{
msg.boolValue = false;
msg.messageText = Ex.ToString();
return(msg);
}
}
private Sys_UserMaster_usm_Info FindUserRole(Sys_UserMaster_usm_Info info)
{
string sqlString = string.Empty;
sqlString += "SELECT rlm_cRoleID,rlm_cRoleDesc " + Environment.NewLine;
sqlString += "FROM Sys_RoleMaster_rlm " + Environment.NewLine;
sqlString += "LEFT JOIN Sys_UserRoles_usr" + Environment.NewLine;
sqlString += "ON rlm_cRoleID=usr_cRoleID" + Environment.NewLine;
sqlString += "LEFT JOIN Sys_UserMaster_usm" + Environment.NewLine;
sqlString += "ON usm_cUserLoginID=usr_cUserLoginID WHERE usm_cUserLoginID='" + info.usm_cUserLoginID + "'";
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>();
}
foreach (Sys_RoleMaster_rlm_Info t in infoList)
{
info.roleMasterList.Add(t);
}
return(info);
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public bool UpdateRecord(Sys_UserMaster_usm_Info infoObject)
{
throw new NotImplementedException();
}
public List <Sys_FormMaster_fom_Info> SearchRecords(Model.IModel.IModelObject searchCondition, Sys_UserMaster_usm_Info userInfo)
{
string sqlString = string.Empty;
string whereString = string.Empty;
sqlString = "SELECT DISTINCT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString() + Environment.NewLine;
sqlString += " fom_iRecordID," + Environment.NewLine;
sqlString += " fom_iParentID," + Environment.NewLine;
sqlString += " fom_iIndex," + Environment.NewLine;
sqlString += " fom_cFormNumber," + Environment.NewLine;
sqlString += " fom_cFormDesc," + Environment.NewLine;
sqlString += " fom_cExePath," + Environment.NewLine;
sqlString += " fom_cWebPath," + Environment.NewLine;
sqlString += " fom_iWebForm," + Environment.NewLine;
sqlString += " fom_iImageIndex," + Environment.NewLine;
sqlString += " fom_cRemark," + Environment.NewLine;
sqlString += " fom_cAdd," + Environment.NewLine;
sqlString += " fom_dAddDate," + Environment.NewLine;
sqlString += " fom_cLast," + Environment.NewLine;
sqlString += " fom_dLastDate " + Environment.NewLine;
sqlString += " FROM Sys_FormMaster_fom" + Environment.NewLine;
sqlString += " LEFT JOIN Sys_FormPurview_frp " + Environment.NewLine;
sqlString += " ON fom_cFormNumber=frp_cFormNumber" + Environment.NewLine;
sqlString += " LEFT JOIN Sys_UserPurview_usp" + Environment.NewLine;
sqlString += " ON frp_cPurviewCode=usp_cPurviewCode" + Environment.NewLine;
sqlString += " LEFT JOIN Sys_UserMaster_usm" + Environment.NewLine;
sqlString += " ON usp_cUserLoginID=usm_cUserLoginID" + Environment.NewLine;
/**/
string sqlRole = string.Empty;
sqlRole = "SELECT DISTINCT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString() + Environment.NewLine;
sqlRole += " fom_iRecordID," + Environment.NewLine;
sqlRole += " fom_iParentID," + Environment.NewLine;
sqlRole += " fom_iIndex," + Environment.NewLine;
sqlRole += " fom_cFormNumber," + Environment.NewLine;
sqlRole += " fom_cFormDesc," + Environment.NewLine;
sqlRole += " fom_cExePath," + Environment.NewLine;
sqlRole += " fom_cWebPath," + Environment.NewLine;
sqlRole += " fom_iWebForm," + Environment.NewLine;
sqlRole += " fom_iImageIndex," + Environment.NewLine;
sqlRole += " fom_cRemark," + Environment.NewLine;
sqlRole += " fom_cAdd," + Environment.NewLine;
sqlRole += " fom_dAddDate," + Environment.NewLine;
sqlRole += " fom_cLast," + Environment.NewLine;
sqlRole += " fom_dLastDate " + Environment.NewLine;
sqlRole += " FROM Sys_FormMaster_fom" + Environment.NewLine;
sqlRole += " LEFT JOIN Sys_FormPurview_frp " + Environment.NewLine;
sqlRole += " ON fom_cFormNumber=frp_cFormNumber" + Environment.NewLine;
sqlRole += " LEFT JOIN Sys_UserPurview_usp" + Environment.NewLine;
sqlRole += " ON frp_cPurviewCode=usp_cPurviewCode" + Environment.NewLine;
sqlRole += " LEFT JOIN Sys_RoleMaster_rlm" + Environment.NewLine;
sqlRole += " ON usp_cRoleID=rlm_cRoleID" + Environment.NewLine;
sqlRole += " LEFT JOIN Sys_UserRoles_usr" + Environment.NewLine;
sqlRole += " ON usr_cRoleID=rlm_cRoleID" + Environment.NewLine;
sqlRole += " LEFT JOIN Sys_UserMaster_usm" + Environment.NewLine;
sqlRole += " ON usr_cUserLoginID=usm_cUserLoginID" + Environment.NewLine;
/**/
Sys_FormMaster_fom_Info info = null;
info = searchCondition as Sys_FormMaster_fom_Info;
if (info != null)
{
whereString = " WHERE 1=1 AND fom_iWebForm='false' ";
if (info.fom_iParentID != 0)
{
if (info.fom_iParentID.ToString().Contains("*") || info.fom_iParentID.ToString().Contains("?"))
{
whereString += " AND fom_iParentID LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(info.fom_iParentID.ToString()) + "'";
}
else
{
whereString += "AND fom_iParentID = N'" + info.fom_iParentID.ToString().Trim() + "'";
}
}
if (userInfo.usm_cUserLoginID != "")
{
if (userInfo.usm_cUserLoginID.ToString().Contains("*") || userInfo.usm_cUserLoginID.ToString().Contains("?"))
{
whereString += " AND usm_cUserLoginID LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(userInfo.usm_cUserLoginID.ToString()) + "'";
}
else
{
whereString += "AND usm_cUserLoginID = N'" + userInfo.usm_cUserLoginID.ToString().Trim() + "'";
}
}
}
sqlString += whereString + Environment.NewLine;
sqlString += " ORDER BY fom_iIndex" + Environment.NewLine;
/**/
sqlRole += whereString + Environment.NewLine;
sqlRole += " ORDER BY fom_iIndex" + Environment.NewLine;
IEnumerable <Sys_FormMaster_fom_Info> roleInfos = null;
List <Sys_FormMaster_fom_Info> roleInfoList = null;
/**/
IEnumerable <Sys_FormMaster_fom_Info> infos = null;
List <Sys_FormMaster_fom_Info> infoList = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <Sys_FormMaster_fom_Info>(sqlString, new object[] { });
if (infos != null)
{
infoList = infos.ToList <Sys_FormMaster_fom_Info>();
}
/**/
roleInfos = db.ExecuteQuery <Sys_FormMaster_fom_Info>(sqlRole, new object[] { });
if (roleInfos != null)
{
roleInfoList = roleInfos.ToList <Sys_FormMaster_fom_Info>();
}
/**/
//删除重复的再添加
for (int i = 0; i < infoList.Count; i++)
{
for (int j = 0; j < roleInfoList.Count; j++)
{
if (infoList[i].fom_cFormNumber == roleInfoList[j].fom_cFormNumber)
{
roleInfoList.Remove(roleInfoList[j]);
j = 0;
}
}
}
foreach (Sys_FormMaster_fom_Info t in roleInfoList)
{
infoList.Add(t);
}
//********
}
}
catch (Exception Ex)
{
throw Ex;
}
return(infoList);
}
public List <Sys_UserMaster_usm_Info> SearchRecords(Model.IModel.IModelObject searchCondition)
{
Sys_UserMaster_usm_Info info = null;
info = searchCondition as Sys_UserMaster_usm_Info;
string sqlString = string.Empty;
string whereString = string.Empty;
sqlString = " SELECT distinct TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString() + Environment.NewLine;
sqlString += " fum_cFunctionNumber " + Environment.NewLine;
sqlString += " FROM Sys_FunctionMaster_fum" + Environment.NewLine;
sqlString += " LEFT JOIN Sys_FormPurview_frp" + Environment.NewLine;
sqlString += " ON frp_cFunctionNumber=fum_cFunctionNumber" + Environment.NewLine;
//****
sqlString += " LEFT JOIN Sys_UserPurview_usp" + Environment.NewLine;
sqlString += " ON frp_cPurviewCode=usp_cPurviewCode" + Environment.NewLine;
sqlString += " LEFT JOIN Sys_UserMaster_usm" + Environment.NewLine;
sqlString += " ON usp_cUserLoginID=usm_cUserLoginID" + Environment.NewLine;
//****
sqlString += " LEFT JOIN Sys_FormMaster_fom" + Environment.NewLine;
sqlString += " ON fom_cFormNumber=frp_cFormNumber" + Environment.NewLine;
Sys_FormMaster_fom_Info fomInfo = new Sys_FormMaster_fom_Info();
fomInfo = info.formMasterList[0];
if (info != null)
{
whereString = " WHERE 1=1 ";
if (fomInfo.fom_cFormNumber.Trim() != "")
{
if (fomInfo.fom_cFormNumber.ToString().Contains("*") || fomInfo.fom_cFormNumber.ToString().Contains("?"))
{
whereString += " AND fom_cFormNumber LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(fomInfo.fom_cFormNumber) + "'";
}
else
{
whereString += "AND fom_cFormNumber = N'" + fomInfo.fom_cFormNumber.ToString().Trim() + "'";
}
}
//**
if (info.usm_cUserLoginID.ToString().ToUpper() != "SA")
{
if (info.usm_cUserLoginID != "")
{
if (info.usm_cUserLoginID.ToString().Contains("*") || info.usm_cUserLoginID.ToString().Contains("?"))
{
whereString += " AND usm_cUserLoginID LIKE N'" + LocalDefine.General.ReplaceSQLLikeCondition(info.usm_cUserLoginID) + "'";
}
else
{
whereString += "AND usm_cUserLoginID = N'" + info.usm_cUserLoginID.ToString().Trim() + "'";
}
}
}
//*****
}
sqlString += whereString;
IEnumerable <Sys_FunctionMaster_fum_Info> infos = null;
List <Sys_FunctionMaster_fum_Info> infoList = null;
List <Sys_UserMaster_usm_Info> usmInfoList = new List <Sys_UserMaster_usm_Info>();
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <Sys_FunctionMaster_fum_Info>(sqlString, new object[] { });
if (infos != null)
{
infoList = infos.ToList <Sys_FunctionMaster_fum_Info>();
info.functionMasterList = infoList;
usmInfoList.Add(info);
RoleFunction(usmInfoList);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(usmInfoList);
}
private Sys_UserMaster_usm_Info FindForm(Sys_UserMaster_usm_Info info)
{
string sqlString = string.Empty;
sqlString += "SELECT distinct fom_iRecordID, fom_iParentID, fom_iIndex, fom_cFormNumber, fom_cFormDesc, fom_cExePath,fom_cWebPath,fom_iWebForm " + Environment.NewLine;
sqlString += "FROM Sys_FormMaster_fom " + Environment.NewLine;
sqlString += "LEFT JOIN Sys_FormPurview_frp" + Environment.NewLine;
sqlString += "ON fom_cFormNumber=frp_cFormNumber" + Environment.NewLine;
sqlString += "LEFT JOIN Sys_UserPurview_usp" + Environment.NewLine;
sqlString += "ON frp_cPurviewCode=usp_cPurviewCode" + Environment.NewLine;
sqlString += "LEFT JOIN Sys_UserMaster_usm" + Environment.NewLine;
sqlString += "ON usp_cUserLoginID=usm_cUserLoginID WHERE usm_cUserLoginID='" + info.usm_cUserLoginID + "'";
//sqlString += "ON usp_cUserLoginID=usm_cUserLoginID WHERE usm_cUserLoginID='" + info.usm_cUserLoginID + "' AND fom_iWebForm='false'";
string sqlRole = string.Empty;
sqlRole += "SELECT distinct fom_iRecordID, fom_iParentID, fom_iIndex, fom_cFormNumber, fom_cFormDesc, fom_cExePath,fom_cWebPath,fom_iWebForm " + Environment.NewLine;
sqlRole += "FROM Sys_FormMaster_fom " + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_FormPurview_frp" + Environment.NewLine;
sqlRole += "ON fom_cFormNumber=frp_cFormNumber" + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_UserPurview_usp" + Environment.NewLine;
sqlRole += "ON frp_cPurviewCode=usp_cPurviewCode" + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_RoleMaster_rlm" + Environment.NewLine;
sqlRole += "ON usp_cRoleID=rlm_cRoleID" + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_UserRoles_usr" + Environment.NewLine;
sqlRole += "ON rlm_cRoleID=usr_cRoleID" + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_UserMaster_usm" + Environment.NewLine;
sqlRole += "ON usr_cUserLoginID=usm_cUserLoginID WHERE usm_cUserLoginID='" + info.usm_cUserLoginID + "'";
string sql = "SELECT distinct a.* FROM( (" + sqlString + ") union (" + sqlRole + ")) as a";
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_UserMaster_usm_Info cond = new Sys_UserMaster_usm_Info();
//// 请处理
cond.usm_cUserLoginID = info.usm_cUserLoginID;
//////
List <Sys_FormMaster_fom_Info> list = new List <Sys_FormMaster_fom_Info>();
var a = db.ExecuteQuery <Sys_FormMaster_fom_Info>(sql, new object[] { });
foreach (Sys_FormMaster_fom_Info t in a)
{
info.formMasterList.Add(t);
////////////////////// 请处理
cond.formMasterList.Clear();
cond.formMasterList.Add(t);
t.functionMaster = SearchRecords(cond)[0].functionMasterList;
//////////////////////
}
return(info);
}
}
catch (Exception Ex)
{
throw Ex;
}
}
private Sys_UserMaster_usm_Info FindFunction(Sys_UserMaster_usm_Info info)
{
string sqlString = string.Empty;
sqlString += "SELECT fum_iRecordID, fum_cFunctionNumber, fum_cFunctionDesc, fum_cRemark " + Environment.NewLine;
sqlString += "FROM Sys_FunctionMaster_fum " + Environment.NewLine;
sqlString += "LEFT JOIN Sys_FormPurview_frp" + Environment.NewLine;
sqlString += "ON fum_cFunctionNumber=frp_cFunctionNumber" + Environment.NewLine;
sqlString += "LEFT JOIN Sys_UserPurview_usp" + Environment.NewLine;
sqlString += "ON frp_cPurviewCode=usp_cPurviewCode" + Environment.NewLine;
sqlString += "LEFT JOIN Sys_UserMaster_usm" + Environment.NewLine;
sqlString += "ON usp_cUserLoginID=usm_cUserLoginID WHERE usm_cUserLoginID='" + info.usm_cUserLoginID + "'";
IEnumerable <Sys_FunctionMaster_fum_Info> infos = null;
List <Sys_FunctionMaster_fum_Info> infoList = null;
string sqlRole = string.Empty;
sqlRole += "SELECT fum_iRecordID, fum_cFunctionNumber, fum_cFunctionDesc, fum_cRemark " + Environment.NewLine;
sqlRole += "FROM Sys_FunctionMaster_fum " + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_FormPurview_frp" + Environment.NewLine;
sqlRole += "ON fum_cFunctionNumber=frp_cFunctionNumber" + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_UserPurview_usp" + Environment.NewLine;
sqlRole += "ON frp_cPurviewCode=usp_cPurviewCode" + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_RoleMaster_rlm" + Environment.NewLine;
sqlRole += "ON usp_cRoleID=rlm_cRoleID" + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_UserRoles_usr" + Environment.NewLine;
sqlRole += "ON rlm_cRoleID=usr_cRoleID" + Environment.NewLine;
sqlRole += "LEFT JOIN Sys_UserMaster_usm" + Environment.NewLine;
sqlRole += "ON usr_cUserLoginID=usm_cUserLoginID WHERE usm_cUserLoginID='" + info.usm_cUserLoginID + "'";
IEnumerable <Sys_FunctionMaster_fum_Info> roleInfos = null;
List <Sys_FunctionMaster_fum_Info> roleInfoList = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <Sys_FunctionMaster_fum_Info>(sqlString, new object[] { });
if (infos != null)
{
infoList = infos.ToList <Sys_FunctionMaster_fum_Info>();
}
foreach (Sys_FunctionMaster_fum_Info t in infoList)
{
info.functionMasterList.Add(t);
}
roleInfos = db.ExecuteQuery <Sys_FunctionMaster_fum_Info>(sqlRole, new object[] { });
if (roleInfos != null)
{
roleInfoList = roleInfos.ToList <Sys_FunctionMaster_fum_Info>();
}
foreach (Sys_FunctionMaster_fum_Info t in roleInfoList)
{
info.functionMasterList.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_UserMaster_usm_Info info = null;
info = itemEntity as Sys_UserMaster_usm_Info;
if (info == null)
{
msg.boolValue = false;
msg.messageText = "传入的数据为空！";
return(msg);
}
try
{
switch (EditMode)
{
case Common.DefineConstantValue.EditStateEnum.OE_Delete:
b = this._sysUserMasterDA.DeleteRecord(info);
if (b == true)
{
msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_RecordByDelete;
}
break;
case Common.DefineConstantValue.EditStateEnum.OE_Insert:
b = this._sysUserMasterDA.IsExistRecord(info);
if (b == false)
{
msg.boolValue = this._sysUserMasterDA.InsertRecord(info);
}
else
{
msg.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_I_AddFail + " 登陆ID重復！";
}
break;
case Common.DefineConstantValue.EditStateEnum.OE_Update:
msg.boolValue = this._sysUserMasterDA.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);
}
