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