/// <summary> /// 设置角色成员 /// </summary> /// <param name="roleid">角色id</param> /// <param name="loginnameStr">成员登录名字符串,以逗号连接</param> /// <returns>返回 影响行数</returns> public JsonModel SetRoleMember(string roleid, string loginnameStr) { //定义JSON标准格式实体中 JsonModel jsonModel = new JsonModel(); try { //事务 using (SqlTransaction trans = dal.GetTran()) { try { string[] nameArray = loginnameStr.Split(','); int count = 0, result = 0; foreach (string name in nameArray) { EmsModel.RoleOfUser ru = new EmsModel.RoleOfUser(); ru.RoleId = Convert.ToInt32(roleid); ru.LoginName = name; result = dal.Add(trans, ru); if (result > 0) { count++; } } if (nameArray.Length != count) { trans.Rollback();//回滚 jsonModel.Status = "no"; jsonModel.Msg = "保存失败"; return(jsonModel); } else { trans.Commit();//提交 } } catch (Exception) { trans.Rollback();//回滚 throw; } } jsonModel.Status = "ok"; jsonModel.Msg = "操作成功"; return(jsonModel); } catch (Exception ex) { jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }
/// <summary> /// 删除关系数据, 删单条 /// </summary> /// <returns>返回 影响行数</returns> public int DeleteUserRelation(EmsModel.RoleOfUser roleu) { int count = dal.DeleteUserRelation(roleu); return(count); }
/// <summary> /// 读取Excel导入数据--教师 /// </summary> /// <param name="ht">参数</param> /// <returns></returns> public JsonModel ImportTeacher(Hashtable ht) { try { BLLCommon common = new BLLCommon(); DataTable dt = common.ExcelToDataTable(ht["FilePath"].ToString()); EmsDAL.RoleOfUser DALRoleOfUser = new EmsDAL.RoleOfUser(); int Yse = 0; //新增条数 int No = 0; //失败条数 int Update = 0; //更新条数 int NoUpdate = 0; //存在相同数据条数 StringBuilder sb = new StringBuilder(); StringBuilder sbUp = new StringBuilder(); StringBuilder sbNoUp = new StringBuilder(); string isUpdate = System.Configuration.ConfigurationManager.AppSettings["ExportTeacherOperator"]; string[] RoleIds = ht["RoleId"].ToString().Split(','); if (string.IsNullOrWhiteSpace(ht["RoleId"].ToString())) { RoleIds = new string[0]; } for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; try { if (string.IsNullOrWhiteSpace(dr["身份证号"].ToString().Trim()) && string.IsNullOrWhiteSpace(dr["教师名"].ToString().Trim()) && string.IsNullOrWhiteSpace(dr["教师号"].ToString().Trim())) { continue; } EmsModel.UserInfo model = new EmsModel.UserInfo(); List <EmsModel.RoleOfUser> ListRoleOfUser = new List <EmsModel.RoleOfUser>(); foreach (string RoleId in RoleIds) { EmsModel.RoleOfUser ModelRoleOfUser = new EmsModel.RoleOfUser(); ModelRoleOfUser.LoginName = dr["教师号"].ToString().Trim(); //登录名 ModelRoleOfUser.RoleId = Convert.ToInt32(RoleId); //权限ID ListRoleOfUser.Add(ModelRoleOfUser); } Hashtable htCunZai = new Hashtable(); htCunZai.Add("IDCard", dr["身份证号"].ToString().Trim()); bool CunZai = dal.IsExists(htCunZai); int Id = 0; if (CunZai) { if (isUpdate.ToUpper() != "OFF") { model = dal.GetEmsModel(htCunZai); model.LoginName = dr["教师号"].ToString().Trim(); //登录名 model.Name = dr["教师名"].ToString().Trim(); //用户名 //model.PassWord = Md5Encrypting(ht["Password"].ToString());//密码 //model.Creator = ht["Creator"].ToString();//创建人 //model.CreateTime = DateTime.Now;//创建时间 model.Editor = ht["Creator"].ToString(); //创建人 model.UpdateTime = DateTime.Now; //创建时间 model.IsDelete = 0; //是否删除 model.Sex = dr["性别"].ToString().Trim(); //性别 //model.KaNo = "";//卡号 //model.KaLv = "";//卡等级 //model.UseStatus = Convert.ToByte(ht["UseStatus"].ToString());//使用状态 //model.IDCard = dr["身份证号"].ToString().Trim();//身份证号 Id = dal.Update(model); Update++; sbUp.Append((i + 1).ToString() + ","); } else { NoUpdate++; sbNoUp.Append((i + 1).ToString() + ","); } } else { model.LoginName = dr["教师号"].ToString().Trim(); //登录名 model.Name = dr["教师名"].ToString().Trim(); //用户名 model.PassWord = common.Md5Encrypting(ht["Password"].ToString()); //密码 model.Creator = ht["Creator"].ToString(); //创建人 model.CreateTime = DateTime.Now; //创建时间 model.IsDelete = 0; //是否删除 model.Sex = dr["性别"].ToString().Trim(); //性别 model.KaNo = ""; //卡号 model.KaLv = ""; //卡等级 model.UseStatus = Convert.ToByte(ht["UseStatus"].ToString()); //使用状态 model.IDCard = dr["身份证号"].ToString().Trim(); //身份证号 #region 事物添加教师账号、账号权限 //事务 using (SqlTransaction trans = dal.GetTran()) { Id = dal.Add(trans, model); if (Id > 0) { //添加用户权限 bool RoleOfUserIDBool = true; foreach (EmsModel.RoleOfUser ModelRoleOfUser in ListRoleOfUser) { int ModelRoleOfUserID = DALRoleOfUser.Add(trans, ModelRoleOfUser); if (ModelRoleOfUserID <= 0) { RoleOfUserIDBool = false; break; } } if (RoleOfUserIDBool) { trans.Commit(); Yse++; } else { Id = 0; trans.Rollback(); } } else { Id = 0; trans.Rollback(); } } #endregion } if (Id <= 0) { No++; sb.Append((i + 1).ToString() + ","); } } catch (Exception ex) { //No++; //sb.Append((i + 1).ToString() + ","); JsonModel jsonModels = new JsonModel(); jsonModels.Status = "error"; jsonModels.Msg = ex.ToString(); return(jsonModels); } } JsonModel jsonModel = new JsonModel(); jsonModel.Status = "ok"; //jsonModel.Msg = "成功" + Yse + "条,失败" + No + "条,共" + dt.Rows.Count + "条"; jsonModel.Msg = "成功" + (Yse + Update) + "条,失败" + No + "条"; if (NoUpdate > 0) { jsonModel.Msg += ",已有数据不处理" + NoUpdate + "条"; } if (sb.Length != 0) { jsonModel.Msg += "\n失败数据行号:" + sb.ToString(); } if (sbNoUp.Length != 0) { jsonModel.Msg += "\n不处理数据行号:" + sbNoUp.ToString(); } return(jsonModel); } catch (Exception ex) { JsonModel jsonModel = new JsonModel(); jsonModel.Status = "error"; jsonModel.Msg = ex.ToString(); return(jsonModel); } }