public AscmUserInfo(AscmUserInfo ascmUserInfo) { this.departmentId = ascmUserInfo.departmentId; //this.departmentPositionList = ascmUserInfo.departmentPositionList; this.description = ascmUserInfo.description; this.email = ascmUserInfo.email; this.employeeId = ascmUserInfo.employeeId; this.extExpandId = ascmUserInfo.extExpandId; this.extExpandType = ascmUserInfo.extExpandType; this.firstSpell = ascmUserInfo.firstSpell; this.id = ascmUserInfo.id; this.isAccountLocked = ascmUserInfo.isAccountLocked; this.lastLoginDate = ascmUserInfo.lastLoginDate; this.lastLoginIp = ascmUserInfo.lastLoginIp; this.mobilePhone = ascmUserInfo.mobilePhone; this.mobileTel = ascmUserInfo.mobileTel; this.officePhone = ascmUserInfo.officePhone; this.officeTel = ascmUserInfo.officeTel; this.organizationId = ascmUserInfo.organizationId; this.password = ascmUserInfo.password; this.roleId = ascmUserInfo.roleId; //this.roleList = ascmUserInfo.roleList; this.select = ascmUserInfo.select; this.sex = ascmUserInfo.sex; this.sign = ascmUserInfo.sign; this.siteAdmin = ascmUserInfo.siteAdmin; this.sortNo = ascmUserInfo.sortNo; this.spell = ascmUserInfo.spell; //this.supplierId = ascmUserInfo.supplierId; //this.supplierName = ascmUserInfo.supplierName; this.userId = ascmUserInfo.userId; this.userName = ascmUserInfo.userName; this.userName1 = ascmUserInfo.userName1; //this.userName2 = ascmUserInfo.userName2; //this.ynUnit = ascmUserInfo.ynUnit; this.logisticsClass = ascmUserInfo.logisticsClass; }
public ContentResult SetLogisticsYnUserClass(string id, AscmUserInfo ascmUserInfo_Model) { JsonObjectResult jsonObjectResult = new JsonObjectResult(); try { string userName = string.Empty; if (User.Identity.IsAuthenticated) { userName = User.Identity.Name; } AscmUserInfo ascmUserInfo = null; if (!string.IsNullOrEmpty(id)) { ascmUserInfo = AscmUserInfoService.GetInstance().Get(id); if (!string.IsNullOrEmpty(ascmUserInfo_Model.logisticsClass)) ascmUserInfo.logisticsClass = ascmUserInfo_Model.logisticsClass; AscmUserInfoService.GetInstance().Update(ascmUserInfo); } jsonObjectResult.result = true; jsonObjectResult.message = ""; jsonObjectResult.id = ascmUserInfo.userId; jsonObjectResult.entity = ascmUserInfo; } catch (Exception ex) { jsonObjectResult.result = false; jsonObjectResult.message = ex.Message; } string sReturn = JsonConvert.SerializeObject(jsonObjectResult); return Content(sReturn); }
public void Update(AscmUserInfo ascmUserInfo) { using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { YnDaoHelper.GetInstance().nHibernateHelper.Update<AscmUserInfo>(ascmUserInfo); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmUserInfo)", ex); throw ex; } } }
public void SetSupplier(AscmUserInfo ascmUserInfo) { if (ascmUserInfo != null ) { //string sql = "from AscmSupplier where id in (select numberValue from AscmAkWebUserSecAttrValues where attributeCode='" + MideaAscm.Dal.FromErp.Entities.AscmAkWebUserSecAttrValues.AttributeCodeDefine.supplierUser + "' and id=" + ascmUserInfo.extExpandId + ")"; string sql = "from AscmSupplier where id in (select numberValue from AscmAkWebUserSecAttrValues where attributeCode='" + MideaAscm.Dal.FromErp.Entities.AscmAkWebUserSecAttrValues.AttributeCodeDefine.supplierUser + "' and webUserId=" + ascmUserInfo.extExpandId + ")"; //sql = "from AscmEmployee where id in (" + sql + ")"; IList<AscmSupplier> ilistAscmSupplier = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmSupplier>(sql); if (ilistAscmSupplier != null && ilistAscmSupplier.Count > 0) { ascmUserInfo.ascmSupplier = ilistAscmSupplier[0]; } } }
/// <summary>手持登录</summary> public AscmUserInfo MobileLogin(string userId, string userPwd, string connString, ref string errorMsg) { AscmUserInfo ascmUserInfo = null; errorMsg = string.Empty; using (Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(connString)) { if (conn.State != System.Data.ConnectionState.Open) conn.Open(); Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(); cmd.Connection = conn; cmd.CommandText = "SELECT userId,userName,password,employeeId,extExpandType,extExpandId FROM ynUser WHERE extExpandId = :extExpandId"; cmd.CommandType = System.Data.CommandType.Text; Oracle.DataAccess.Client.OracleParameter parm = new Oracle.DataAccess.Client.OracleParameter(); parm.ParameterName = ":extExpandId"; parm.OracleDbType = Oracle.DataAccess.Client.OracleDbType.NVarchar2; parm.Size = 20; parm.Value = userId; parm.Direction = System.Data.ParameterDirection.Input; cmd.Parameters.Add(parm); using (Oracle.DataAccess.Client.OracleDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)) { cmd.Parameters.Clear(); if (reader.Read()) { ascmUserInfo = new AscmUserInfo(); ascmUserInfo.userId = reader["userId"].ToString(); ascmUserInfo.userName = reader["userName"].ToString(); ascmUserInfo.password = reader["password"].ToString(); int employeeId = 0; int.TryParse(reader["employeeId"].ToString(), out employeeId); ascmUserInfo.employeeId = employeeId; ascmUserInfo.extExpandType = reader["extExpandType"].ToString(); ascmUserInfo.extExpandId = reader["extExpandId"].ToString(); if (ascmUserInfo.extExpandType == "erp") { byte[] result = Encoding.Default.GetBytes(userPwd); System.Security.Cryptography.MD5 md5 = new System.Security.Cryptography.MD5CryptoServiceProvider(); userPwd = BitConverter.ToString(md5.ComputeHash(result)).Replace("-", ""); if (ascmUserInfo.password != userPwd) { errorMsg = "密码不正确"; } else if (!string.IsNullOrEmpty(ascmUserInfo.userName)) { Oracle.DataAccess.Client.OracleCommand cmd2 = new Oracle.DataAccess.Client.OracleCommand(); cmd2.Connection = conn; cmd2.CommandText = "SELECT id,name FROM ascm_supplier WHERE docNumber = :docNumber"; cmd2.CommandType = System.Data.CommandType.Text; cmd2.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter { ParameterName = ":docNumber", OracleDbType = Oracle.DataAccess.Client.OracleDbType.NVarchar2, Size = 20, Value = ascmUserInfo.userName, Direction = System.Data.ParameterDirection.Input }); using (Oracle.DataAccess.Client.OracleDataReader reader2 = cmd2.ExecuteReader(System.Data.CommandBehavior.CloseConnection)) { cmd2.Parameters.Clear(); if (reader2.Read()) { int id = 0; if (int.TryParse(reader2["id"].ToString(), out id)) { AscmSupplier ascmSupplier = new AscmSupplier(); ascmSupplier.id = id; ascmSupplier.name = reader2["name"].ToString(); ascmUserInfo.ascmSupplier = ascmSupplier; } } } } } } } } return ascmUserInfo; }