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; } } }