public static void SaveInfoCheckFail(YuyueInfo info, string name, string msg)
{
info.Checked = 2;
info.CheckOperator = name;
info.Jbr = name;
info.CheckResult = msg;
SimpleOrmOperator.Update(info);
if (!DataAccessFactory.GetDataAccess().ExecuteSql("update table_yuyue_limit set i_tpused_num=i_tpused_num-1 where i_tpused_num>0 and id=" + info.PaibanId))
{
DataAccessFactory.GetDataAccess().ExecuteSql("update table_yuyue_limit set i_used_num=i_used_num-1 where i_used_num>0 and id=" + info.PaibanId);
}
}
public static bool Delete(int id)
{
YuyueInfo info = SimpleOrmOperator.Query <YuyueInfo>(id);
if (info.Checked != 0)
{
return(false);
}
bool result = SimpleOrmOperator.Delete <YuyueInfo>(id);
if (result)
{
if (!DataAccessFactory.GetDataAccess().ExecuteSql("update table_yuyue_limit set i_tpused_num=i_tpused_num-1 where i_tpused_num>0 and id=" + info.PaibanId))
{
DataAccessFactory.GetDataAccess().ExecuteSql("update table_yuyue_limit set i_used_num=i_used_num-1 where i_used_num>0 and id=" + info.PaibanId);
}
}
return(result);
}
public static DrvPreasignRequest ConvertInfoToRequest(YuyueInfo info)
{
DrvPreasignRequest req = new DrvPreasignRequest();
req.Lsh = info.Lsh;
req.Dlr = info.DlrCode;
req.Jbr = info.CheckOperator;
//req.setKchp("");
//44051 上午第一场
req.Kscc = info.KsccCode;
req.Jly = info.JlyIdCard;
req.Kchp = info.Hmhp;
//汕头大学路考场
req.Ksdd = info.KsddCode;
req.Pxshrq = info.Pxshrq;
String sn = System.Configuration.ConfigurationManager.AppSettings["Drv_Yuyue_Sn"];
req.Sn = sn;
req.Xxsj = "0";
req.Kskm = info.Km;
req.Ykrq = info.Ksrq;
return(req);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
/*
*
* info = new YuyueInfo();
* info.Checked = 0;
* info.Dlr = this.Operator.Desp4;
* info.DlrCode = this.Operator.Desp3;
* info.Hmhp = this.cbCarNo.SelectedItem.Text;
* info.IdCard = this.txtIdCard.Text.Trim();
* info.JlyIdCard = jly;
*
* info.Km = km;
* info.Kscc = this.cbKscc.SelectedItem.Text;
* info.KsccCode = this.cbKscc.SelectedItem.Value;
* info.Ksdd = this.cbKsdd.SelectedItem.Text;
* info.KsddCode = this.cbKsdd.SelectedItem.Value;
* info.Ksrq = this.lbYkrq.Text.Trim();
*
* info.PaibanId = int.Parse(this.hidPaiBanId.Value);
* info.Pxshrq = this.txtDate.Value;
*
* SimpleOrmOperator.Create(info);
* WebTools.Alert(this, "预约成功！");
*
* YuyueInfoOperator.Check(id,this.Operator.OperatorName);
*
*/
YuyueInfo info = new YuyueInfo();
info.Checked = 0;
info.Dlr = this.cbSchool.SelectedItem.Text;
info.DlrCode = this.cbSchool.SelectedItem.Value;
info.Hmhp = this.cbCarNo.SelectedItem.Text;
info.IdCard = this.txtIdCard.Text.Trim();
info.JlyIdCard = this.cbCarNo.SelectedItem.Value;
info.Km = int.Parse(this.cbKm.SelectedItem.Value);
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.txtYkrq.Value.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = this.txtDate.Value;
DataTable dttmp = FT.WebServiceInterface.DrvQuery.ZhZwQueryHelper.GetDataTable(info.IdCard);
if (info.Km == 1)
{
if (dttmp == null || dttmp.Rows.Count == 0 || dttmp.Rows[0]["lesson_result"].ToString() == "未完成")
{
WebTools.Alert(this, "该用户没有完成足够的学时，无法进行科目一预约！");
return;
}
}
else if (info.Km == 3)
{
if (dttmp == null || dttmp.Rows.Count == 0 || dttmp.Rows[0]["train_result"].ToString() == "未完成")
{
WebTools.Alert(this, "该用户没有完成足够的入场训练，无法进行科目三预约！");
return;
}
}
SimpleOrmOperator.Create(info);
ArrayList list = SimpleOrmOperator.QueryConditionList <YuyueInfo>(" where c_idcard='" + info.IdCard + "' order by id desc");
if (list.Count != 0)
{
YuyueInfo tmp = list[0] as YuyueInfo;
YuyueInfoOperator.Check(tmp.Id, this.Operator.OperatorName);
this.btnSearch_Click(null, null);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string idcard = this.txtIdCard.Text.Trim();
if (idcard.Length == 15)
{
idcard = FT.Commons.Tools.IDCardHelper.IdCard15To18(idcard);
}
else if (idcard.Length == 18)
{
string tmpstr = FT.Commons.Tools.IDCardHelper.Validate(idcard);
if (tmpstr.Length > 0)
{
WebTools.Alert(this, tmpstr);
return;
}
}
int km = int.Parse(this.cbKm.SelectedValue);
string glbm = System.Configuration.ConfigurationManager.AppSettings["DrvHelperSystem_glbm"];
DateTime yyrq = Convert.ToDateTime(lbYkrq.Text);
DateTime now = System.DateTime.Now;
int bkjg = int.Parse(ConfigurationManager.AppSettings["DrvHelperSystem_bkjg"].ToString());
bool boolAfterDay = bool.Parse(ConfigurationManager.AppSettings["Drv_Yuyue_After_Days_Boolean"].ToString());
int afterDay = int.Parse(ConfigurationManager.AppSettings["Drv_Yuyue_After_Days"].ToString());
if (boolAfterDay)
{
if (now.AddDays(afterDay).CompareTo(yyrq) < 0)
{
WebTools.Alert(this, "只能预约" + afterDay + "天之后的排班！");
return;
}
}
ArrayList list = SimpleOrmOperator.QueryConditionList <YuyueInfo>(" where i_km=" + km + " and c_idcard='" + idcard + "'");
if (list != null && list.Count > 0 && km == 1)
{
WebTools.Alert(this, "科目一预约只能在本系统预约一次，补考预约请到业务大厅！");
return;
}
if (km > 1 && list != null)
{
if (list.Count == 2)
{
WebTools.Alert(this, "科目二、三预约只能在本系统预约二次，补考预约请到业务大厅！");
return;
}
if (list.Count == 1)
{
YuyueInfo yytmp = list[0] as YuyueInfo;
if (yytmp.Checked == 0)
{
WebTools.Alert(this, "科目二、三预约身份证明号码" + idcard + "已经预约过考试日期为：" + yytmp.Ksrq + ",处于待审核中！");
return;
}
}
}
// ArrayList cars = SimpleOrmOperator.QueryConditionList<SchoolCarInfo>(" where hmhp='"+this.cbCarNo.SelectedItem.Text+"'");
string jly = "";
string sql = "update table_yuyue_limit set i_used_num=i_used_num+1 where i_used_num<i_total and id=" + this.hidPaiBanId.Value;
bool result = DataAccessFactory.GetDataAccess().ExecuteSql(sql);
YuyueInfo info;
if (result)
{
info = new YuyueInfo();
info.Checked = 0;
info.Hmhp = this.txtCarNo.Text.Trim();
info.IdCard = this.txtIdCard.Text.Trim();
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = "";
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
return;
}
else
{
sql = "update table_yuyue_limit set i_tpused_num=i_tpused_num+1 where i_tpused_num<i_tptotal and id=" + this.hidPaiBanId.Value;
result = DataAccessFactory.GetDataAccess().ExecuteSql(sql);
if (result)
{
info = new YuyueInfo();
info.Checked = 0;
info.Hmhp = this.txtCarNo.Text.Trim();
info.IdCard = this.txtIdCard.Text.Trim();
info.DlrCode = "social";
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = "";
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
return;
}
}
WebTools.Alert(this, "预约已满人！");
return;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
/*
info = new YuyueInfo();
info.Checked = 0;
info.Dlr = this.Operator.Desp4;
info.DlrCode = this.Operator.Desp3;
info.Hmhp = this.cbCarNo.SelectedItem.Text;
info.IdCard = this.txtIdCard.Text.Trim();
info.JlyIdCard = jly;
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = this.txtDate.Value;
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
YuyueInfoOperator.Check(id,this.Operator.OperatorName);
*/
YuyueInfo info = new YuyueInfo();
info.Checked = 0;
info.Dlr = this.cbSchool.SelectedItem.Text;
info.DlrCode = this.cbSchool.SelectedItem.Value;
info.Hmhp = this.cbCarNo.SelectedItem.Text;
info.IdCard = this.txtIdCard.Text.Trim();
info.JlyIdCard = this.cbCarNo.SelectedItem.Value;
info.Km = int.Parse(this.cbKm.SelectedItem.Value);
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.txtYkrq.Value.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = this.txtDate.Value;
DataTable dttmp = FT.WebServiceInterface.DrvQuery.ZhZwQueryHelper.GetDataTable(info.IdCard);
if (info.Km == 1)
{
if (dttmp == null || dttmp.Rows.Count == 0 || dttmp.Rows[0]["lesson_result"].ToString() == "未完成")
{
WebTools.Alert(this, "该用户没有完成足够的学时，无法进行科目一预约！");
return;
}
}
else if (info.Km == 3)
{
if (dttmp == null || dttmp.Rows.Count == 0 || dttmp.Rows[0]["train_result"].ToString() == "未完成")
{
WebTools.Alert(this, "该用户没有完成足够的入场训练，无法进行科目三预约！");
return;
}
}
SimpleOrmOperator.Create(info);
ArrayList list = SimpleOrmOperator.QueryConditionList<YuyueInfo>(" where c_idcard='"+info.IdCard+"' order by id desc");
if (list.Count != 0)
{
YuyueInfo tmp = list[0] as YuyueInfo;
YuyueInfoOperator.Check(tmp.Id, this.Operator.OperatorName);
this.btnSearch_Click(null, null);
}
}
public static void SaveInfoCheckFail(YuyueInfo info, string name,string msg)
{
info.Checked = 2;
info.CheckOperator = name;
info.Jbr = name;
info.CheckResult = msg;
SimpleOrmOperator.Update(info);
if (!DataAccessFactory.GetDataAccess().ExecuteSql("update table_yuyue_limit set i_tpused_num=i_tpused_num-1 where i_tpused_num>0 and id=" + info.PaibanId))
{
DataAccessFactory.GetDataAccess().ExecuteSql("update table_yuyue_limit set i_used_num=i_used_num-1 where i_used_num>0 and id=" + info.PaibanId);
}
}
public static DrvPreasignRequest ConvertInfoToRequest(YuyueInfo info)
{
DrvPreasignRequest req = new DrvPreasignRequest();
req.Lsh = info.Lsh;
req.Dlr = info.DlrCode;
req.Jbr = info.CheckOperator;
//req.setKchp("");
//44051 上午第一场
req.Kscc = info.KsccCode;
req.Jly = info.JlyIdCard;
req.Kchp = info.Hmhp;
//汕头大学路考场
req.Ksdd = info.KsddCode;
req.Pxshrq = info.Pxshrq;
String sn = System.Configuration.ConfigurationManager.AppSettings["Drv_Yuyue_Sn"];
req.Sn = sn;
req.Xxsj = "0";
req.Kskm = info.Km;
req.Ykrq = info.Ksrq;
return req;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.txtDate.Value.Trim().Length == 0)
{
WebTools.Alert(this, "必须输入培训审核日期！");
return;
}
string idcard = this.txtIdCard.Text.Trim();
if (idcard.Length == 15)
{
idcard = FT.Commons.Tools.IDCardHelper.IdCard15To18(idcard);
}
else if (idcard.Length == 18)
{
string tmpstr = FT.Commons.Tools.IDCardHelper.Validate(idcard);
if (tmpstr.Length > 0)
{
WebTools.Alert(this, tmpstr);
return;
}
}
int km = int.Parse(this.cbKm.SelectedValue);
string glbm = this.Operator.Desp2;
DateTime yyrq = Convert.ToDateTime(this.txtDate.Value);
DateTime now = System.DateTime.Now;
// if (dt != null)
// {
string tmpid = "";
tmpid = this.DataGrid1.Items[this.DataGrid1.Items.Count - 1].Cells[2].Text;
if (tmpid != null && tmpid.Replace(" ", "").Length > 0)
{
WebTools.Alert(this, tmpid + "本期允许约考人员已经约考完毕！");
return;
}
for (int i = 0; i < this.DataGrid1.Items.Count; i++)
{
tmpid = this.DataGrid1.Items[i].Cells[2].Text;
if (tmpid != null && tmpid == idcard)
{
///TODO:
WebTools.Alert(this, "身份证明号码" + idcard + "该学员已经在本期约考过！");
return;
}
}
//}
int bkjg = int.Parse(ConfigurationManager.AppSettings["DrvHelperSystem_bkjg"].ToString());
bool boolAfterDay = bool.Parse(ConfigurationManager.AppSettings["Drv_Yuyue_After_Days_Boolean"].ToString());
int afterDay = int.Parse(ConfigurationManager.AppSettings["Drv_Yuyue_After_Days"].ToString());
if (boolAfterDay)
{
if (now.AddDays(afterDay).CompareTo(yyrq) < 0)
{
WebTools.Alert(this, "只能预约" + afterDay + "天之后的排班！");
return;
}
}
ArrayList list = SimpleOrmOperator.QueryConditionList <YuyueInfo>(" where i_checked<>2 and i_km=" + km + " and c_idcard='" + idcard + "'");
if (list != null && list.Count > 0 && km == 1)
{
WebTools.Alert(this, "科目一预约只能在本系统预约一次，补考预约请到业务大厅！");
return;
}
if (km > 1 && list != null)
{
if (list.Count == 2)
{
WebTools.Alert(this, "科目二、三预约只能在本系统预约二次，补考预约请到业务大厅！");
return;
}
if (list.Count == 1)
{
YuyueInfo yytmp = list[0] as YuyueInfo;
if (yytmp.Checked == 0)
{
WebTools.Alert(this, "科目二、三预约身份证明号码" + idcard + "已经预约过考试日期为：" + yytmp.Ksrq + ",处于待审核中！");
return;
}
}
}
// ArrayList cars = SimpleOrmOperator.QueryConditionList<SchoolCarInfo>(" where hmhp='"+this.cbCarNo.SelectedItem.Text+"'");
string jly = this.cbCarNo.SelectedItem.Value == null?"":this.cbCarNo.SelectedItem.Value.ToString();
string sql1 = "update table_yuyue_limit t set t.i_used_num=(select count(*) from table_yuyue_info m where m.i_checked<>2 and m.i_paibanid=" + this.hidPaiBanId.Value + ") where t.id=" + this.hidPaiBanId.Value;
DataAccessFactory.GetDataAccess().ExecuteSql(sql1);
string sql = "update table_yuyue_limit set i_used_num=i_used_num+1 where i_used_num<i_total and id=" + this.hidPaiBanId.Value;
bool result = DataAccessFactory.GetDataAccess().ExecuteSql(sql);
YuyueInfo info;
if (result)
{
info = new YuyueInfo();
info.Checked = 0;
info.Dlr = this.Operator.Desp4;
info.DlrCode = this.Operator.Desp3;
info.Hmhp = this.txtHphm.Text.Trim().Length == 0?this.cbCarNo.SelectedItem.Text:this.txtHphm.Text.Trim();
info.IdCard = this.txtIdCard.Text.Trim();
info.JlyIdCard = jly;
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = this.txtDate.Value;
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
this.ReBind();
return;
}
else
{
sql = "update table_yuyue_limit set i_tpused_num=i_tpused_num+1 where i_tpused_num<i_tptotal and id=" + this.hidPaiBanId.Value;
result = DataAccessFactory.GetDataAccess().ExecuteSql(sql);
if (result)
{
info = new YuyueInfo();
info.Checked = 0;
info.Dlr = this.Operator.Desp4;
info.DlrCode = this.Operator.Desp3;
info.Hmhp = this.txtHphm.Text.Trim().Length == 0 ? this.cbCarNo.SelectedItem.Text : this.txtHphm.Text.Trim();
info.IdCard = this.txtIdCard.Text.Trim();
info.JlyIdCard = jly;
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = this.txtDate.Value;
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
this.ReBind();
return;
}
}
WebTools.Alert(this, "预约已满人！");
return;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string idcard = this.txtIdCard.Text.Trim();
if (idcard.Length == 15)
{
idcard = FT.Commons.Tools.IDCardHelper.IdCard15To18(idcard);
}
else if (idcard.Length == 18)
{
string tmpstr = FT.Commons.Tools.IDCardHelper.Validate(idcard);
if (tmpstr.Length > 0)
{
WebTools.Alert(this, tmpstr);
return;
}
}
int km = int.Parse(this.cbKm.SelectedValue);
string glbm = System.Configuration.ConfigurationManager.AppSettings["DrvHelperSystem_glbm"];
DateTime yyrq = Convert.ToDateTime(lbYkrq.Text);
DateTime now = System.DateTime.Now;
int bkjg = int.Parse(ConfigurationManager.AppSettings["DrvHelperSystem_bkjg"].ToString());
bool boolAfterDay = bool.Parse(ConfigurationManager.AppSettings["Drv_Yuyue_After_Days_Boolean"].ToString());
int afterDay = int.Parse(ConfigurationManager.AppSettings["Drv_Yuyue_After_Days"].ToString());
if (boolAfterDay)
{
if (now.AddDays(afterDay).CompareTo(yyrq) < 0)
{
WebTools.Alert(this, "只能预约" + afterDay + "天之后的排班！");
return;
}
}
ArrayList list = SimpleOrmOperator.QueryConditionList<YuyueInfo>(" where i_km=" + km + " and c_idcard='" + idcard + "'");
if (list != null && list.Count > 0 && km == 1)
{
WebTools.Alert(this, "科目一预约只能在本系统预约一次，补考预约请到业务大厅！");
return;
}
if (km > 1 && list != null)
{
if (list.Count == 2)
{
WebTools.Alert(this, "科目二、三预约只能在本系统预约二次，补考预约请到业务大厅！");
return;
}
if (list.Count == 1)
{
YuyueInfo yytmp = list[0] as YuyueInfo;
if (yytmp.Checked == 0)
{
WebTools.Alert(this, "科目二、三预约身份证明号码" + idcard + "已经预约过考试日期为：" + yytmp.Ksrq + ",处于待审核中！");
return;
}
}
}
// ArrayList cars = SimpleOrmOperator.QueryConditionList<SchoolCarInfo>(" where hmhp='"+this.cbCarNo.SelectedItem.Text+"'");
string jly = "";
string sql = "update table_yuyue_limit set i_used_num=i_used_num+1 where i_used_num<i_total and id=" + this.hidPaiBanId.Value;
bool result = DataAccessFactory.GetDataAccess().ExecuteSql(sql);
YuyueInfo info;
if (result)
{
info = new YuyueInfo();
info.Checked = 0;
info.Hmhp = this.txtCarNo.Text.Trim();
info.IdCard = this.txtIdCard.Text.Trim();
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = "";
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
return;
}
else
{
sql = "update table_yuyue_limit set i_tpused_num=i_tpused_num+1 where i_tpused_num<i_tptotal and id=" + this.hidPaiBanId.Value;
result = DataAccessFactory.GetDataAccess().ExecuteSql(sql);
if (result)
{
info = new YuyueInfo();
info.Checked = 0;
info.Hmhp = this.txtCarNo.Text.Trim();
info.IdCard = this.txtIdCard.Text.Trim();
info.DlrCode = "social";
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = "";
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
return;
}
}
WebTools.Alert(this, "预约已满人！");
return;
}
public static void Check(int id, string name)
{
try
{
// throw new Exception("测试异常");
YuyueInfo info = SimpleOrmOperator.Query <YuyueInfo>(id);
string glbm = System.Configuration.ConfigurationManager.AppSettings["DrvHelperSystem_glbm"];
int bkjg = int.Parse(ConfigurationManager.AppSettings["DrvHelperSystem_bkjg"].ToString());
string idcard = info.IdCard;
DateTime yyrq = Convert.ToDateTime(info.Ksrq);
int km = info.Km;
/*
* TempStudentInfo student = DrvQueryHelper.QueryStudent(glbm, info.IdCard);
* if (student == null)
* {
* SaveInfoCheckFail(info, name, "该学员不是本地车管所报名的！");
* return;
* }
* info.Dlr = student.jxmc;
* info.DlrCode = student.jxdm;
* info.JlyIdCard = student.jly;
* info.Km = km;
* info.Lsh = student.lsh;
* info.Xm = student.name;
* info.Zjcx = student.zkcx;
* /*
* try
* {
* if (DateTime.Parse(student.yxqz).CompareTo(yyrq) < 0)
* {
* SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "的准考证明有效期到" + student.yxqz + "截止！");
* return;
*
* }
* }
* catch (System.Exception e)
* {
*
* }
*
*
* if (student.jxdm != null && student.jxdm != info.DlrCode)
* {
* SaveInfoCheckFail(info, name, "驾校学员只能通过相关驾校帮您预约！");
* return;
*
* }
* */
//ArrayList daylimits = SimpleOrmOperator.QueryConditionList<YuyueDayLimit>(" where c_cartype like '%" + student.zkcx + "%' and i_km=" + km);
ArrayList daylimits = SimpleOrmOperator.QueryConditionList <YuyueDayLimit>(" where c_cartype like '%" + "C1" + "%' and i_km=" + km);
TempKscjInfo kscj = DrvQueryHelper.QueryKscj(glbm, idcard);
YuyueDayLimit daylimit = null;
if (daylimits != null && daylimits.Count > 0)
{
daylimit = daylimits[0] as YuyueDayLimit;
}
if (kscj != null)
{
if (km == 1)
{
if (kscj.km1 == 1)
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "的科目一已经合格！");
return;
}
}
else if (km == 2)
{
if (kscj.km2yyrq != null)
{
if (kscj.km2 == 1)
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "的科目二已经合格！");
return;
}
if (kscj.km2 == 2)
{
if (yyrq.CompareTo(DateTime.Parse(kscj.km2yyrq).AddDays(bkjg)) < 0)
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "上次考试时间为：" + kscj.km2yyrq + ",科目二补考必须在上一次考试" + bkjg + "天之后！");
return;
}
}
}
else if (kscj.km1 == 1 && daylimit != null)
{
if (yyrq.CompareTo(DateTime.Parse(kscj.km1yyrq).AddDays(daylimit.Days)) < 0)
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "科目一考试时间为：" + kscj.km1yyrq + ",申请" + daylimit.CarType + "牌照的科目二考试必须在" + daylimit.Days + "天之后！");
return;
}
}
else
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "科目一还没有合格！");
return;
}
}
else if (km == 3)
{
if (kscj.km3yyrq != null)
{
if (kscj.km3 == 1)
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "的科目三已经合格！");
return;
}
if (kscj.km3 == 2)
{
if (yyrq.CompareTo(DateTime.Parse(kscj.km3yyrq).AddDays(bkjg)) < 0)
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "上次考试时间为：" + kscj.km2yyrq + ",科目三补考必须在上一次考试" + bkjg + "天之后！");
return;
}
}
}
else if (kscj.km2 == 1 && daylimit != null)
{
if (yyrq.CompareTo(DateTime.Parse(kscj.km1yyrq).AddDays(daylimit.Days)) < 0)
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "科目一考试时间为：" + kscj.km1yyrq + ",申请" + daylimit.CarType + "牌照的科目三考试必须在" + daylimit.Days + "天之后！");
return;
}
}
else
{
SaveInfoCheckFail(info, name, "身份证明号码" + idcard + "科目二还没有合格！");
return;
}
}
}
//&& info.Checked == 0
if (info != null)
{
info.CheckOperator = name;
info.Jbr = name;
TmriResponse resp = null;
try
{
string useold = System.Configuration.ConfigurationManager.AppSettings["Drv_Yuyue_Use_Old"];
if (useold == "true")
{
resp = new TmriResponse();
bool resultold = DriverInterface.WritePreasignOld(ConvertInfoToRequest(info));
// resultold ? 0 : 2;
if (resultold)
{
resp.Code = 0;
resp.Message = "更新成功";
}
else
{
resp.Code = 2;
resp.Message = "更新不成功";
}
}
else
{
resp = DriverInterface.WriteDrvBaseTmriRequest(ConvertInfoToRequest(info));
}
//resp= DriverInterface.yuyueInfo(info);
}
catch (Exception exe)
{
SaveInfoCheckFail(info, name, exe.Message);
//info.CheckResult = exe.Message;
// SimpleOrmOperator.Update(info);
return;
}
if (resp.Code == 0 || resp.Code == 1)
{
info.Checked = 1;
info.CheckResult = resp.Message;
SimpleOrmOperator.Update(info);
if (!DataAccessFactory.GetDataAccess().ExecuteSql("update table_yuyue_limit set i_checked_num=i_checked_num+1 where i_checked_num<i_used_num and id=" + info.PaibanId))
{
DataAccessFactory.GetDataAccess().ExecuteSql("update table_yuyue_limit set i_tpchecked_num=i_tpchecked_num+1 where i_tpchecked_num<i_tpused_num and id=" + info.PaibanId);
}
}
else
{
SaveInfoCheckFail(info, name, resp.Message);
//info.Checked = 2;
//info.CheckResult = resp.Message;
// SimpleOrmOperator.Update(info);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (this.txtDate.Value.Trim().Length == 0)
{
WebTools.Alert(this, "必须输入培训审核日期！");
return;
}
string idcard=this.txtIdCard.Text.Trim();
if (idcard.Length == 15)
{
idcard = FT.Commons.Tools.IDCardHelper.IdCard15To18(idcard);
}
else if (idcard.Length == 18)
{
string tmpstr=FT.Commons.Tools.IDCardHelper.Validate(idcard);
if (tmpstr.Length > 0)
{
WebTools.Alert(this, tmpstr);
return;
}
}
int km=int.Parse(this.cbKm.SelectedValue);
string glbm=this.Operator.Desp2;
DateTime yyrq = Convert.ToDateTime(this.txtDate.Value);
DateTime now = System.DateTime.Now;
// if (dt != null)
// {
string tmpid = "";
tmpid = this.DataGrid1.Items[this.DataGrid1.Items.Count-1].Cells[2].Text;
if (tmpid != null && tmpid.Replace(" ","").Length > 0)
{
WebTools.Alert(this, tmpid+"本期允许约考人员已经约考完毕！");
return;
}
for (int i = 0; i < this.DataGrid1.Items.Count; i++)
{
tmpid = this.DataGrid1.Items[i].Cells[2].Text;
if (tmpid!=null&&tmpid == idcard)
{
///TODO:
WebTools.Alert(this, "身份证明号码" + idcard + "该学员已经在本期约考过！");
return;
}
}
//}
int bkjg = int.Parse(ConfigurationManager.AppSettings["DrvHelperSystem_bkjg"].ToString());
bool boolAfterDay = bool.Parse(ConfigurationManager.AppSettings["Drv_Yuyue_After_Days_Boolean"].ToString());
int afterDay = int.Parse(ConfigurationManager.AppSettings["Drv_Yuyue_After_Days"].ToString());
if (boolAfterDay)
{
if (now.AddDays(afterDay).CompareTo(yyrq) < 0)
{
WebTools.Alert(this, "只能预约" + afterDay+ "天之后的排班！");
return;
}
}
ArrayList list = SimpleOrmOperator.QueryConditionList<YuyueInfo>(" where i_checked<>2 and i_km=" + km + " and c_idcard='" + idcard + "'");
if (list != null && list.Count > 0 && km == 1)
{
WebTools.Alert(this, "科目一预约只能在本系统预约一次，补考预约请到业务大厅！");
return;
}
if (km > 1 && list != null)
{
if (list.Count == 2)
{
WebTools.Alert(this, "科目二、三预约只能在本系统预约二次，补考预约请到业务大厅！");
return;
}
if (list.Count == 1)
{
YuyueInfo yytmp = list[0] as YuyueInfo;
if (yytmp.Checked == 0)
{
WebTools.Alert(this, "科目二、三预约身份证明号码" + idcard + "已经预约过考试日期为：" + yytmp.Ksrq + ",处于待审核中！");
return;
}
}
}
// ArrayList cars = SimpleOrmOperator.QueryConditionList<SchoolCarInfo>(" where hmhp='"+this.cbCarNo.SelectedItem.Text+"'");
string jly=this.cbCarNo.SelectedItem.Value==null?"":this.cbCarNo.SelectedItem.Value.ToString();
string sql1 = "update table_yuyue_limit t set t.i_used_num=(select count(*) from table_yuyue_info m where m.i_checked<>2 and m.i_paibanid=" + this.hidPaiBanId.Value + ") where t.id=" + this.hidPaiBanId.Value;
DataAccessFactory.GetDataAccess().ExecuteSql(sql1);
string sql = "update table_yuyue_limit set i_used_num=i_used_num+1 where i_used_num<i_total and id=" + this.hidPaiBanId.Value;
bool result = DataAccessFactory.GetDataAccess().ExecuteSql(sql);
YuyueInfo info;
if (result)
{
info = new YuyueInfo();
info.Checked = 0;
info.Dlr = this.Operator.Desp4;
info.DlrCode = this.Operator.Desp3;
info.Hmhp = this.txtHphm.Text.Trim().Length==0?this.cbCarNo.SelectedItem.Text:this.txtHphm.Text.Trim();
info.IdCard = this.txtIdCard.Text.Trim();
info.JlyIdCard = jly;
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = this.txtDate.Value;
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
this.ReBind();
return;
}
else
{
sql = "update table_yuyue_limit set i_tpused_num=i_tpused_num+1 where i_tpused_num<i_tptotal and id=" + this.hidPaiBanId.Value;
result = DataAccessFactory.GetDataAccess().ExecuteSql(sql);
if (result)
{
info = new YuyueInfo();
info.Checked = 0;
info.Dlr = this.Operator.Desp4;
info.DlrCode = this.Operator.Desp3;
info.Hmhp = this.txtHphm.Text.Trim().Length == 0 ? this.cbCarNo.SelectedItem.Text : this.txtHphm.Text.Trim();
info.IdCard = this.txtIdCard.Text.Trim();
info.JlyIdCard = jly;
info.Km = km;
info.Kscc = this.cbKscc.SelectedItem.Text;
info.KsccCode = this.cbKscc.SelectedItem.Value;
info.Ksdd = this.cbKsdd.SelectedItem.Text;
info.KsddCode = this.cbKsdd.SelectedItem.Value;
info.Ksrq = this.lbYkrq.Text.Trim();
info.PaibanId = int.Parse(this.hidPaiBanId.Value);
info.Pxshrq = this.txtDate.Value;
SimpleOrmOperator.Create(info);
WebTools.Alert(this, "预约成功！");
this.ReBind();
return;
}
}
WebTools.Alert(this, "预约已满人！");
return;
}
