private static int Update(Model.Xmgl.Xm_ysdb xm)
{
int r = Update <Model.Xmgl.Xm_ysdb>(xm);
// 写日志
return(r);
}
private static int Insert(Model.Xmgl.Xm_ysdb xm)
{
int r = Insert <Model.Xmgl.Xm_ysdb>(xm);
// 写日志
return(r);
}
/// <summary>
/// 保存项目
/// </summary>
public static bool Save(Model.Xmgl.Xm_ysdb xm)
{
int r = 0;
if (String.IsNullOrEmpty(xm.Pkid)) // 新增
{
r = Insert(xm);
}
else // 保存
{
r = Update(xm);
}
return(r > 0);
}
/// <summary>
/// 依据传入参数TableName导入数据
/// </summary>
protected override int ImportData(DataRowView drv)
{
int cnt = 0;
string[] columns = Columns;
string xh = drv[columns[0]].ToString();
string xm = drv[columns[1]].ToString();
string bmbh = TStar.Web.Globals.Account.DeptPkid;
string dzbbh = TStar.Web.Globals.Account.UserInfo.Dzbbh;
Model.Jcgl.Jc_xs xs = BLL.Jcgl.Jc_xs.GetEntity(bmbh, dzbbh, xh, xm);
if (string.IsNullOrEmpty(xs.Pkid))
{
throw new Exception("该学生信息不存在。");
}
string fzdxqdrq = drv[columns[2]].ToString();
fzdxqdrq = string.Format("{0}-{1}-{2}", fzdxqdrq.Substring(0, 4), fzdxqdrq.Substring(4, 2), fzdxqdrq.Substring(6, 2));
DateTime dt;
if (!DateTime.TryParse(fzdxqdrq, out dt))
{
throw new Exception(columns[2] + "不正确。");
}
string zsjg = drv[columns[3]].ToString();
string zsjgdm = TU.Globals.BindSystemCode(BLL.Globals.SystemCode.DtDm_jgzt, null, "Mc", "Dm", zsjg, "");
if (zsjgdm == "")
{
throw new Exception(columns[3] + "不正确。");
}
string dbjg = drv[columns[4]].ToString();
string dbjgdm = TU.Globals.BindSystemCode(BLL.Globals.SystemCode.DtDm_jgzt, null, "Mc", "Dm", dbjg, "");
if (dbjgdm == "")
{
throw new Exception(columns[4] + "不正确。");
}
string dbrq = drv[columns[5]].ToString();
dbrq = string.Format("{0}-{1}-{2}", dbrq.Substring(0, 4), dbrq.Substring(4, 2), dbrq.Substring(6, 2));
if (!DateTime.TryParse(dbrq, out dt))
{
throw new Exception(columns[5] + "不正确。");
}
string dbdd = drv[columns[6]].ToString();
if (string.IsNullOrEmpty(dbdd))
{
throw new Exception(columns[6] + "不能为空。");
}
string dbzcy = drv[columns[7]].ToString();
if (string.IsNullOrEmpty(dbzcy))
{
throw new Exception(columns[7] + "不能为空。");
}
string dbyj = drv[columns[8]].ToString();
if (string.IsNullOrEmpty(dbyj))
{
throw new Exception(columns[8] + "不能为空。");
}
else if (dbyj.Length > 200)
{
throw new Exception(columns[8] + "限填200个字。");
}
string zswtgyy = drv[columns[9]].ToString();
if (zsjgdm == "0")
{
if (string.IsNullOrEmpty(zswtgyy))
{
throw new Exception(columns[9] + "不能为空。");
}
else if (zswtgyy.Length > 200)
{
throw new Exception(columns[9] + "限填200个字。");
}
}
string fzrbh = xs.Pkid;
string xmrq = drv[columns[3]].ToString();
if (BLL.Xmgl.Xm_ysdb.Exist(Pkid, new string[] { "Fzrbh", "Dbrq" }, new string[] { fzrbh, dbrq }))
{
throw new Exception("该预审答辩结果已导入。");
}
Model.Xmgl.Xm_ysdb m = new Model.Xmgl.Xm_ysdb();
m.Fzrbh = fzrbh;
m.Fzdxrq = fzdxqdrq;
m.Zsjgdm = zsjgdm;
m.Dbjgdm = dbjgdm;
m.Dbrq = dbrq;
m.Dbdd = dbdd;
m.Dbzcy = dbzcy;
m.Dbpjyj = dbyj;
m.Zswtgyy = zswtgyy;
if (BLL.Xmgl.Xm_ysdb.Save(m))
{
cnt = 1;
drv["Del"] = 1;
}
return(cnt);
}
