public void add(SJ_DepartStaffModel sj_departstaff)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
//执行新增写进数据库
sj_departstaffDal.add(cn, tc, sj_departstaff);
DbHelperSQL.commitTransaction(tc);
}
catch (Exception dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
IList<QueryModel> qmList = new List<QueryModel>();
qmList.Add(MakeUtil.getQueryModel("DS_UID", "'", SqlWhere.WhereOperator.Equal, this.PrimaryKey));
this.cdModel = bll.getModel(qmList);
if (cdModel == null || this.cdModel.DS_JID == "")
{
Script.alertMsg("找不到人员资料:" + PrimaryKey, this.Page);
Script.closeDivWin(this.Page, "DepartStaffModify" + PrimaryKey);
return;
}
this.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.CdModel = new SJ_DepartStaffModel();
this.DataBind();
}
}
protected string DepartCsvLoad(HttpPostedFile file)
{
try
{
var type = file.ContentType;
if (!type.Contains("excel"))
{
return "请使用csv格式";
}
DataTable dt = new DataTable();
DataRow dr = null;
try
{
StreamReader sr = new StreamReader(file.InputStream, System.Text.Encoding.Default);
string str = sr.ReadToEnd();
sr.Close();
string[] rows = str.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
string[] temp;
temp = rows[0].Split(',');
for (int j = 0; j < temp.Length; j++)
{
dt.Columns.Add(temp[j]);
}
for (int i = 1; i < rows.Length; i++)
{
temp = rows[i].Split(',');
dr = dt.NewRow();
for (int j = 0; j < temp.Length; j++)
{
dr[j] = temp[j];
}
dt.Rows.Add(dr);
}
}
catch
{
return "Csv文件读取失败，请确认Csv文件的格式是否正确！";
}
var sjDepartStaffModels = new List<SJ_DepartStaffModel>();
SJ_DepartStaffModel tempmodel;
if (dt.Columns.Contains("人员编号"))
{
var schoolList = _schoolDataEbi.getModelList(null, -1);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["人员编号"].ToString().Trim().Length > 0)
{
dr = dt.Rows[i];
tempmodel = new SJ_DepartStaffModel();
tempmodel.DS_UID = Guid.NewGuid().ToString();
tempmodel.DS_JID = dr["人员编号"].ToString().Trim();
if (dt.Columns.Contains("班级名称"))
{
tempmodel.D_Name = dr["班级名称"].ToString().Trim();
}
if (dt.Columns.Contains("人员姓名"))
{
tempmodel.DS_Name = dr["人员姓名"].ToString().Trim();
}
if (dt.Columns.Contains("性别"))
{
tempmodel.DS_Sex = dr["性别"].ToString().Trim();
}
if (dt.Columns.Contains("证件号"))
{
tempmodel.DS_DocumentNo = dr["证件号"].ToString().Trim();
}
if (dt.Columns.Contains("手机号"))
{
tempmodel.DS_Tele = dr["手机号"].ToString().Trim();
}
if (dt.Columns.Contains("类别"))
{
tempmodel.DS_Post = dr["类别"].ToString().Trim();
}
if (dt.Columns.Contains("所属学校编号"))
{
tempmodel.SchoolNo = dr["所属学校编号"].ToString().Trim();
}
//判断各项是否为空
if (tempmodel.DS_JID.Length == 0)
{
return "人员编号不能为空";
}
if (tempmodel.DS_Name.Length == 0)
{
return "人员名称不能为空";
}
if (schoolList.Where(p => p.SchoolNo == tempmodel.SchoolNo).Count() <= 0)
{
return "学校编号:" + tempmodel.SchoolNo + "不存在";
}
if (tempmodel.DS_Post != "老师" && tempmodel.DS_Post != "学生")
{
return "类别只能为老师或学生";
}
if (tempmodel.DS_Sex != "男" && tempmodel.DS_Sex != "女")
{
return "性别只能为男或女";
}
sjDepartStaffModels.Add(tempmodel);
}
}
}
bll.add(sjDepartStaffModels);
DbCacheHelper.UpdateCache<StudentParentDto>("StudentParentV");
return "OK";
}
catch (Exception ex)
{
return ex.Message;
}
}
protected void ImageBtnSave_Click(object sender, EventArgs e)
{
this.CdModel = MakeUtil.getRequestDataToModel<SJ_DepartStaffModel>(Request, typeof(SJ_DepartStaffModel), -1);
try
{
if (CdModel.DS_JID == "" || CdModel.DS_Name == "")
{
throw new MakeException(ExpSort.普通, "缺少必要数据");
}
IList<QueryModel> qmList = new List<QueryModel>();
qmList.Add(MakeUtil.getQueryModel("DS_JID", "'", SqlWhere.WhereOperator.Equal, CdModel.DS_JID));
qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, CdModel.SchoolNo));
if (bll.getModelList(qmList, 1).Count > 0)
{
throw new MakeException(ExpSort.普通, "人员信息已存在,新增失败");
}
CdModel.DS_UID = Guid.NewGuid().ToString();
bll.add(CdModel);
MakeUtil.addOperationNote(Request.UserHostAddress, UserId.Value.Trim(), "人员信息新增", cdModel.DS_JID);
Script.alertMsg("新增成功", Page);
Script.scriptRedirect(Request.RawUrl, this.Page);
}
catch (Make.Exp.MakeException mEx)
{
Script.alertMsg(mEx.Message, this.Page);
this.DataBind();
}
}
