private static int Update(Model.Lcgl.Lc_dymd xm)
{
//xm.Ztdm = (int)TStar.Web.Globals.SystemSetting.Status.Submitted;
int r = Update <Model.Lcgl.Lc_dymd>(xm);
// 写日志
return(r);
}
private static int Insert(Model.Lcgl.Lc_dymd xm)
{
xm.Xq = BLL.Globals.SystemSetting.Dqxq;
xm.Ztdm = (int)TStar.Web.Globals.SystemSetting.Status.Draft;
int r = Insert <Model.Lcgl.Lc_dymd>(xm);
// 写日志
return(r);
}
/// <summary>
/// 保存名单
/// </summary>
public static bool Save(Model.Lcgl.Lc_dymd 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("dymd") > 0)
{
throw new Exception("该学生名单已存在。");
}
throw err;
}
}
/// <summary>
/// 导入党员名单
/// </summary>
protected int ImportDymd(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().Replace("_", "");
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().Trim();
if (string.IsNullOrEmpty(jg))
{
throw new Exception("籍贯不能为空。");
}
string mz = drv[columns[8]].ToString().Trim();
if (string.IsNullOrEmpty(mz))
{
throw new Exception("民族不能为空。");
}
string zw = drv[columns[9]].ToString().Trim();
string sj = drv[columns[10]].ToString().Trim();
if (string.IsNullOrEmpty(sj))
{
throw new Exception("手机不能为空。");
}
if (sj.Length != 11)
{
throw new Exception("该手机号长度不正确。");
}
string sqrq = drv[columns[11]].ToString().Trim();
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().Trim();
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 jyrq = drv[columns[13]].ToString().Trim();
if (jyrq.Length != 8)
{
throw new Exception(columns[13] + "不正确。");
}
jyrq = string.Format("{0}.{1}.{2}", jyrq.Substring(0, 4), jyrq.Substring(4, 2), jyrq.Substring(6, 2));
if (!DateTime.TryParse(jyrq, out dt))
{
throw new Exception(columns[13] + "不正确。");
}
string filter = string.Format("Zbbh='{0}'", TU.Globals.BindSystemCode(BLL.Globals.SystemCode.DtJd_khzbLocal, "Zbmc", "Pkid", "党校培训", ""));
string djmc = drv[columns[14]].ToString();
string djbh = TU.Globals.BindSystemCode(BLL.Globals.SystemCode.DtJd_xmdjLocal, filter, "Djmc", "Pkid", djmc, "");
if (djbh == "")
{
throw new Exception(columns[14] + "不正确。");
}
string fzdxqdrq = drv[columns[15]].ToString().Trim();
if (fzdxqdrq.Length != 8)
{
throw new Exception(columns[15] + "不正确。");
}
fzdxqdrq = string.Format("{0}.{1}.{2}", fzdxqdrq.Substring(0, 4), fzdxqdrq.Substring(4, 2), fzdxqdrq.Substring(6, 2));
if (!DateTime.TryParse(fzdxqdrq, out dt))
{
throw new Exception(columns[15] + "不正确。");
}
string rdrq = drv[columns[16]].ToString().Trim();
if (rdrq.Length != 8)
{
throw new Exception(columns[16] + "不正确。");
}
rdrq = string.Format("{0}.{1}.{2}", rdrq.Substring(0, 4), rdrq.Substring(4, 2), rdrq.Substring(6, 2));
if (!DateTime.TryParse(rdrq, out dt))
{
throw new Exception(columns[16] + "不正确。");
}
string zysbh = drv[columns[17]].ToString().Trim();
if (string.IsNullOrEmpty(zysbh))
{
throw new Exception(columns[17] + "不能为空。");
}
string zzrq = drv[columns[18]].ToString().Trim();
if (string.IsNullOrEmpty(zzrq))
{
zzrq = "";
}
else
{
if (zzrq.Length != 8)
{
throw new Exception(columns[18] + "不正确。");
}
zzrq = string.Format("{0}.{1}.{2}", zzrq.Substring(0, 4), zzrq.Substring(4, 2), zzrq.Substring(6, 2));
if (!DateTime.TryParse(zzrq, out dt))
{
throw new Exception(columns[18] + "不正确。");
}
}
string lxrgh = drv[columns[19]].ToString().Trim();
string lxrxm = drv[columns[20]].ToString().Trim();
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[21]].ToString().Trim();
if (string.IsNullOrEmpty(jtdz))
{
throw new Exception(columns[21] + "不能为空。");
}
Model.Lcgl.Lc_dymd m = new Model.Lcgl.Lc_dymd();
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.Dxkhztdm = TU.Globals.BindSystemCode(BLL.Globals.SystemCode.DtDm_khzt, "Mc", "Dm", djmc, "1");
m.Dxjyrq = jyrq;
m.Fzdxrq = fzdxqdrq;
m.Rdrq = rdrq;
m.Zysbh = zysbh;
m.Zzrq = zzrq;
m.Lxrbh = lxr.Pkid;
m.Jtdz = jtdz;
m.Drsj = drsj;
if (BLL.Lcgl.Lc_dymd.Save(m))
{
cnt = 1;
drv["Del"] = 1;
}
return(cnt);
}
