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 bool InsertRecord(Sys_UserMaster_usm infoObject)
{
//throw new NotImplementedException();
string Sql = " INSERT INTO [Sys_UserMaster_usm] " + Environment.NewLine;
Sql = Sql + "([usm_cUserLoginID]" + Environment.NewLine;
Sql = Sql + ",[usm_cChaName]" + Environment.NewLine;
Sql = Sql + ",[usm_cPasswork]" + Environment.NewLine;
Sql = Sql + " ,[usm_cEMail]" + Environment.NewLine;
Sql = Sql + ",[usm_iLock]" + Environment.NewLine;
Sql = Sql + ",[usm_cRemark]" + Environment.NewLine;
Sql = Sql + ",[usm_cAdd]" + Environment.NewLine;
Sql = Sql + ",[usm_dAddDate]" + Environment.NewLine;
Sql = Sql + ",[usm_cLast]" + Environment.NewLine;
Sql = Sql + ",[usm_dLastDate])" + Environment.NewLine;
Sql = Sql + "VALUES" + Environment.NewLine;
Sql = Sql + "('" + infoObject.usm_cUserLoginID + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cChaName + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cPasswork + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cEMail + "'" + Environment.NewLine;
Sql = Sql + "," + (infoObject.usm_iLock ? 1 :0) + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cRemark + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cAdd + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_dAddDate.Value.ToString(Common.DefineConstantValue.gc_DateFormat) + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_cLast + "'" + Environment.NewLine;
Sql = Sql + ",'" + infoObject.usm_dLastDate.Value.ToString(Common.DefineConstantValue.gc_DateFormat) + "')" + Environment.NewLine;
return(false);
}
public Model.General.ReturnValueInfo Web_UserMaster_Pwd(Web_Sys_UserMaster_usm_PWD info)
{
Model.General.ReturnValueInfo returnValue = new Model.General.ReturnValueInfo();
returnValue.boolValue = false;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_UserMaster_usm tab = db.Sys_UserMaster_usms.SingleOrDefault(t => t.usm_cUserLoginID == info.usm_cUserLoginID && t.usm_cPasswork == info.usm_cOldPasswork);
if (tab != null)
{
tab.usm_cPasswork = info.usm_cNewPasswork;
db.SubmitChanges();
returnValue.boolValue = true;
returnValue.messageText = "修改成功！";
}
else
{
returnValue.messageText = "旧密码有误，请重新输入！";
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(returnValue);
}
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 bool IsExistRecord(object KeyObject)
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_UserMaster_usm usm = new Sys_UserMaster_usm();
try
{
usm = Common.General.CopyObjectValue <object, Sys_UserMaster_usm>(KeyObject);
IQueryable <Sys_UserMaster_usm> taQuery =
(from ta in db.Sys_UserMaster_usms where ta.usm_cUserLoginID == usm.usm_cUserLoginID select ta);
if (taQuery.Count() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool InsertRecord(Model.SysMaster.Sys_UserMaster_usm_Info infoObject)
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_UserMaster_usm usm = new Sys_UserMaster_usm();
try
{
usm = Common.General.CopyObjectValue <Sys_UserMaster_usm_Info, Sys_UserMaster_usm>(infoObject);
if (infoObject.roleMasterList != null && infoObject.roleMasterList.Count > 0)
{
for (int i = 0; i < infoObject.roleMasterList.Count; i++)
{
Sys_RoleMaster_rlm_Info usmInfo = infoObject.roleMasterList[i];
Sys_UserRoles_usr item = new Sys_UserRoles_usr();
item.usr_cUserLoginID = infoObject.usm_cUserLoginID;
item.usr_cRoleID = usmInfo.rlm_cRoleID;
//courseitem.cum_cNumber;
usm.Sys_UserRoles_usrs.Add(item);
//db.Sys_UserRoles_usrs.InsertOnSubmit(item);
}
}
db.Sys_UserMaster_usms.InsertOnSubmit(usm);
db.SubmitChanges();
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public bool UpdateRecord(Sys_UserMaster_usm infoObject)
{
throw new NotImplementedException();
}
public bool UpdateRecord(Model.SysMaster.Sys_UserMaster_usm_Info infoObject)
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
Sys_UserMaster_usm usm = new Sys_UserMaster_usm();
try
{
usm = db.Sys_UserMaster_usms.SingleOrDefault(t => t.usm_iRecordID == infoObject.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);
}
string sqlString = string.Empty;
Sys_UserMaster_usm_Info info = new Sys_UserMaster_usm_Info();
info = Common.General.CopyObjectValue <Sys_UserMaster_usm, Sys_UserMaster_usm_Info>(usm);
IEnumerable <Sys_UserMaster_usm_Info> IEusm = null;
IEnumerable <Sys_UserRoles_usr_Info> IEusr = null;
sqlString += "UPDATE Sys_UserMaster_usm" + Environment.NewLine;
sqlString += " SET usm_cUserLoginID='" + infoObject.usm_cUserLoginID + "'," + Environment.NewLine;
sqlString += " usm_cChaName='" + infoObject.usm_cChaName + "'," + Environment.NewLine;
sqlString += " usm_cPasswork='" + infoObject.usm_cPasswork + "'," + Environment.NewLine;
sqlString += " usm_cEMail='" + infoObject.usm_cEMail + "'," + Environment.NewLine;
sqlString += " usm_iLock='" + infoObject.usm_iLock + "'," + Environment.NewLine;
//sqlString += " fom_cExePath='" + infoObject.rlm_cLast + "'," + Environment.NewLine;
//sqlString += " usm_cRemark='" + infoObject.fom_iParentID + "'," + Environment.NewLine;
//sqlString += " fom_iIndex='" + infoObject.fom_iIndex + "'," + Environment.NewLine;
sqlString += " usm_cLast='" + infoObject.usm_cLast + "'," + Environment.NewLine;
sqlString += " usm_dLastDate='" + infoObject.usm_dLastDate.Value.ToString(DefineConstantValue.gc_DateTimeFormat) + "'" + Environment.NewLine;
sqlString += " WHERE usm_iRecordID='" + infoObject.usm_iRecordID + "'";
IEusm = db.ExecuteQuery <Sys_UserMaster_usm_Info>(sqlString, new object[] { });
sqlString = string.Empty;
sqlString += "DELETE FROM Sys_UserRoles_usr WHERE usr_cUserLoginID='" + infoObject.usm_cUserLoginID + "'";
IEusr = db.ExecuteQuery <Sys_UserRoles_usr_Info>(sqlString, new object[] { });
if (infoObject.roleMasterList != null && infoObject.roleMasterList.Count > 0)
{
for (int i = 0; i < infoObject.roleMasterList.Count; i++)
{
sqlString = string.Empty;
Sys_RoleMaster_rlm_Info rlmInfo = infoObject.roleMasterList[i];
sqlString += "INSERT INTO Sys_UserRoles_usr" + Environment.NewLine;
sqlString += "(usr_cUserLoginID, usr_cRoleID)" + Environment.NewLine;
sqlString += " VALUES " + Environment.NewLine;
sqlString += "('" + infoObject.usm_cUserLoginID + "','" + rlmInfo.rlm_cRoleID + "')";
IEusr = db.ExecuteQuery <Sys_UserRoles_usr_Info>(sqlString, new object[] { });
}
}
//if (usm != null)
//{
// //usm = Common.General.SetDataToLingQEntity(usm, infoObject);//时间溢出
// usm.usm_iLock = infoObject.usm_iLock;
// usm.usm_cPasswork = infoObject.usm_cPasswork;
// usm.usm_cEMail = infoObject.usm_cEMail;
// usm.usm_cRemark = infoObject.usm_cRemark;
// usm.usm_cLast = infoObject.usm_cLast;
// usm.usm_dLastDate = infoObject.usm_dLastDate.Value;
// if (infoObject.roleMasterList != null && infoObject.roleMasterList.Count > 0)
// {
// for (int i = 0; i < infoObject.roleMasterList.Count; i++)
// {
// Sys_RoleMaster_rlm_Info usmInfo = infoObject.roleMasterList[i];
// Sys_UserRoles_usr item = new Sys_UserRoles_usr();
// item.usr_cUserLoginID = infoObject.usm_cUserLoginID;
// item.usr_cRoleID = usmInfo.rlm_cRoleID;
// //courseitem.cum_cNumber;
// usm.Sys_UserRoles_usrs.Add(item);
// //db.Sys_UserRoles_usrs.InsertOnSubmit(item);
// }
// }
// db.SubmitChanges();
//}
return(true);
}
catch (Exception Ex)
{
throw Ex;
}
}
}
