protected void btnPrintReturn_Click(object sender, EventArgs e)
{
string sql = "select * from table_bus_all_info where c_idcard='" + this.lbIdCard.Text.Trim() + "' and i_state=0";
DataTable dt = FT.DAL.DataAccessFactory.GetDataAccess().SelectDataTable(sql, "tmpdb");
if (dt.Rows.Count == 0)
{
BusAllInfo info = new BusAllInfo();
info.Birthday = this.lbBrithday.Text;
info.Dabh = this.lbDabh.Text;
info.IdCard = this.lbIdCard.Text;
info.IdCardType = this.lbIDCardType.Text;
info.Nation = this.lbNation.Text;
info.Sex = this.lbSex.Text;
info.Xm = this.lbXm.Text;
info.CarType = this.lbLearnCar.Text;
info.CheckDate = this.lbCheckDay.Text;
info.State = 0;
info.Operator = this.Operator.OperatorName;
info.Lsh = this.hidLsh.Value;
info.IsPrintAdd = 1;
FT.DAL.Orm.SimpleOrmOperator.Create(info);
}
else
{
sql = "update table_bus_all_info set I_PRINT_ADD=I_PRINT_ADD+1 where c_idcard='" + this.lbIdCard.Text.Trim() + "' and i_state=0";
FT.DAL.DataAccessFactory.GetDataAccess().ExecuteSql(sql);
this.LogBus("补打回执单", "进行" + this.lbIdCard.Text.Trim() + "的补打回执单！");
}
}
public static BusAllInfo GetFromUser(string idcardtype, string idcard, string dabh)
{
BusAllInfo info = new BusAllInfo();
info.Dabh = "200120234";
info.Lsh = "44040120101022";
info.IdCardType = "身份证明号码";
info.IdCard = "350128198403122135";
info.Nation = "中国";
info.CarType = "C1";
info.Birthday = "1984-03-12";
info.Sex = "男";
info.Xm = "模拟用户1";
info.CheckDate = "2010-10-02";
return info;
}
public static BusAllInfo GetFromUser(string idcardtype, string idcard, string dabh)
{
BusAllInfo info = new BusAllInfo();
info.Dabh = "200120234";
info.Lsh = "44040120101022";
info.IdCardType = "身份证明号码";
info.IdCard = "350128198403122135";
info.Nation = "中国";
info.CarType = "C1";
info.Birthday = "1984-03-12";
info.Sex = "男";
info.Xm = "模拟用户1";
info.CheckDate = "2010-10-02";
return(info);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
if (this.lbIdCard.Text.Trim().Length > 0)
{
string sql = "select * from table_bus_all_info where c_idcard='" + this.lbIdCard.Text.Trim() + "' and i_state=0";
DataTable dt=FT.DAL.DataAccessFactory.GetDataAccess().SelectDataTable(sql,"tmpdb");
if (dt.Rows.Count == 0)
{
BusAllInfo info = new BusAllInfo();
info.Birthday = this.lbBrithday.Text;
info.Dabh = this.lbDabh.Text;
info.IdCard = this.lbIdCard.Text;
info.IdCardType = this.lbIDCardType.Text;
info.Nation = this.lbNation.Text;
info.Sex = this.lbSex.Text;
info.Xm = this.lbXm.Text;
info.CarType = this.lbLearnCar.Text;
info.CheckDate = this.lbCheckDay.Text;
info.State = 0;
info.Operator = this.Operator.OperatorName;
info.Lsh = this.hidLsh.Value;
info.IsPrintAdd = 1;
FT.DAL.Orm.SimpleOrmOperator.Create(info);
this.LogBus("保存受理信息", "保存" + info.IdCard + "的受理信息！");
}
else
{
sql = "update table_bus_all_info set I_PRINT_ADD=I_PRINT_ADD+1 where c_idcard='" + this.lbIdCard.Text.Trim() + "' and i_state=0";
FT.DAL.DataAccessFactory.GetDataAccess().ExecuteSql(sql);
this.LogBus("补打申请表", "补打" + this.lbIdCard.Text.Trim() + "的申请表！");
}
this.ClientScript.RegisterStartupScript(222.GetType(), "print", "<script type='text/javascript'>printExcel();</script>");
//WebTools.WriteScript("PrintTemplate();");
///TODO: 打印申请表并进行受理
}
}
public static bool WriteBusAllInfo(BusAllInfo info)
{
return true;
}
public static bool WriteBusAllInfo(BusAllInfo info)
{
return(true);
}