private static int Update(Model.Lcgl.Lc_jjfzmd xm)
{
//xm.Ztdm = (int)TStar.Web.Globals.SystemSetting.Status.Submitted;
int r = Update <Model.Lcgl.Lc_jjfzmd>(xm);
// 写日志
return(r);
}
private static int Insert(Model.Lcgl.Lc_jjfzmd xm)
{
xm.Xq = BLL.Globals.SystemSetting.Dqxq;
xm.Ztdm = (int)TStar.Web.Globals.SystemSetting.Status.Draft;
int r = Insert <Model.Lcgl.Lc_jjfzmd>(xm);
// 写日志
return(r);
}
/// <summary>
/// 保存名单
/// </summary>
public static bool Save(Model.Lcgl.Lc_jjfzmd xm)
{
try
{
int r = 0;
if (String.IsNullOrEmpty(xm.Pkid)) // 新增
{
r = Insert(xm);
}
else // 保存
{
r = Update(xm);
}
return(r > 0);
}
catch (Exception err)
{
if (err.Message.IndexOf("Xh") > 0)
{
throw new Exception("该学号重复。");
}
if (err.Message.IndexOf("Sfzh") > 0)
{
throw new Exception("该身份证号重复。");
}
if (err.Message.IndexOf("Lxdh") > 0)
{
throw new Exception("该手机号码重复。");
}
if (err.Message.IndexOf("jjfzmd") > 0)
{
throw new Exception("该学生名单已存在。");
}
throw err;
}
}
//protected override void Page_Init(object sender, EventArgs e)
//{
// Columns10Widths = new int[] { 110, 100, 140, 80, 80, 80, 100, 120, 200, 120 };
// base.Page_Init(sender, e);
//}
/// <summary>
/// 导入积极分子
/// </summary>
protected int ImportJjfzmd(DataRowView drv, string drsj)
{
int cnt = 0;
string[] columns = Columns;
string bmbh = TStar.Web.Globals.Account.DeptPkid;
string dzbmc = drv[columns[0]].ToString().Trim();
Model.Jcgl.Jd_dzb dzb = BLL.Jcgl.Jd_dzb.GetEntity(bmbh, dzbmc);
if (string.IsNullOrEmpty(dzb.Pkid))
{
throw new Exception("该党支部信息不存在。");
}
string zymc = drv[columns[1]].ToString().Trim();
Model.Jcgl.Jd_zy zy = BLL.Jcgl.Jd_zy.GetEntity(bmbh, dzb.Pkid, zymc);
if (string.IsNullOrEmpty(zy.Pkid))
{
throw new Exception("该专业信息不存在。");
}
string zybh = zy.Pkid;
string bjmc = drv[columns[2]].ToString().Trim();
Model.Jcgl.Jd_bj bj = BLL.Jcgl.Jd_bj.GetEntity(bmbh, zybh, bjmc);
if (string.IsNullOrEmpty(bj.Pkid))
{
throw new Exception("该班级信息不存在。");
}
string xh = drv[columns[3]].ToString().Trim();
if (string.IsNullOrEmpty(xh))
{
throw new Exception("学号不能为空。");
}
if (BLL.Jcgl.Jc_xs.IsRepeated("Xh", xh))
{
throw new Exception("该学生已存在。");
}
string xm = drv[columns[4]].ToString().Trim();
if (string.IsNullOrEmpty(xm))
{
throw new Exception("姓名不能为空。");
}
string xb = drv[columns[5]].ToString().Trim();
string xbdm = TU.Globals.BindSystemCode(BLL.Globals.SystemCode.DtDm_xb, "Mc", "Dm", xb, "");
if (string.IsNullOrEmpty(xbdm))
{
throw new Exception("性别不正确。");
}
string sfzh = drv[columns[6]].ToString().Trim();
if (sfzh.Length != 18)
{
throw new Exception("该身份证号长度不正确。");
}
if (BLL.Jcgl.Jc_xs.IsRepeated("Sfzh", sfzh))
{
throw new Exception("该身份证号已存在。");
}
int jcxb = int.Parse(sfzh[16].ToString());
if (xb == "男" && jcxb % 2 == 0 || xb == "女" && jcxb % 2 == 1)
{
throw new Exception("该身份证号的性别位不正确。");
}
DateTime dt;
string csrq = string.Format("{0}-{1}-{2}", sfzh.Substring(6, 4), sfzh.Substring(10, 2), sfzh.Substring(12, 2));
if (!DateTime.TryParse(csrq, out dt))
{
throw new Exception("该身份证号的出生日期位不正确。");
}
string jg = drv[columns[7]].ToString();
if (string.IsNullOrEmpty(jg))
{
throw new Exception("籍贯不能为空。");
}
string mz = drv[columns[8]].ToString();
if (string.IsNullOrEmpty(mz))
{
throw new Exception("民族不能为空。");
}
string zw = drv[columns[9]].ToString();
string sj = drv[columns[10]].ToString();
if (string.IsNullOrEmpty(mz))
{
throw new Exception("手机不能为空。");
}
string sqrq = drv[columns[11]].ToString();
if (sqrq.Length < 8)
{
throw new Exception(columns[11] + "不正确。");
}
sqrq = string.Format("{0}-{1}-{2}", sqrq.Substring(0, 4), sqrq.Substring(4, 2), sqrq.Substring(6, 2));
if (!DateTime.TryParse(sqrq, out dt))
{
throw new Exception(columns[11] + "不正确。");
}
string qdrq = drv[columns[12]].ToString();
if (qdrq.Length < 8)
{
throw new Exception(columns[12] + "不正确。");
}
qdrq = string.Format("{0}-{1}-{2}", qdrq.Substring(0, 4), qdrq.Substring(4, 2), qdrq.Substring(6, 2));
if (!DateTime.TryParse(qdrq, out dt))
{
throw new Exception(columns[12] + "不正确。");
}
string lxrgh = drv[columns[13]].ToString();
string lxrxm = drv[columns[14]].ToString();
Model.Jcgl.V_jc_lxr lxr = BLL.Jcgl.Jc_lxr.GetEntity(bmbh, dzb.Pkid, lxrgh, lxrxm);
if (string.IsNullOrEmpty(lxr.Pkid))
{
throw new Exception("该联系人信息不存在。");
}
string jtdz = drv[columns[15]].ToString();
if (string.IsNullOrEmpty(jtdz))
{
throw new Exception(columns[11] + "不能为空。");
}
Model.Lcgl.Lc_jjfzmd m = new Model.Lcgl.Lc_jjfzmd();
m.Bmbh = bmbh;
m.Zybh = zybh;
m.Bjbh = bj.Pkid;
m.Dzbbh = dzb.Pkid;
m.Xh = xh;
m.Xm = xm;
m.Xbdm = xbdm;
m.Sfzh = sfzh;
m.Jg = jg;
m.Mz = mz;
m.Lxdh = sj;
m.Zw = zw;
m.Sqrdrq = sqrq;
m.Jjfzrq = qdrq;
m.Lxrbh = lxr.Pkid;
m.Jtdz = jtdz;
m.Drsj = drsj;
if (BLL.Lcgl.Lc_jjfzmd.Save(m))
{
cnt = 1;
drv["Del"] = 1;
}
return(cnt);
}
