public ActionResult Create(InstallModel m)
{
if (m.InstallType == "SCHEMA" || ModelState.IsValid) {
// Read embedded create script
Stream str = Assembly.GetExecutingAssembly().GetManifestResourceStream("Piranha.Data.Scripts.Create.sql") ;
String sql = new StreamReader(str).ReadToEnd() ;
str.Close() ;
// Read embedded data script
str = Assembly.GetExecutingAssembly().GetManifestResourceStream("Piranha.Data.Scripts.Data.sql") ;
String data = new StreamReader(str).ReadToEnd() ;
str.Close() ;
// Split statements and execute
string[] stmts = sql.Split(new char[] { ';' }) ;
using (IDbTransaction tx = Database.OpenTransaction()) {
// Create database from script
foreach (string stmt in stmts) {
if (!String.IsNullOrEmpty(stmt.Trim()))
SysUser.Execute(stmt, tx) ;
}
tx.Commit() ;
}
if (m.InstallType.ToUpper() == "FULL") {
// Split statements and execute
stmts = data.Split(new char[] { ';' }) ;
using (IDbTransaction tx = Database.OpenTransaction()) {
// Create user
SysUser usr = new SysUser() {
Login = m.UserLogin,
Email = m.UserEmail,
GroupId = new Guid("7c536b66-d292-4369-8f37-948b32229b83"),
CreatedBy = new Guid("ca19d4e7-92f0-42f6-926a-68413bbdafbc"),
UpdatedBy = new Guid("ca19d4e7-92f0-42f6-926a-68413bbdafbc"),
Created = DateTime.Now,
Updated = DateTime.Now
} ;
usr.Save(tx) ;
// Create user password
SysUserPassword pwd = new SysUserPassword() {
Id = usr.Id,
Password = m.Password,
IsNew = false
} ;
pwd.Save(tx) ;
// Create default data
foreach (string stmt in stmts) {
if (!String.IsNullOrEmpty(stmt.Trim()))
SysUser.Execute(stmt, tx) ;
}
tx.Commit() ;
}
}
return RedirectToAction("index", "account") ;
}
return Index() ;
}
public void GetData()
{
string _userid = Parameters["puserid"];
SysUserBiz biz = new SysUserBiz();
SysUser item = new SysUser();
item = biz.Select(_userid);
Response.Write(item.ToJson());
}
/// <summary>
/// 冻结/解冻用户
/// </summary>
/// <param name="user">系统用户</param>
/// <returns>业务操作结果</returns>
public async Task<OperationResult> LockUserOrNot(SysUser user)
{
user.CheckNotNull("user");
user.IsLocked = !user.IsLocked;
await UserRepository.UpdateAsync(user);
return new OperationResult(OperationResultType.Success, "操作成功");
}
protected void Page_Load(object sender, EventArgs e)
{
SysUser useritem = new SysUser();
useritem = GetUserInfo();
lbluserdesc.Text = useritem.FUserDesc;
lblusername.Text = useritem.FUserName;
this.menu.InnerHtml = SetMenu(useritem.FUserId);
}
public ActionResult Create(SysUser sysUser)
{
db.SysUsers.Add(sysUser);
db.SaveChanges();
return RedirectToAction("Index");
}
/// <summary>
/// Default constructor. Creates a model.
/// </summary>
public UserEditModel()
{
List<SysGroup> gr = SysGroup.GetFields("sysgroup_id, sysgroup_name",
new Params() { OrderBy = "sysgroup_id" }) ;
groups = new List<SysGroup>() ;
groups.Insert(0, new SysGroup()) ;
gr.Each<SysGroup>((i,g) => {
if (HttpContext.Current.User.IsMember(g.Id)) groups.Add(g) ;
});
User = new SysUser() ;
Password = new SysUserPassword() ;
Groups = new SelectList(groups, "Id", "Name") ;
}
//保存
private void btnSave_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (validationProvider.Validate())
{
if (Type == DBOperateType.Insert)
{
User = new SysUser();
User.Valid = true;
}
User.UserName = txtUserName.Text.Trim();
User.Password = txtPassword.Text;
User.RoleCode = lookUpRole.EditValue.ToString();
if (lookUpEmployee.EditValue == null)
User.EmployeeID = null;
else
User.EmployeeID = (int)lookUpEmployee.EditValue;
User.CheckComputer = cheCheckComputer.Checked;
User.IsLock = cheIsLock.Checked;
User.IsAdmin = cheIsAdmin.Checked;
User.ComputerCode = txtComputerCode.Text.Trim();
User.Remark = txtRemark.Text.Trim();
User.ModifyUser = Identity.CurrentUser.UserName;
User.ModifyDate = DateTime.Now;
if (Type == DBOperateType.Insert)
WcfServiceHelper.Client.InsertUser(User);
else
WcfServiceHelper.Client.UpdateUser(User);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
ControlsHelper.ShowErrorMessage("保存失败", ex.Message);
}
finally
{
this.Cursor = Cursors.Default;
}
}
public void SavePsw()
{
string _orgpsw = Parameters["orgpsw"];
string _newpsw = Parameters["newpsw"];
string _confirmpsw = Parameters["confirmpsw"];
SysUserBiz biz = new SysUserBiz();
ErrorEntity ErrInfo = new ErrorEntity();
SysUser useritem = new SysUser();
useritem = GetUserInfo();
if (_newpsw.Length < 6)
{
ErrInfo = new ErrorEntity(RespCode.SysUser0010);
}
else
{
int result = biz.UserChangePsw(useritem.FUserId, _orgpsw, _newpsw, _confirmpsw, out ErrInfo);
}
Response.Write(ErrInfo.ToJson());
}
protected void loginbtn_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string psw = txtUserPsw.Text;
ErrorEntity ErrInfo = new ErrorEntity();
SysUserBiz userbiz = new SysUserBiz();
SysUser useritem = new SysUser();
useritem = userbiz.UserLogin(username, psw, "PMMG", out ErrInfo);
if (ErrInfo.ErrorCode == RespCode.Success)
{
SetUserInfo(useritem);
Response.Redirect("~/partymember/default.aspx");
}
else
{
Server_Alert(ErrInfo.ErrorMessage);
return;
}
}
/// <summary>
/// 保存用户信息信息
/// </summary>
/// <param name="dtos">要保存的用户DTO信息</param>
/// <returns>业务操作结果</returns>
public async Task<OperationResult> SaveUsers(params SysUserDto[] dtos)
{
dtos.CheckNotNull("dtos");
UserRepository.UnitOfWork.TransactionEnabled = true;
foreach (SysUserDto dto in dtos)
{
IdentityResult result;
SysUser user = new SysUser();
if (dto.Id > 0)//处理编辑
{
user = UserManager.FindById(dto.Id);
if (user == null)
{
return new OperationResult(OperationResultType.QueryNull);
}
}
user = dto.MapTo(user);
//密码单独处理
if (!dto.Password.IsNullOrEmpty())
{
result = await UserManager.PasswordValidator.ValidateAsync(dto.Password);
if (!result.Succeeded)
{
return result.ToOperationResult();
}
user.PasswordHash = UserManager.PasswordHasher.HashPassword(dto.Password);
}
result = dto.Id > 0 ? await UserManager.UpdateAsync(user) : await UserManager.CreateAsync(user);
if (!result.Succeeded)
{
return new OperationResult(OperationResultType.Error, result.Errors.ExpandAndToString());
}
}
return UserRepository.UnitOfWork.SaveChanges() > 0
? new OperationResult(OperationResultType.Success,"保存成功")
: OperationResult.NoChanged;
}
public void SaveQuestion()
{
string _contentclassid = Parameters["pcontentclassid"];
string _questionbank = Parameters["pquestionbank"];
string _questionid = Parameters["pquestionid"];
string _questiontitile = Parameters["pquestiontitle"];
string _questiontype = Parameters["pquestiontype"];
string _questiondiffculty = Parameters["pquestiondifficulty"];
string _keyword = Parameters["pkeyword"];
string _desc = Parameters["pdesc"];
string _analysis = Parameters["panalysis"];
ErrorEntity ErrInfo = new ErrorEntity();
OEQuestionBiz biz = new OEQuestionBiz();
HQOnlineExam.ML.OEQuestion item = new HQOnlineExam.ML.OEQuestion();
SysUser useritem = new SysUser();
useritem = GetUserInfo();
item.AUserId = useritem.FUserId;
item.AUserName = useritem.FUserName;
item.FQuestionId = Convert.ToInt64(_questionid);
item.FQBankId = Convert.ToInt64(_questionbank);
item.FQuestionTitle = _questiontitile;
item.FQuestionType = _questiontype;
item.FQuestionDifficulty = _questiondiffculty;
item.FKeyWord = _keyword;
item.FQuestionDesc = _desc;
item.FQuestionAnalysis = _analysis;
item.FQuestionStatus = "1";
if (string.IsNullOrEmpty(_questionid) || _questionid == "0")
{
biz.Insert(item, out ErrInfo);
}
else
{
biz.Update(item, out ErrInfo);
}
Response.Write(ErrInfo.ToJson());
}
//constructor adds two users to the sysUser list
public myUserViewModel()
{
SysUser usr1 = new SysUser
{
EmailAddress = "*****@*****.**",
Password = "******",
FirstName = "User1",
LastName = "Test"
};
SysUser usr2 = new SysUser
{
EmailAddress = "*****@*****.**",
Password = "******",
FirstName = "User2",
LastName = "Test2"
};
List<SysUser> userList = new List<SysUser>();
userList.Add(usr1);
userList.Add(usr2);
//Attach class property value
this.sysUsers = userList;
}
public void Update(SysUser user)
{
context.Entry(user).State = System.Data.Entity.EntityState.Modified;
}
private void InitUser()
{
try
{
Response.Write(".........初始化用户<br/>");
#region 废弃
//SysUser sysUser = new SysUser();
//sysUser.Name = "系统管理员";
//sysUser.LoginAccount = "admin";
//sysUser.Password = "******";
//sysUser.Status = 0;
//Container.Instance.Resolve<SysUserService>().Create(sysUser);
//SysUser sysUser = new SysUser()
//{
// Name = "系统管理员",
// LoginAccount = "admin",
// Password = "******",
// Status = 0
//};
//Container.Instance.Resolve<SysUserService>().Create(sysUser);
#endregion
var allRole = Container.Instance.Resolve <SysRoleService>().GetAll();
Container.Instance.Resolve <SysUserService>().Create(new SysUser()
{
Name = "系统管理员",
LoginAccount = "admin",
Password = StringHelper.EncodeMD5("123456"),
Status = 0,
SysRoleList = (from m in allRole where m.ID == 2 select m).ToList(),
});
Container.Instance.Resolve <SysUserService>().Create(new SysUser()
{
Name = "莫宇",
LoginAccount = "my",
Password = StringHelper.EncodeMD5("123456"),
Status = 0,
SysRoleList = (from m in allRole where m.ID == 1 select m).ToList(),
});
for (int i = 0; i < 100; i++)
{
Container.Instance.Resolve <SysUserService>().Create(new SysUser()
{
Name = "用户" + i,
LoginAccount = "user" + i,
Password = StringHelper.EncodeMD5("123456"),
Status = 0
});
}
// ID=20 接单员
SysUser user = Container.Instance.Resolve <SysUserService>().GetEntity(20);
user.SysRoleList = (from m in allRole where m.ID == 3 select m).ToList();
Container.Instance.Resolve <SysUserService>().Edit(user);
// ID=[30, 35] 调度员
IList <int> idRange = new List <int>()
{
30, 31, 32, 33, 34, 35
};
var findUser = Container.Instance.Resolve <SysUserService>().Query(new List <ICriterion>()
{
Expression.In("ID", idRange.ToArray())
});
foreach (var item in findUser)
{
item.SysRoleList = (from m in allRole where m.ID == 4 select m).ToList();
Container.Instance.Resolve <SysUserService>().Edit(item);
}
// ID=[40, 45] 驾驶员
idRange = new List <int>()
{
40, 41, 42, 43, 44, 45
};
findUser = Container.Instance.Resolve <SysUserService>().Query(new List <ICriterion>()
{
Expression.In("ID", idRange.ToArray())
});
foreach (var item in findUser)
{
item.SysRoleList = (from m in allRole where m.ID == 6 select m).ToList();
Container.Instance.Resolve <SysUserService>().Edit(item);
}
// ID=[50, 55] 财务员
idRange = new List <int>()
{
50, 51, 52, 53, 54, 55
};
findUser = Container.Instance.Resolve <SysUserService>().Query(new List <ICriterion>()
{
Expression.In("ID", idRange.ToArray())
});
foreach (var item in findUser)
{
item.SysRoleList = (from m in allRole where m.ID == 6 select m).ToList();
Container.Instance.Resolve <SysUserService>().Edit(item);
}
// ID=[60, 65] 决策员
idRange = new List <int>()
{
60, 61, 62, 63, 64, 65
};
findUser = Container.Instance.Resolve <SysUserService>().Query(new List <ICriterion>()
{
Expression.In("ID", idRange.ToArray())
});
foreach (var item in findUser)
{
item.SysRoleList = (from m in allRole where m.ID == 7 select m).ToList();
Container.Instance.Resolve <SysUserService>().Edit(item);
}
Response.Write(".........初始化用户ok<br/>");
}
catch (Exception ex)
{
Response.Write(".........初始化用户Error<br/>");
}
}
public void Add(SysUser user)
{
context.SysUsers.Add(user);
}
public ViewResult UserForm(SysUser sysUser)
{
// INSERT SYSUSER...
// VALIDATED by ModelState:
// * Values exist for each required field.
// * EmailAddress is correct format.
// VALIDATED in code, following:
// * EmailAddress is unique in the data.
if (ModelState.IsValid)
{
string emailAddress = sysUser.EmailAddress;
string password = sysUser.Password;
string firstName = sysUser.FirstName;
string lastName = sysUser.LastName;
if (viewModelProp.sysUsers == null)
{
//Not a test...
viewModelProp = getUserList();
}
IList<Models.SysUser> userList = viewModelProp.sysUsers;
//Validate uniqueness of new user's email address...
var match = from u in userList
where u.EmailAddress == emailAddress
select u;
if (match.Count() > 0)
{
// EmailAddress not unique in data. Return to sender.
ViewBag.Message = "You already have a login. No need to register again.";
return View("Index", viewModelProp);
}
else
{
//Add user to the list...
userList.Add(sysUser);
//Sort records by email address, into a new collection...
IEnumerable<SysUser> orderedList = from u in userList
orderby u.EmailAddress
select u;
IList<SysUser> newIList = new List<SysUser>();
// Serialize list to XML...
XmlDocument xmlUsers = new XmlDocument();
XmlDeclaration dec = xmlUsers.CreateXmlDeclaration("1.0", null, null);
xmlUsers.AppendChild(dec);
XmlElement root = xmlUsers.CreateElement("Users");
xmlUsers.AppendChild(root);
foreach (Models.SysUser u in orderedList)
{
XmlElement nextUser = xmlUsers.CreateElement("User");
nextUser.SetAttribute("EmailAddress", u.EmailAddress);
nextUser.SetAttribute("Password", u.Password);
nextUser.SetAttribute("FirstName", u.FirstName);
nextUser.SetAttribute("LastName", u.LastName);
root.AppendChild(nextUser);
//add sorted member to new collection...
newIList.Add((Models.SysUser)u);
}
// replace unsorted List<> with new sorted one...
viewModelProp.sysUsers = newIList;
//Persist the updated Model:
PersistUsers(xmlUsers);
}
return View("Index", viewModelProp);
}
else
{
//Invalid, based on model field validation
//performed in MockUserAdmin.Models.sysUsers.
return View(viewModelProp.sysUsers);
}
}
/// <summary>
/// 导入数据
/// </summary>
private void DoImpData()
{
string prefix = FileModule.FindFirstByProperties("Name", "Portal").RootPath + "\\Default\\";
string FilePath = RequestData.Get("FileId") + "";
FilePath = prefix + FilePath;
DataTable Dt = ExcelToDataTable(FilePath, 4);
for (int i = 0; i < Dt.Rows.Count; i++)
{
try
{
string workno = Dt.Rows[i]["工号"] + "";
SysUser UserEnt = SysUser.FindFirstByProperties(SysUser.Prop_WorkNo, Dt.Rows[i]["工号"]);
SysGroup Group = SysGroup.TryFind(UserEnt.Pk_corp);
SysGroup DeptGroup = SysGroup.TryFind(UserEnt.Pk_deptdoc); //Dept
TravelMoneyConfig TM = new TravelMoneyConfig();
ComUtility Utility = new ComUtility();
string Money = string.Empty;
if (string.IsNullOrEmpty(Dt.Rows[i]["服务年限奖励金"] + ""))
{
Money = Utility.GetTravelMoney(workno);
decimal M = 0.0m;
if (decimal.TryParse(Money, out M))
{
TM.Money = M;
}
}
else
{
decimal M = 0.0m;
if (decimal.TryParse(Dt.Rows[i]["服务年限奖励金"] + "", out M))
{
TM.Money = M;
}
}
//基本津贴
decimal MK = 0.0m;
string BaseMoney = Utility.GetTravelBaseMoney(workno);
if (decimal.TryParse(BaseMoney, out MK))
{
TM.BaseMoney = MK;
}
TM.UserId = UserEnt.UserID;
TM.UserName = UserEnt.Name;
TM.WorkNo = UserEnt.WorkNo;
DateTime DTime = new DateTime();
if (DateTime.TryParse(UserEnt.Indutydate, out DTime))
{
TM.Indutydate = DTime;
}
if (!string.IsNullOrEmpty(Dt.Rows[i]["是否已用"] + ""))
{
string val = string.Empty;
val = ((Dt.Rows[i]["是否已用"] + "") == "是" || (Dt.Rows[i]["是否已用"] + "") == "Y") ? "Y" : "N";
TM.HaveUsed = val;
}
if (Group != null)
{
TM.Corp = Group.GroupID;
TM.CorpName = Group.Name;
}
if (DeptGroup != null)
{
TM.DeptId = DeptGroup.GroupID;
TM.DeptName = DeptGroup.Name;
}
TM.CreateTime = DateTime.Now;
TM.UserId = UserEnt.UserID;
TM.Create();
}
catch { }
}
this.PageState.Add("State", "1");
}
public async Task <bool> UpdateLoginUser(SysUser model) => await freeSql.Update <SysUser>().SetSource(model).Where(x => x.Id == model.Id).ExecuteAffrowsAsync() > 0;
public virtual bool Edit(ref ValidationErrors errors, SysUserModel model)
{
try
{
SysUser entity = m_Rep.GetById(model.Id);
if (entity == null)
{
errors.Add(Suggestion.Disable);
return(false);
}
entity.Id = model.Id;
entity.UserName = model.UserName;
entity.Password = model.Password;
entity.TrueName = model.TrueName;
entity.Card = model.Card;
entity.MobileNumber = model.MobileNumber;
entity.PhoneNumber = model.PhoneNumber;
entity.QQ = model.QQ;
entity.EmailAddress = model.EmailAddress;
entity.OtherContact = model.OtherContact;
entity.Province = model.Province;
entity.City = model.City;
entity.Village = model.Village;
entity.Address = model.Address;
entity.State = model.State;
entity.CreateTime = model.CreateTime;
entity.CreatePerson = model.CreatePerson;
entity.Sex = model.Sex;
entity.Birthday = model.Birthday;
entity.JoinDate = model.JoinDate;
entity.Marital = model.Marital;
entity.Political = model.Political;
entity.Nationality = model.Nationality;
entity.Native = model.Native;
entity.School = model.School;
entity.Professional = model.Professional;
entity.Degree = model.Degree;
entity.DepId = model.DepId;
entity.PosId = model.PosId;
entity.Expertise = model.Expertise;
entity.JobState = model.JobState;
entity.Photo = model.Photo;
entity.Attach = model.Attach;
if (m_Rep.Edit(entity))
{
return(true);
}
else
{
errors.Add(Suggestion.EditFail);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHandler.WriteException(ex);
return(false);
}
}
public void ReverseReceiptNodeTraceByQty(DocumentBalance docBalance, int quantity, SysUser user)
{
try {
SetService(); SerClient.ReverseReceiptNodeTraceByQty(docBalance, quantity, user);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
internal DocumentPackage CreateNewPackage(Document document, SysUser sysUser, bool isOpen,
DocumentPackage parent, string packType)
{
try
{
SetService();
return SerClient.CreateNewPackage(document, sysUser, isOpen, parent, packType);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public void ReverseReceiptNodeTraceByLabels(List<NodeTrace> nodeTraceList, SysUser user, DocumentType docType)
{
try {
SetService(); SerClient.ReverseReceiptNodeTraceByLabels(nodeTraceList, user, docType);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public void ReversePickingNodeTraceByLabels(List<NodeTrace> nodeTraceList, SysUser user, Bin restockBin)
{
try
{
SetService(); SerClient.ReversePickingNodeTraceByLabels(nodeTraceList, user, restockBin);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public void PickCrossDockProduct(Document purchase, IList<DocumentBalance> crossDockBalance, SysUser picker)
{
try {
SetService(); SerClient.PickCrossDockProduct(purchase, crossDockBalance.ToList(), picker); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public void DeleteSysUser(SysUser data)
{
try {
SetService(); SerClient.DeleteSysUser(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public SysUser SaveSysUser(SysUser data)
{
try {
SetService(); return SerClient.SaveSysUser(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Aim.Portal.Web.WebPortalService.CheckLogon();
}
catch
{
Response.Write("<script> window.parent.location.href = '/Login.aspx';</script>");
Response.End();
}
string action = Request["action"];
SysGroup sgEnt = null;
SysUser suEnt = null;
IList <SysUser> suEnts = null;
string sql = "";
DataTable dt = null;
string where = "";
MD5Encrypt encrypt = new MD5Encrypt();
switch (action)
{
case "sync":
string connstr = ConfigurationManager.ConnectionStrings["NimsConn"].ToString();
OracleConnection conn = new OracleConnection(connstr);
sql = "select * from apps.cux_hr_org_structrue_v where ORG_ID_CHILD='228' or org_id_parent='228'";
OracleCommand com = new OracleCommand(sql, conn);
OracleDataAdapter da = new OracleDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
//首先同步部门信息
foreach (DataRow dr in ds.Tables[0].Rows)
{
sgEnt = SysGroup.TryFind(dr["ORG_ID_CHILD"] + "");
if (sgEnt == null) //如果不存在该部门
{
//此处将PATH字段用来存储父部门的名称
sql = "insert into SysGroup (GroupID,Name,Code,ParentID,Path,Status) values('{0}','{1}','{2}','{3}','{4}',1)";
sql = string.Format(sql, dr["ORG_ID_CHILD"], dr["ORG_NAME_CHILD"], dr["ORG_CODE_CHILD"], dr["ORG_ID_PARENT"], dr["ORG_NAME_PARENT"]);
DataHelper.ExecSql(sql);
}
else
{
sql = "update SysGroup set Name='{0}',Code='{1}',ParentID='{2}',Path='{3}' where GroupID='{4}'";
sql = string.Format(sql, dr["ORG_NAME_CHILD"], dr["ORG_CODE_CHILD"], dr["ORG_ID_PARENT"], dr["ORG_NAME_PARENT"], dr["ORG_ID_CHILD"]);
DataHelper.ExecSql(sql);
}
}
//同步人员信息
sql = @"select * from apps.cux_hr_employee_v where ORG_ID in
(select ORG_ID_CHILD from apps.cux_hr_org_structrue_v where ORG_ID_CHILD='228' or org_id_parent='228') and primary_flag='Y'";
com = new OracleCommand(sql, conn);
da = new OracleDataAdapter(com);
ds = new DataSet();
da.Fill(ds);
SqlConnection conn_sql = new SqlConnection();
conn_sql.ConnectionString = ConfigurationManager.AppSettings["Con_Portal"];
conn_sql.Open();
foreach (DataRow dr in ds.Tables[0].Rows)
{
suEnts = SysUser.FindAllByProperty(SysUser.Prop_IDNumber, dr["NATIONAL_IDENTIFIER"]); //通过身份证就行匹配
if (suEnts.Count == 0)
{
sql = @"insert into SysUser (UserID,LoginName,Name,Password,Email,Phone,HomePhone,Sex,IDNumber,Server_IAGUID,Server_Seed,Status,CreateDate)
values(@UserID,@LoginName,@Name,@Password,@Email,@Phone,@HomePhone,@Sex,@IDNumber,@Server_IAGUID,@Server_Seed,@Status,@CreateDate)";
SqlParameter[] sparray = new SqlParameter[13];
sparray[0] = new SqlParameter("@UserID", dr["PERSON_ID"]);
sparray[1] = new SqlParameter("@LoginName", dr["EMP_NUM"]);//NIMS数据库工号是不能为空的 即进入的NIMS系统的员工工号是肯定有的
sparray[2] = new SqlParameter("@Name", dr["LAST_NAME"]);
sparray[3] = new SqlParameter("@Password", encrypt.GetMD5FromString(dr["SYS_ACCOUNT"].ToString()));
sparray[4] = new SqlParameter("@Email", dr["EMAIL_ADDRESS"]);
sparray[5] = new SqlParameter("@Phone", dr["MOBILE_PHONE_NUMBER"]);
sparray[6] = new SqlParameter("@HomePhone", dr["OFFICE_PHONE_NUMBER"]);
sparray[7] = new SqlParameter("@Sex", dr["SEX"]);
sparray[8] = new SqlParameter("@IDNumber", dr["NATIONAL_IDENTIFIER"]);
sparray[9] = new SqlParameter("@Server_IAGUID", dr["ORG_ID"]);
sparray[10] = new SqlParameter("@Server_Seed", dr["ORG_NAME"]);
sparray[11] = new SqlParameter("@Status", SqlDbType.TinyInt);
sparray[11].Value = 1;
sparray[12] = new SqlParameter("@CreateDate", dr["HIRE_DATE"]);
SqlCommand com_sql = new SqlCommand(sql, conn_sql);
com_sql.Parameters.AddRange(sparray);
com_sql.ExecuteNonQuery();
}
else
{
sql = @"update SysUser set LoginName=@LoginName,Name=@Name,Email=@Email,Phone=@Phone,HomePhone=@HomePhone,
Sex=@Sex,Server_IAGUID=@Server_IAGUID,Server_Seed=@Server_Seed,CreateDate=@CreateDate where IDNumber=@IDNumber";
SqlParameter[] sparray = new SqlParameter[10];
sparray[0] = new SqlParameter("@LoginName", dr["EMP_NUM"]);
sparray[1] = new SqlParameter("@Name", dr["LAST_NAME"]);
sparray[2] = new SqlParameter("@Email", dr["EMAIL_ADDRESS"]);
sparray[3] = new SqlParameter("@Phone", dr["MOBILE_PHONE_NUMBER"]);
sparray[4] = new SqlParameter("@HomePhone", dr["OFFICE_PHONE_NUMBER"]);
sparray[5] = new SqlParameter("@Sex", dr["SEX"]);
sparray[6] = new SqlParameter("@Server_IAGUID", dr["ORG_ID"]);
sparray[7] = new SqlParameter("@Server_Seed", dr["ORG_NAME"]);
sparray[8] = new SqlParameter("@CreateDate", dr["HIRE_DATE"]);
sparray[9] = new SqlParameter("@IDNumber", dr["NATIONAL_IDENTIFIER"]);
SqlCommand com_sql = new SqlCommand(sql, conn_sql);
com_sql.Parameters.AddRange(sparray);
com_sql.ExecuteNonQuery();
}
}
conn_sql.Close();
Response.Write("{success:true}");
Response.End();
break;
case "inipsd":
suEnt = SysUser.Find(Request["UserId"]);
suEnt.Password = encrypt.GetMD5FromString(suEnt.LoginName);
suEnt.DoUpdate();
Response.Write("{success:true}");
Response.End();
break;
case "loadtreedata":
string id = Request["id"];
sql = "select GroupID as id,replace(Name,'江西瑞林建设监理有限公司','') as name,1 as leaf from SysGroup where ParentId='" + id + "' order by Code asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write(JsonHelper.GetJsonStringFromDataTable(dt));
Response.End();
break;
case "loaduser":
string groupid = Request["groupid"];
if (!string.IsNullOrEmpty(Request["name_workno"]))
{
where += " and (LoginName like '%" + Request["name_workno"] + "%' or Name like '%" + Request["name_workno"] + "%')";
}
if (!string.IsNullOrEmpty(Request["UserType"]))
{
where += " and UserType='" + Request["UserType"] + "'";
}
if (!string.IsNullOrEmpty(Request["Status"]))
{
where += " and Status='" + Request["Status"] + "'";
}
if (string.IsNullOrEmpty(groupid) || groupid == "228")
{
sql = @"select UserID as UserId,Name,LoginName,Sex,Phone,Replace(Server_Seed,'江西瑞林建设监理有限公司','') as Server_Seed,
HomePhone,IDNumber,CreateDate from SysUser where
(Server_Seed like '%江西瑞林建设监理有限公司%' ) " + where;
}
else
{
sql = @"select UserID as UserId,Name,LoginName,Sex,Phone,Replace(Server_Seed,'江西瑞林建设监理有限公司','') as Server_Seed,
HomePhone,IDNumber,CreateDate,Status from SysUser
where Server_Seed like '%江西瑞林建设监理有限公司%' and Server_IAGUID='" + groupid + "'" + where;
}
dt = DataHelper.QueryDataTable(sql);
Response.Write("{'rows':" + JsonHelper.GetJsonStringFromDataTable(dt) + ",total:'" + totalProperty + "'}");
Response.End();
break;
}
}
public Label PickProductWithTrack(Document document, Label label, double qtyToPick, Node node, SysUser picker, Label packLabel)
{
try
{
SetService();
return SerClient.PickProductWithTrack(document, label, qtyToPick, node, picker, packLabel);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public override int SaveChanges()
{
if (this._DoNotModifyTableBaseInfo)
{
return(base.SaveChanges());
}
List <DbEntityEntry> entities =
ChangeTracker.Entries().Where(x => x.State == EntityState.Added || x.State == EntityState.Modified || x.State == EntityState.Deleted).ToList();
foreach (DbEntityEntry entity in entities)
{
if (entity.Entity is SysTableBase)
{
SysTableBase entityBase = entity.Entity as SysTableBase;
DateTime now = DateTime.Now;
SysUser user = null;
if (HttpContext.Current.Session[MySessionNames.login] != null)
{
user = HttpContext.Current.Session[MySessionNames.login] as SysUser;
}
switch (entity.State)
{
case EntityState.Added:
entityBase.CreatedOn = now;
entityBase.CreatedUser = user?.Username ?? MyMagicStrings.noname;
break;
case EntityState.Deleted:
//// TODO : Eğer hiçbir kayıt silinmesin istenirse, ilgili entity'e IIneffaceable interface implement edilmeli ve IsDeleted = true yapılarak entity.state = EntityState.Modified olarak değiştirilmeli.
//entityBase.ModifiedOn = now;
//entityBase.ModifiedUser = App.CurrentUser?.KullaniciAdi ?? MagicStrings.noname;
//// ***************************************************************************
//// Silinen kayıtlar günlük olarak yyyyMMdd.xml isimli bir dosyada saklanır.
//// Sadece DbTableBase 'den türemiş olan nesneler için bu kayıt yapılır.
//// ***************************************************************************
//string fileName = DateTime.Now.ToString("yyyyMMdd") + ".xml";
//string filePath = HttpContext.Current.Server.MapPath(@"~\Removed\" + fileName);
//XDocument xdoc = null;
//if (File.Exists(filePath))
//{
// xdoc = XDocument.Load(filePath);
//}
//else
//{
// xdoc = new XDocument(
// new XDeclaration("1.0", "utf-8", "no"),
// new XElement("items"));
//}
//string entityXml = EntitySerializer.Serialize(entity.Entity.GetType(), entity.Entity);
//XElement xe = XElement.Parse(entityXml);
//xdoc.Root.Add(xe);
//xdoc.Save(filePath);
//// ***************************************************************************
//// ***************************************************************************
break;
case EntityState.Detached:
break;
case EntityState.Modified:
entityBase.ModifiedOn = now;
entityBase.ModifiedUser = user?.Username ?? MyMagicStrings.noname;
break;
case EntityState.Unchanged:
break;
default:
break;
}
}
}
return(base.SaveChanges());
}
internal void ReceiveReturn(Document document, IList<ProductStock> retProduct, SysUser sysUser, double retTotalQty, Node recNode)
{
try
{
SetService();
SerClient.ReceiveReturn(document, retProduct.ToList(), sysUser, retTotalQty, recNode);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
//添加用户
public void Add(SysUser sysUser)
{
db.SysUsers.Add(sysUser);
db.SaveChanges();
}
internal void ReceiptAcknowledge(Document document, double numLabels, SysUser sysUser)
{
try
{
SetService();
SerClient.ReceiptAcknowledge(document, numLabels, sysUser, null);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
/// <summary>
/// Maps a Piranha CMS user to a membership user.
/// </summary>
/// <param name="user">The user</param>
/// <returns>The membership user</returns>
private MembershipUser MapUser(SysUser user) {
return new MembershipUser("Piranha.Security.InternalUserProvider", user.Login, user.Id, user.Email, "", "", true,
user.IsLocked, user.Created, user.LastLogin, user.LastLogin, user.Created, user.Created) ;
}
internal Label PickUniqueLabel(Document document, Node node, Product product, string serialLabel, SysUser picker, Label packLabel)
{
try
{
SetService();
return SerClient.PickUniqueLabel(document, node, product, serialLabel, picker, packLabel);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public virtual async Task AddUser(SysUser user, CancellationToken cancellationToken = default)
{
await _userRepository.InsertAsync(user, cancellationToken);
await _financeRepository.InsertAsync(new SysUserFinance { Id = user.Id, Amount = 0.00M }, cancellationToken);
}
internal void UnPickUniqueLabel(Document document, Label label, SysUser picker)
{
try
{
SetService();
SerClient.UnPickUniqueLabel(document, label, picker);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
private void InitUsers(ExtendedIdentityDbContext context)
{
IdentityManager manager = new IdentityManager(context);
var userManager = manager.UserManager;
var roleManager = manager.RoleManager;
//InitRoles(roleManager);
#if DEBUG
//var user = new SysUser()
//{
// UserName = "******",
// Email = "*****@*****.**",
// Name = "梁达文",
// PhoneNumber = "13826403668",
//};
//FindCreateAssignRole(userManager, roleManager, user, "Admin@12345", "系统管理员");
var user = new SysUser()
{
//Id = Guid.NewGuid().ToString(),
UserName = "******",
Email = "*****@*****.**",
Name = "Iris Xiao",
PhoneNumber = "18666031989",
};
FindCreateAssignRole(userManager, roleManager, user, "Iris2013", "Manager");
user = new SysUser()
{
//Id = Guid.NewGuid().ToString(),
UserName = "******",
Email = "*****@*****.**",
Name = "Common User",
PhoneNumber = "18666031989",
};
FindCreateAssignRole(userManager, roleManager, user, "CommonUser", "一般用户");
#else
//var user = new SysUser()
//{
// //Id = Guid.NewGuid().ToString(),
// UserName = "******",
// Email = "*****@*****.**",
// Name = "Administrator",
// PhoneNumber = "13826403668",
//};
//FindCreateAssignRole(userManager, roleManager, user, "Admin@12345", "系统管理员");
var user = new SysUser()
{
//Id = Guid.NewGuid().ToString(),
UserName = "******",
Email = "*****@*****.**",
Name = "Iris Xiao",
PhoneNumber = "18666031989",
};
FindCreateAssignRole(userManager, roleManager, user, "Iris2013", "Manager");
user = new SysUser()
{
//Id = Guid.NewGuid().ToString(),
UserName = "******",
Email = "*****@*****.**",
Name = "Common User",
PhoneNumber = "18666031989",
};
FindCreateAssignRole(userManager, roleManager, user, "CommonUser", "一般用户");
#endif
}
private void InputDatas(DataTable dt)
{
foreach (DataRow row in dt.Rows)
{
if (row[2] != null && row[2].ToString().Trim() != "")
{
string workNo = "";
try
{
if (SysUser.FindAllByProperties("WorkNo", row[1].ToString().Trim()).Length == 0)
{
SysUser sysUser = new SysUser();
sysUser.WorkNo = row[1].ToString().Trim();
sysUser.Name = row[2].ToString().Trim();
if (row[3].ToString().Trim() == "")
{
sysUser.LoginName = GetPingyin(row[2].ToString().Trim());
}
else
{
sysUser.LoginName = row[3].ToString();
}
sysUser.Email = row[5].ToString();
sysUser.Remark = row[6].ToString();
sysUser.Status = 1;
sysUser.CreateDate = DateTime.Now;
sysUser.Save();
if (SysGroup.FindAllByProperties("Name", row[4].ToString().Trim()).Length > 0)
{
using (new SessionScope())
{
SysGroup grp = SysGroup.FindAllByProperties("Name", row[4].ToString().Trim())[0];
IList <string> userIDs = new List <string>();
userIDs.Add(sysUser.UserID);
grp.AddUsers(userIDs);
}
}
}
else
{
if (SysGroup.FindAllByProperties("Name", row[4].ToString().Trim()).Length > 0)
{
SysUser sysUser = SysUser.FindAllByProperties("WorkNo", row[1].ToString().Trim())[0];
using (new SessionScope())
{
if (sysUser.RetrieveAllGroup().Where(en => en.Type == 2 && en.Name != row[4].ToString()).Count() == 0)
{
if (sysUser.RetrieveAllGroup().Where(en => en.Type == 2).Count() > 0)
{
foreach (SysGroup gp in sysUser.RetrieveAllGroup().Where(en => en.Type == 2))
{
gp.User.Remove(sysUser);
}
}
SysGroup grp = SysGroup.FindAllByProperties("Name", row[4].ToString().Trim())[0];
IList <string> userIDs = new List <string>();
userIDs.Add(sysUser.UserID);
grp.AddUsers(userIDs);
}
}
}
}
}
catch (Exception e)
{
continue;
}
}
}
}
public ActionResult Details(int ID)
{
SysUser sysUser = iSysUserR.SelectByID(ID);// db.SysUsers.Find(ID);
return(View(sysUser));
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Request.Files.Count > 0)
{
string guid = Guid.NewGuid().ToString();
string filePath = "//WorkTime//InputExcelFiles//" + Guid.NewGuid().ToString() + System.IO.Path.GetExtension(Request.Files[0].FileName);
this.Request.Files[0].SaveAs(Server.MapPath(filePath));
ExcelProcessor ep = ExcelService.GetProcessor(Server.MapPath(filePath));
DataSet ds = ep.GetDataSet();
InputDatas(ds.Tables[0]);
Response.Write("{success:true}");
Response.End();
}
id = RequestData.Get <string>("id", String.Empty);
type = RequestData.Get <string>("type", String.Empty);
SearchCriterion.AutoOrder = false;
SearchCriterion.SetOrder(SysUser.Prop_WorkNo);
string dName = SearchCriterion.GetSearchValue <string>("Name");
string workNo = SearchCriterion.GetSearchValue <string>("WorkNo");
SearchCriterion.SetOrder(SysUser.Prop_WorkNo);
if (dName != null && dName.Trim() != "")
{
string where = "select * from SysUser where " + GetPinyinWhereString("Name", dName);
where += " and WorkNo like '%" + workNo + "%'";
this.PageState.Add("UsrList", DataHelper.QueryDictList(where));
}
else
{
users = SysUserRule.FindAll(SearchCriterion);
this.PageState.Add("UsrList", users);
}
SysUser usr = null;
switch (this.RequestAction)
{
case RequestActionEnum.Create:
usr = this.GetPostedData <SysUser>();
usr.DoCreate();
this.SetMessage("新建成功！");
break;
case RequestActionEnum.Update:
usr = this.GetMergedData <SysUser>();
usr.DoUpdate();
this.SetMessage("保存成功！");
break;
case RequestActionEnum.Delete:
usr = this.GetTargetData <SysUser>();
usr.DoDelete();
this.SetMessage("删除成功！");
break;
default:
if (RequestActionString == "clearpass")
{
usr = SysUser.Find(this.RequestData.Get <string>("UserId"));
usr.Password = "";
usr.Remark = "";
usr.Save();
}
else if (RequestActionString == "setpass")
{
MD5Encrypt encrypt = new MD5Encrypt();
SysUser[] users = SysUser.FindAll();
foreach (SysUser user in users)
{
Random rnd = new Random();
int rndNum = rnd.Next(10000000, 99999999);
string encryPassword = encrypt.GetMD5FromString(rndNum.ToString());
user.Password = encryPassword;
user.Remark = rndNum.ToString();
user.Save();
}
}
else if (RequestActionString == "checkkey")
{
if (SysUser.FindAllByProperties("Server_IAGUID", this.RequestData.Get <string>("usbguid")).Length > 0)
{
this.PageState.Add("UserName", SysUser.FindAllByProperties("Server_IAGUID", this.RequestData.Get <string>("usbguid"))[0].Name);
}
else
{
this.PageState.Add("UserName", "");
}
}
else if (RequestActionString == "setkey")
{
SysUser user = SysUser.Find(this.RequestData.Get <string>("userid"));
user.Server_IAGUID = this.RequestData.Get <string>("usbguid");
user.Server_Seed = "FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF";
user.ThreeDESKEY = "ABCDEFGhijklmn0123456789";
user.Save();
}
else if (RequestActionString == "sendmail")
{
IList <object> idList = RequestData.GetList <object>("IdList");
SysUser[] tents = SysUser.FindAll(Expression.In("UserID", idList.ToArray()));
foreach (SysUser user in tents)
{
string body = SysParameter.FindAllByProperties("Code", "MailText")[0].Description + "<br>";
body += "您的登录用户名:" + user.LoginName + ";密码:" + user.Remark;
string mailAccount = SysParameter.FindAllByProperties("Code", "MailAccount")[0].Value;
string mailPass = SysParameter.FindAllByProperties("Code", "MailPassword")[0].Value;
string mailServer = SysParameter.FindAllByProperties("Code", "MailSmtpServer")[0].Value;
string mailSenderAddress = SysParameter.FindAllByProperties("Code", "MailSenderAddress")[0].Value;
MailHelper.SendMail(mailSenderAddress, user.Email, "工时分配系统邮件", body, mailAccount, mailPass, mailServer);
}
}
break;
}
}
public void Delete(int UseID)
{
SysUser user = context.SysUsers.Find(UseID);
context.SysUsers.Remove(user);
}
public ActionResult ConfigServiceRight(int roleId = -1, int userId = 0)
{
//具有国内/国际开发主管角色的登入用户进入该页后，角色下拉列表只列出国内/国际开发主管，
//否则，列出国内开发主管和国际开发主管两角色：
SysRoleLogic roleLogic = new SysRoleLogic();
List <SysRole> roleList = roleLogic.GetRoleList().ToList <SysRole>();
LoginUserInfo currentLogin = this.WorkContext.CurrentUser;
//7表示国内开发主管角色，8表示国际开发主管角色
if (currentLogin.RoleId == 7 || currentLogin.RoleId == 8)
{
roleList = roleList.Where(x => x.RoleId == currentLogin.RoleId).ToList <SysRole>();
}
else
{
roleList = roleList.Where(x => (x.RoleId == 7 || x.RoleId == 8)).ToList <SysRole>();
}
ViewBag.RoleId = new SelectList(roleList, "RoleId", "RoleName");
if (roleId < 1)
{
if (currentLogin.RoleId == 7 || currentLogin.RoleId == 8)
{
ViewBag.CurrentRoleId = currentLogin.RoleId;
}
else
{
ViewBag.CurrentRoleId = 7;
}
}
else
{
ViewBag.CurrentRoleId = roleId;
}
List <SysUser> userList = GetUserList(roleId);
ViewBag.UserId = new SelectList(userList, "UserId", "RealName");
ViewBag.CurrentUserId = userId;
List <SysRoleRight> roleRightList = new List <SysRoleRight>();
if (roleId > 0)
{
SysApplicationLogic appIdMenuLogic = new SysApplicationLogic();
//求配置中心权限管理模块的各菜单项：
List <SysApplicationEntity> appIdMenuList = null;
SysUserLogic sysUserLogic = new SysUserLogic();
SysUser sysUser = null;
int? selectedUserId = -1;
string selectedUserName = string.Empty;
switch (roleId)
{
case 7: //国内开发主管角色，目前只求针对国内机票产品线的配置中心权限管理模块的各菜单项：
sysUser = sysUserLogic.GetUserInfo(userId);
if (sysUser != null)
{
selectedUserName = sysUser.RealName;
ViewBag.CurrentUserName = selectedUserName;
}
appIdMenuList = appIdMenuLogic.GetSysApplicationList(-1, -1, "", -1, -1, null, new List <int> {
1
}, selectedUserName).ToList <SysApplicationEntity>();
break;
case 8: //国际开发主管角色，目前只求针对国际机票产品线的配置中心权限管理模块的各菜单项：
sysUser = sysUserLogic.GetUserInfo(userId);
if (sysUser != null)
{
selectedUserName = sysUser.RealName;
ViewBag.CurrentUserName = selectedUserName;
}
appIdMenuList = appIdMenuLogic.GetSysApplicationList(-1, -1, "", -1, -1, null, new List <int> {
2
}, selectedUserName).ToList <SysApplicationEntity>();
break;
default:
break;
}
ViewBag.AppIdMenuList = appIdMenuList;
selectedUserId = ViewBag.CurrentUserId as int?;
roleRightList = logic.GetRoleRightList(roleId, true, (selectedUserId.HasValue ? Convert.ToInt32(selectedUserId) : -1)).ToList <SysRoleRight>();
}
return(View(roleRightList));
}
public VMregisterInfomation Register(ViewModelRegister viewmodelRegister)
{
VMregisterInfomation vMregisterInfomation = null;
try
{
vMregisterInfomation = new VMregisterInfomation();
if (viewmodelRegister.Account != "") //判断用户账号是否为空
{
var u = unitOfWork.SysUserRepository.Get().Where(s => s.UserAccount.Equals(viewmodelRegister.Account)).FirstOrDefault(); //查找是否存在账号，存在返回账号所在对象，否则返回null
if (u == null) //判断账号是否存在
{
// 账号规范放在 UI 进行
#region 账号规范
foreach (char c in viewmodelRegister.Account) //规范账号必须由字母和数字构成
{
if (!(('0' <= c && c <= '9') || ('A' <= c && c <= 'Z') || ('a' <= c && c <= 'z')))
{
throw new Exception("账号必须只由字母和数字构成！");
}
}
#endregion
if (viewmodelRegister.Password != "") //判断密码是否为空
{
// 密码规范放在 UI 进行
#region 密码规范
int number = 0, character = 0;
foreach (char c in viewmodelRegister.Password) //规范密码必须由ASCII码33~126之间的字符构成
{
if (!(33 <= c && c <= 126))
{
throw new Exception("符号错误，请重新输入！");
}
if ('0' <= c && c <= '9') //number记录数字个数
{
number++;
}
else //character记录字符个数
{
character++;
}
}
if (number < 5 || character < 2) //密码的安全系数
{
throw new Exception("密码安全系数太低！");
}
#endregion
if (viewmodelRegister.Password.Equals(viewmodelRegister.SurePassword)) //判断密码与确认密码是否相等 放在 UI 进行
{
if (viewmodelRegister.Answer != "1" + "2" + "3" + "4" + "5") //判断拾回密码是否为空
{
// 下面需要调试 看看 ，逻辑过程是否合理，另外角色根据具体场景，一般是默认缺省的角色，其他的角色在用户管理界面进行重新 赋予高级角色
var sysRole = unitOfWork.SysRoleRepository.Get().Where(s => s.RoleName.Equals(viewmodelRegister.RoleName)).FirstOrDefault(); //寻找用户所选择角色在UserRole里的实例，返回对象
if (sysRole != null)
{
var CurrentUser = new SysUser();
CurrentUser.UserAccount = viewmodelRegister.Account;
CurrentUser.UserPassword = CreateMD5.EncryptWithMD5(viewmodelRegister.Password);
CurrentUser.UserAnswer = CreateMD5.EncryptWithMD5(viewmodelRegister.Answer);
CurrentUser.RememberPassword = "******";
unitOfWork.SysUserRepository.Insert(CurrentUser); //增加新SysUser
unitOfWork.Save();
var CurrentUserRole = new SysUserRole();
CurrentUserRole.SysUserID = CurrentUser.ID;
CurrentUserRole.SysRoleID = sysRole.ID;
unitOfWork.SysUserRoleRepository.Insert(CurrentUserRole); //增加新SysUserRole
unitOfWork.Save(); //对更改进行保存
vMregisterInfomation.message = "注册成功";
return(vMregisterInfomation);
}
}
else
{
throw new Exception("密码拾回问题答案不能为空！");
}
}
else
{
throw new Exception("两次输入的密码不一致！");//2次密码不一致放在 UI 进行判断
}
}
else
{
throw new Exception("密码不能为空！");
}
}
else
{
throw new Exception("用户名已存在！");
}
}
else
{
throw new Exception("账号不能为空！");
}
}
catch (Exception ex)
{
vMregisterInfomation.message = ex.Message;
return(vMregisterInfomation);
}
return(vMregisterInfomation);
}
public ActionResult Edit(SysUser sysUser)
{
db.Entry(sysUser).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
protected override void Seed(SomeProject.Core.Model.DefaultDbContext context)
{
base.Seed(context);
return;
List <SysRole> roles = new List <SysRole>
{
new SysRole {
Name = "系统管理", Description = "系统管理角色，拥有整个系统的管理权限。", RoleType = RoleType.Admin
},
new SysRole {
Name = "蓝钻", Description = "蓝钻会员角色", RoleType = RoleType.Guest
},
new SysRole {
Name = "红钻", Description = "红钻会员角色", RoleType = RoleType.Guest
},
new SysRole {
Name = "黄钻", Description = "黄钻会员角色", RoleType = RoleType.Guest
},
new SysRole {
Name = "绿钻", Description = "绿钻会员角色", RoleType = RoleType.Guest
}
};
DbSet <SysRole> roleSet = context.Set <SysRole>();
roleSet.AddOrUpdate(m => new { m.Name }, roles.ToArray());
context.SaveChanges();
List <SysUser> users = new List <SysUser>
{
new SysUser {
UserName = "******", Password = "******", Email = "*****@*****.**", NickName = "管理员"
},
new SysUser {
UserName = "******", Password = "******", Email = "*****@*****.**", NickName = "张三"
}
};
for (int i = 0; i < 100; i++)
{
Random rnd = new Random((int)DateTime.Now.Ticks + i);
SysUser user = new SysUser
{
UserName = "******" + i,
Password = "******",
Email = "userName" + i + "@cn.net",
NickName = "用户" + i
};
var roleArray = roleSet.ToArray();
if (user.Roles == null)
{
user.Roles = new List <SysRole>();
}
user.Roles.Add(roleArray[rnd.Next(0, roleArray.Length)]);
if (rnd.NextDouble() > 0.5)
{
user.Roles.Add(roleArray[rnd.Next(1, roleArray.Length)]);
}
users.Add(user);
}
DbSet <SysUser> userSet = context.Set <SysUser>();
userSet.AddOrUpdate(m => new { m.UserName }, users.ToArray());
}
/// <summary>
/// 编辑用户信息
/// </summary>
/// <param name="user">修改用户名，性别，密码，地址，qq，手机</param>
/// <param name="token"></param>
/// <returns></returns>
public JsonResult EditeUserInfo(string username, int sex, int age)
{
var Res = new JsonResult();
RespResult result = new RespResult();
try
{
if (!CacheManagerFactory.GetMemoryManager().Contains(token))
{
result.Error = AppError.ERROR_PERSON_NOT_LOGIN;
}
else
{
int userid = Convert.ToInt32(CacheManagerFactory.GetMemoryManager().Get(token));
if (userid > 0)
{
SysUser olduser = SysUserAccessor.Instance.Get(userid);
olduser.UserName = username;
olduser.Sex = sex;
olduser.Birthday = DateTime.Now.AddYears(-age);
//olduser.Pwd = user.Pwd;
//olduser.Province = user.Province;
//olduser.City = user.City;
//olduser.County = user.County;
//olduser.Street = user.Street;
//olduser.Mobile = user.Mobile;
//olduser.Qq = user.Qq;
//SysUser olduser = SysUserAccessor.Instance.Get(userid, string.Empty, string.Empty, StateType.Ignore);
//if (olduser.UserAccount != user.UserAccount)
//{
// AdvancedResult<bool> dr = CheckAccout(user.UserAccount);
// if (dr.Data)
// {
// result.Error = AppError.ERROR_PERSON_FOUND;
// return result;
// }
//}
//olduser.UserAccount = user.UserAccount;
//olduser.Pwd = user.Pwd;
//olduser.Province = user.Province;
//olduser.City = user.City;
//olduser.County = user.County;
//olduser.Street = user.Street;
//olduser.Mobile = user.Mobile;
//olduser.Qq = user.Qq;
SysUserAccessor.Instance.Update(olduser);
result.Error = AppError.ERROR_SUCCESS;
}
else
{
result.Error = AppError.ERROR_FAILED;
}
}
}
catch (Exception e)
{
result.Error = AppError.ERROR_FAILED;
result.ExMessage = e.ToString();
}
Res.Data = result;
Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(Res);
}
private void simpleButtonOk_Click(object sender, EventArgs e)
{
_sysUser = new SysUser();
_sysPackage = new SysPackage();
_sysConfig = new SysConfig();
if (dxErrorProviderMain.HasErrors)
{
XtraMessageBox.Show("Vui lòng cung cấp đủ thông tin yêu cầu");
return;
}
if (textEditPassword.Text != _sysUser.maskPwd)
{
pwd = Security.EnCode(textEditPassword.Text);
}
if (!_sysUser.CheckLogin(textEditUser.Text, pwd))
{
XtraMessageBox.Show("Thông tin đăng nhập chưa chính xác, vui lòng kiểm tra lại!");
return;
}
drUser = _sysUser.DrUser;
DataTable dt1 = _sysPackage.GetPackageForUser(_sysUser);
if (dt1 == null)
{
return;
}
if (dt1.Rows.Count == 0)
{
XtraMessageBox.Show("Người dùng này chưa được phân quyền sử dụng gói phần mềm nào!");
return;
}
//dang nhap thanh cong
Config.NewKeyValue("StructServer", _sysPackage.StructServer);
lookUpEditPackage.Properties.DataSource = dt1;
lookUpEditPackage.Properties.DisplayMember = radioGroupLanguage.SelectedIndex == 0 ? "PackageName" : "PackageName2";
lookUpEditPackage.Properties.ValueMember = "sysDBID";
if (dt1.Rows.Count == 1)
{
drPackage = dt1.Rows[0];
lookUpEditPackage.EditValue = dt1.Rows[0]["sysDBID"];
Config.NewKeyValue("Admin", bool.Parse(dt1.Rows[0]["isAdmin"].ToString()));
Config.NewKeyValue("sysUserPackageID", dt1.Rows[0]["sysUserPackageID"]);
if (_sysConfig.DsStartConfig == null || _sysConfig.DsStartConfig.Tables[0].Rows.Count == 0)
{
DangNhap();
}
else
{
simpleButtonLogin_Click(simpleButtonLogin, new EventArgs());
//this.Height = 300;
//layoutControl2.Visible = true;
////layoutControlItemLogin.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
//layoutControlItemStartConfig.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
//layoutControlItemPackage.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
}
}
else
{
// this.Height = 340;
//layoutControl2.Size = new System.Drawing.Size(583, 40);
simpleButtonLogin.Visible = true;
lookUpEditPackage.Visible = true;
// layoutControl2.Visible = true;
lc1.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lc2.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lookUpEditPackage.Focus();
//layoutControlItemStartConfig.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
//layoutControlItemPackage.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
}
}
public ActionResult Index(T_XSDModels evalModel)
{
SysUser UserModel = Session["UserModel"] as SysUser;
try
{
ViewData["shUserId"] = UserModel.UserId;
evalModel.currentPage = int.Parse(Request["pageNum"].ToString());
}
catch { }
string order = "";
try
{
order = Request["orderField"].ToString();
}
catch { }
if (order.Trim() == "${param.orderField}")
{
order = "";
}
int pagesize = Convert.ToInt32(evalModel.pageSize);
int pagecount = Convert.ToInt32(evalModel.pagecount);
int currentPage = Convert.ToInt32(evalModel.currentPage);
evalModel.DataModel = evalModel.DataModel ?? new T_XSD();
string strCUSQY = "请选择";
if (Request["strXSDH"] != null)
{
string str = Request["strXSDH"].ToString();
if (!String.IsNullOrEmpty(str))
{
evalModel.DataModel.XSDH = str;
}
}
if (Request["strXSDMC"] != null)
{
string str = Request["strXSDMC"].ToString();
if (!String.IsNullOrEmpty(str))
{
evalModel.DataModel.XSMC = str;
}
}
if (Request["strCUSQY"] != null)
{
strCUSQY = Request["strCUSQY"].ToString();
if (!String.IsNullOrEmpty(strCUSQY))
{
evalModel.DataModel.KHID = Convert.ToInt16(strCUSQY);
}
}
var strXSPerson = "";
if (Request["strXSPerson"] != null)
{
strXSPerson = Request["strXSPerson"].ToString();
if (!String.IsNullOrEmpty(strXSPerson))
{
evalModel.DataModel.XSRY = strXSPerson;
}
}
ViewData["strXSPerson"] = strXSPerson;
var cpId = 0;
if (Request["strXSCPMC"] != null)
{
string str = Request["strXSCPMC"].ToString();
if (!String.IsNullOrEmpty(str))
{
cpId = Convert.ToInt32(str);
}
ViewData["strXSCPMC"] = str;
}
var cusId = 0;
if (Request["strXSCusQY"] != null)
{
string str = Request["strXSCusQY"].ToString();
if (!String.IsNullOrEmpty(str))
{
cusId = Convert.ToInt32(str);
}
ViewData["strXSCusQY"] = str;
}
//购货企业列表
T_CusQY cusqy = new T_CusQY();
ViewBag.CUSQY = new SelectList(T_CusQYDomain.GetInstance().GetAllT_CusQY(cusqy).Where(p => p.CusStatus == 1).ToList(), "CusID", "CusMC");
ViewData["strCUSQY"] = strCUSQY;
//获取本企业下的人员列表
T_Person person = new T_Person();
person.PsQYID = (int)UserModel.UserCompanyID;
ViewBag.Persons = new SelectList(T_PersonDomain.GetInstance().GetAllT_Person(person), "PsMZ", "PsMZ");
T_SupQYModels supmode = new T_SupQYModels();
supmode.DataModel = supmode.DataModel ?? new T_SupQY();
supmode.DataList = T_SupQYDomain.GetInstance().GetAllT_SupQY(supmode.DataModel).Where(p => p.SupStatus == 1).ToList();
ViewData["SupQYList"] = new SelectList(supmode.DataList, "SupID", "SupMC");
T_YLCPModels ylcpQymode = new T_YLCPModels();
ylcpQymode.DataModel = ylcpQymode.DataModel ?? new T_YLCP();
ylcpQymode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpQymode.DataModel).Where(p => p.CPStatus == 1).ToList();
ViewData["YLCP"] = new SelectList(ylcpQymode.DataList, "CPID", "CPMC");
evalModel.DataList = T_XSDDomain.GetInstance().PageT_XSD(evalModel.DataModel, evalModel.StartTime, evalModel.EndTime, currentPage, pagesize, cpId, cusId, out pagecount, out resultCount);
evalModel.resultCount = resultCount;
return(View("~/Views/T_XSD/Index.cshtml", evalModel));
}
protected void btnADD_Click(object sender, EventArgs e)
{
string sqlchkMajor = "Select * From MAJOR Where MAJORCODE='" + ddlMajor.SelectedValue + "'";
List <TQF.Major> chkMajor = new TQF.Major().getMajorManual(sqlchkMajor);
if (chkMajor.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('แขนงวิชาซ้ำ!');", true);
//เรียกข้อมูลอาจารย์ขึ้นมาใหม่เมื่อเวลาเก็บข้อมูลลงไปแล้วไม่สามารถนำกลับมาใช้ได้อีก
List <SysUser> sysUser = new SysUser().getSysUser();
ddlLecturer.Items.Clear();
foreach (SysUser rowUser in sysUser)
{
string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + rowUser.IdCode + "'";
List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql);
//เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง
if (aboutLecturer.Count > 0)
{
continue;
}
else
{
ddlLecturer.Items.Insert(ddlLecturer.Items.Count, new ListItem(rowUser.ThName + " " + rowUser.ThSurName + " (" + rowUser.ShortName + ")", rowUser.IdCode));
}
}
}
else
{
TableRow row = new TableRow();
//Cell [0]
TableCell cellSpecialField_Thai = new TableCell();
cellSpecialField_Thai.Text = new SpecialField().getSpecialField(ddlMajor.SelectedValue).SpecialField_Thai;
row.Cells.Add(cellSpecialField_Thai);
//Cell [1]
TableCell cellSpecialField_Eng = new TableCell();
cellSpecialField_Eng.Text = new SpecialField().getSpecialField(ddlMajor.SelectedValue).SpecialField_Eng;
row.Cells.Add(cellSpecialField_Eng);
//Cell [2]
TableCell cellAboutLecturer = new TableCell();
foreach (ListItem li in ddlLecturer.Items)
{
if (li.Selected)
{
int sequence = int.Parse(new TQF.TQFUtility().getMaxID("SEQUENCE", "ABOUTLECTURER"));
cellAboutLecturer.Text += li.Text + "<br>";
AboutLecturer aboutlecturer = new AboutLecturer();
aboutlecturer.CurrCode = CurrCode;
aboutlecturer.YearVersion = YearVersion;
aboutlecturer.LectIdentity = li.Value;
aboutlecturer.LoadTypeCode = "4"; //4 = อาจารย์ประจำแขนง (ข้อมูลจากตาราง LoadType)
aboutlecturer.Sequence = sequence.ToString();
aboutlecturer.MajorCode = ddlMajor.SelectedValue;
//add อาจารย์ลงตาราง AboutLecturer
string insertAboutlecturer = new AboutLecturer().insertAboutLecturer(aboutlecturer);
}
}
row.Cells.Add(cellAboutLecturer);
//เก็บข้อมูลแขนงวิชาลงตาราง Major
TQF.Major major = new TQF.Major();
major.MajorCode = ddlMajor.SelectedValue;
major.MajorThName = new SpecialField().getSpecialField(ddlMajor.SelectedValue).SpecialField_Thai;
major.MajorEnName = new SpecialField().getSpecialField(ddlMajor.SelectedValue).SpecialField_Eng;
major.CurrCode = CurrCode;
major.YearVersion = YearVersion;
string insertMajor = new TQF.Major().insertMajor(major);
//Cell [3]
TableCell cellDel = new TableCell();
string urlDel = "deleteMAJOR.aspx?CurrCode=" + major.CurrCode + "&YearVersion=" + major.YearVersion + "&MajorCode=" + major.MajorCode;
HyperLink hypDel = new HyperLink();
hypDel.Attributes.Add("data-target", "#deleteMAJOR");
hypDel.Attributes.Add("data-toggle", "modal");
hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>";
hypDel.NavigateUrl = urlDel;
hypDel.ToolTip = "Delete";
cellDel.Controls.Add(hypDel);
cellDel.CssClass = "text-center";
cellDel.Width = 50;
row.Cells.Add(cellDel);
tblMajor.Rows.Add(row);
//เคลียร์ค่า selection คอนโทรล ddlMajor
ddlMajor.ClearSelection();
//เรียกข้อมูลอาจารย์ขึ้นมาใหม่เมื่อเวลาเก็บข้อมูลลงไปแล้วไม่สามารถนำกลับมาใช้ได้อีก
List <SysUser> sysUser = new SysUser().getSysUser();
ddlLecturer.Items.Clear();
foreach (SysUser rowUser in sysUser)
{
string sql = "Select * From ABOUTLECTURER Where LECTIDENTITY='" + rowUser.IdCode + "'";
List <AboutLecturer> aboutLecturer = new AboutLecturer().getAboutLecturerManual(sql);
//เช็คว่าอาจารย์ประจำหลักสูตรไปแล้วหรือยัง
if (aboutLecturer.Count > 0)
{
continue;
}
else
{
ddlLecturer.Items.Insert(ddlLecturer.Items.Count, new ListItem(rowUser.ThName + " " + rowUser.ThSurName + " (" + rowUser.ShortName + ")", rowUser.IdCode));
}
}
}//end else
}
/// <summary>
/// 验证用户注册
/// </summary>
/// <param name="dto">用户注册信息</param>
/// <param name="validateCode">验证码</param>
/// <returns>业务操作结果</returns>
public async Task<OperationResult> ValidateRegister(UserInfoRegistDto dto, string validateCode)
{
dto.CheckNotNull("dto");
validateCode.CheckNotNullOrEmpty("validateCode");
//验证码
var severCode = GetValidateCode(dto.UserName, CodeType.用户注册);
if (severCode == null || severCode.Code != validateCode)
{
return new OperationResult(OperationResultType.ValidError, "验证码错误", 0);
}
if (SysUserRepo.CheckExists(p => p.UserName == dto.UserName))
{
return new OperationResult(OperationResultType.ValidError, "账号已被使用", 0);
}
try
{
UserInfoRepo.UnitOfWork.TransactionEnabled = true;
//验证密码格式
IdentityResult result = await UserManager.PasswordValidator.ValidateAsync(dto.Password);
if (!result.Succeeded) return result.ToOperationResult();
SysUser sUser = new SysUser()
{
UserName = dto.UserName,
NickName = dto.NickName,
PasswordHash = UserManager.PasswordHasher.HashPassword(dto.Password),//密码加密
UserType = UserType.App用户
};
if (severCode.ValidateType == ValidateType.手机)
{
sUser.PhoneNumber = dto.UserName;
sUser.PhoneNumberConfirmed = true;
}
else
{
sUser.Email = dto.UserName;
sUser.EmailConfirmed = true;
}
await UserManager.CreateAsync(sUser);
var userInfo = Mapper.Map<UserInfo>(dto);
userInfo.SysUser = sUser;
await UserInfoRepo.InsertAsync(userInfo);
await UserInfoRepo.UnitOfWork.SaveChangesAsync();
return new OperationResult(OperationResultType.Success, "注册成功", userInfo.Id);
}
catch
{
return new OperationResult(OperationResultType.NoChanged, "注册失败", 0);
}
}
/// <summary>
/// 员工注册
/// </summary>
/// <param name="account">员工账号是邮箱格式</param>
/// <param name="pwd"></param>
/// <returns></returns>
public JsonResult UserRegister(string username, string account, string pwd, string entCode)
{
var Res = new JsonResult();
AdvancedResult <string> result = new AdvancedResult <string>();
try
{
AdvancedResult <bool> dr = CheckUserAccout(account);
if (dr.Data)
{
result.Error = AppError.ERROR_PERSON_FOUND;
Res.Data = result;
Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(Res);
}
SysUser entUser = new SysUser();
SysUser user = new SysUser();
if (!string.IsNullOrEmpty(entCode))
{
entUser = SysUserAccessor.Instance.GetEntUserByEntCode(entCode.ToUpper().Trim());
if (entUser != null)
{
user.EntId = entUser.EntId;
user.EntCode = entCode.ToUpper();
}
else
{
result.Error = AppError.ERROR_FAILED;
Res.Data = result;
Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(Res);
}
}
user.UserAccount = account;
user.UserName = username;
user.Pwd = SecurityHelper.MD5(pwd);
user.Email = account;
user.CreateTime = DateTime.Now;
user.EndTime = DateTime.Now.AddDays(90);
user.IsEnable = 1;
user.Type = 1;
int i = SysUserAccessor.Instance.Insert(user);
if (i > 0)
{
string token = SecurityHelper.GetToken(i.ToString());
CacheManagerFactory.GetMemoryManager().Set(token, i.ToString());
result.Error = AppError.ERROR_SUCCESS;
result.Data = token;
WriteAuthCookie(user.UserName, token);
AddUserTimeMachine(i, 1, 0);
}
}
catch (Exception e)
{
result.Error = AppError.ERROR_FAILED;
result.ExMessage = e.ToString();
}
Res.Data = result;
Res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(Res);
}
public Boolean Delete(SysUser data)
{
return(base.Delete(data));
}
private void createCreditTable2()
{
available_data = (AvailableCourseData)Session["save_data"];
CourseData course_data = new Course().getCourse(available_data.Course_Code);
tblSubCredit.Rows.Clear();
// แบ่งโหลด
string[] ar5 = { "ชื่ออาจารย์", "ภาระงานสอน ชั่วโมง/หน่วยกิต", "ชั่วโมงสอนอ้างอิง", "หน่วยกิตรวม", "แบ่งหน่วยกิต" };
Table tb5 = new Table();
tb5.Attributes.Add("class", "table table-bordered table-striped");
tb5.Attributes.Add("id", "dt_basic5");
TableHeaderRow tRowHead5 = new TableHeaderRow();
tRowHead5.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar5.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead5 = new TableHeaderCell();
cellHead5.Text = ar5[cellCtr - 1];
cellHead5.Attributes.Add("class", "text-align-center");
tRowHead5.Cells.Add(cellHead5);
}
tb5.Rows.Add(tRowHead5);
int i = 0;
List <LecturerTableData> new_lecturertable = new List <LecturerTableData>();
//List<LecturerTableData> tmp = new List<LecturerTableData>();
new_lecturertable = lecturertable.OrderBy(o => o.Lecturer).ToList();
//string lec_code = "";
//foreach (LecturerTableData lect_data in tmp)
// {
// if (lect_data.Lecturer != lec_code)
// {
// new_lecturertable.Add(lect_data);
// }
// lec_code = lect_data.Lecturer;
// }
foreach (LecturerTableData lect_data in new_lecturertable)
{
subcreditData = (List <SubCreditData>)Session["subCredit"];
SysUser user1 = new SysUser();
user1 = new SysUser().getSysUser(lect_data.Lecturer);
Sysuser2 user2 = new Sysuser2();
user2 = new Sysuser2().getSysuser2(lect_data.Lecturer);
TableRow tRowBody5 = new TableRow();
tRowBody5.TableSection = TableRowSection.TableBody;
TableCell cellLecName = new TableCell();
cellLecName.Text = lecturerObj.getLecturer(lect_data.Lecturer).First_ThaiName + " " + lecturerObj.getLecturer(lect_data.Lecturer).Family_ThaiName;
tRowBody5.Cells.Add(cellLecName);
WorkLoadConfigData workload = new WorkLoadConfigData();
workload = new WorkLoadConfig().getWorkLoadConfig(user2.Lecturer_Type, user1.Position);
TableCell cellLoad = new TableCell();
cellLoad.Text = workload.HourReference.ToString() + " / " + workload.TotalCredit.ToString();
cellLoad.Attributes.Add("class", "text-align-center");
tRowBody5.Cells.Add(cellLoad);
TableCell cellHourRef = new TableCell();
cellHourRef.Text = new WorkLoadCalculate().getHourRef(lect_data.AcademicYear, lect_data.Semester, lect_data.Lecturer).ToString();
cellHourRef.Attributes.Add("class", "text-align-center");
tRowBody5.Cells.Add(cellHourRef);
TableCell cellTotalCredit = new TableCell();
cellTotalCredit.Text = new WorkLoadCalculate().getTotalCredit(lect_data.AcademicYear, lect_data.Semester, lect_data.Lecturer).ToString();
cellTotalCredit.Attributes.Add("class", "text-align-center");
tRowBody5.Cells.Add(cellTotalCredit);
int credit = course_data.Credit;
if (lect_data.Course_Type == "1")
{
if (course_data.Practice != 0)
{
credit = course_data.Theory;
}
else
{
credit = course_data.Credit;
}
}
else if (lect_data.Course_Type == "2")
{
if (course_data.Theory != 0)
{
credit = course_data.Practice / 2;
}
else
{
credit = course_data.Credit;
}
}
TableCell cellSubCredit = new TableCell();
txtSubCredit = new TextBox[new_lecturertable.Count];
txtSubCredit[i] = new TextBox();
txtSubCredit[i].ID = lect_data.Lecturer + lect_data.Teaching_Day + lect_data.Teaching_Start_Time.Replace(":", "").Replace(".", "") + lect_data.Teaching_End_Time.Replace(":", "").Replace(".", "");
txtSubCredit[i].MaxLength = 5;
txtSubCredit[i].Width = 50;
txtSubCredit[i].AutoPostBack = true;
txtSubCredit[i].Text = subcreditData[i].ToString();
txtSubCredit[i].Attributes.Add("class", "text-align-center");
txtSubCredit[i].TextChanged += new EventHandler(txtChanged);
cellSubCredit.Attributes.Add("class", "text-align-center");
cellSubCredit.Controls.Add(txtSubCredit[i]);
tRowBody5.Cells.Add(cellSubCredit);
tb5.Rows.Add(tRowBody5);
i++;
}
TableRow row5 = new TableRow();
TableCell cell5 = new TableCell();
cell5.Controls.Add(tb5);
row5.Cells.Add(cell5);
tblSubCredit.Rows.Add(row5);
}
public SysUser SelectById(SysUser data)
{
return((SysUser)base.SelectById(data));
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from SysUser a where ");
SysUser user = (SysUser)data;
if (user != null)
{
Parms = new List <Object[]>();
if (user.UserID != 0)
{
sql.Append(" a.UserID = :usr and ");
Parms.Add(new Object[] { "usr", user.UserID });
}
if (!String.IsNullOrEmpty(user.UserName))
{
sql.Append(" Lower(a.UserName) = :nom and ");
Parms.Add(new Object[] { "nom", user.UserName.ToLower() });
}
if (!String.IsNullOrEmpty(user.Password))
{
sql.Append(" a.Password = :nom1 and ");
Parms.Add(new Object[] { "nom1", user.Password });
}
if (!String.IsNullOrEmpty(user.FirstName))
{
sql.Append(" a.FirstName = :nom2 and ");
Parms.Add(new Object[] { "nom2", user.FirstName });
}
if (!String.IsNullOrEmpty(user.LastName))
{
sql.Append(" a.LastName = :nom3 and ");
Parms.Add(new Object[] { "nom3", user.LastName });
}
if (!String.IsNullOrEmpty(user.Phone))
{
sql.Append(" a.Phone = :nom4 and ");
Parms.Add(new Object[] { "nom4", user.Phone });
}
if (!String.IsNullOrEmpty(user.Email))
{
sql.Append(" a.Email = :nom5 and ");
Parms.Add(new Object[] { "nom5", user.Email });
}
if (user.IsSuperUser == true)
{
sql.Append(" a.IsSuperUser = :nom7 and ");
Parms.Add(new Object[] { "nom7", true });
}
else if (user.IsSuperUser == false)
{
sql.Append(" a.IsSuperUser = :nom8 and ");
Parms.Add(new Object[] { "nom8", false });
}
if (!String.IsNullOrEmpty(user.LastSession))
{
sql.Append(" a.LastSession = :n4 and ");
Parms.Add(new Object[] { "n4", user.LastSession });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.UserID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public async Task <AccountValidationVM> LoginValidation(SysUser mo, string captcha, int remember)
{
var result = new AccountValidationVM();
var outMo = new SysUser();
//跳过验证码
if (captcha == "_pass_")
{
outMo = mo;
}
else
{
var capt = HttpContext.Session.GetString("captcha");
if (string.IsNullOrWhiteSpace(captcha) || (capt ?? "") != Core.CalcTo.MD5(captcha.ToLower()))
{
result.code = 104;
result.message = "验证码错误或已过期";
return(result);
}
if (string.IsNullOrWhiteSpace(mo.SuName) || string.IsNullOrWhiteSpace(mo.SuPwd))
{
result.code = 101;
result.message = "用户名或密码不能为空";
return(result);
}
outMo = db.SysUser.Where(x => x.SuName == mo.SuName && x.SuPwd == Core.CalcTo.MD5(mo.SuPwd, 32)).FirstOrDefault();
}
if (outMo == null || string.IsNullOrWhiteSpace(outMo.SuId))
{
result.code = 102;
result.message = "用户名或密码错误";
return(result);
}
if (outMo.SuStatus != 1)
{
result.code = 103;
result.message = "用户已被禁止登录";
return(result);
}
try
{
#region 授权访问信息
//登录信息
var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme);
identity.AddClaim(new Claim(ClaimTypes.PrimarySid, outMo.SuId));
identity.AddClaim(new Claim(ClaimTypes.Name, outMo.SuName));
identity.AddClaim(new Claim(ClaimTypes.GivenName, outMo.SuNickname ?? ""));
identity.AddClaim(new Claim(ClaimTypes.Role, outMo.SrId));
//配置
var authParam = new AuthenticationProperties();
if (remember == 1)
{
authParam.IsPersistent = true;
authParam.ExpiresUtc = DateTime.Now.AddDays(10);
}
//写入
await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(identity), authParam);
result.code = 100;
result.message = "登录成功";
result.url = "/";
return(result);
#endregion
}
catch (Exception ex)
{
result.code = 105;
result.message = "处理登录请求出错（" + ex.Message + "）";
return(result);
}
}
public SysUser Save(SysUser data)
{
return((SysUser)base.Save(data));
}
public FrmUserEdit(DBOperateType type, SysUser user)
{
InitializeComponent();
Type = type;
User = user;
}
public void Update(string PkSuid,string FpSBranchID,string SPwd,string SFullName,string SDepart,DateTime? TDateCreated,short? ISecurityLevel,string SDesc,string DelegateUser)
{
SysUser item = new SysUser();
item.MarkOld();
item.IsLoaded = true;
item.PkSuid = PkSuid;
item.FpSBranchID = FpSBranchID;
item.SPwd = SPwd;
item.SFullName = SFullName;
item.SDepart = SDepart;
item.TDateCreated = TDateCreated;
item.ISecurityLevel = ISecurityLevel;
item.SDesc = SDesc;
item.DelegateUser = DelegateUser;
item.Save(UserName);
}
public Boolean Update(SysUser data)
{
return(base.Update(data));
}
