public static void Create(WeekRecord week)
{
SimpleOrmOperator.Create(week);
string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至'));
DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr));
YuyueLimitOperator.Save(week, 1, 1, datestr, week.Week1km1fp);
YuyueLimitOperator.Save(week, 1, 2, datestr, week.Week1km2fp);
YuyueLimitOperator.Save(week, 1, 3, datestr, week.Week1km3fp);
YuyueLimitOperator.Save(week, 2, 1, datestr, week.Week2km1fp);
YuyueLimitOperator.Save(week, 2, 2, datestr, week.Week2km2fp);
YuyueLimitOperator.Save(week, 2, 3, datestr, week.Week2km3fp);
YuyueLimitOperator.Save(week, 3, 1, datestr, week.Week3km1fp);
YuyueLimitOperator.Save(week, 3, 2, datestr, week.Week3km2fp);
YuyueLimitOperator.Save(week, 3, 3, datestr, week.Week3km3fp);
YuyueLimitOperator.Save(week, 4, 1, datestr, week.Week4km1fp);
YuyueLimitOperator.Save(week, 4, 2, datestr, week.Week4km2fp);
YuyueLimitOperator.Save(week, 4, 3, datestr, week.Week4km3fp);
YuyueLimitOperator.Save(week, 5, 1, datestr, week.Week5km1fp);
YuyueLimitOperator.Save(week, 5, 2, datestr, week.Week5km2fp);
YuyueLimitOperator.Save(week, 5, 3, datestr, week.Week5km3fp);
YuyueLimitOperator.Save(week, 6, 1, datestr, week.Week6km1fp);
YuyueLimitOperator.Save(week, 6, 2, datestr, week.Week6km2fp);
YuyueLimitOperator.Save(week, 6, 3, datestr, week.Week6km3fp);
YuyueLimitOperator.Save(week, 7, 1, datestr, week.Week7km1fp);
YuyueLimitOperator.Save(week, 7, 2, datestr, week.Week7km2fp);
YuyueLimitOperator.Save(week, 7, 3, datestr, week.Week7km3fp);
}
// private YuyueLimit yuyueLimit;
private void ReBind()
{
YuyueLimit entity = YuyueLimitOperator.Get(Convert.ToInt32(this.hidPaiBanId.Value));
string sql = "select id,c_lsh,c_idcard,c_xm,date_pxshrq,c_hmhp,c_jbr,decode(i_checked,0,'未审核',1,'已审核',2,'审核不过') i_checked,c_check_result from table_yuyue_info"
+ " where (i_checked<>2 or i_checked is null) and i_paibanid=" + entity.Id;
dt = DataAccessFactory.GetDataAccess().SelectDataTable(sql, "tmp");
if (dt != null)
{
this.trueNum = dt.Rows.Count;
}
else
{
dt = MockDataTable();
this.trueNum = 0;
}
int num = entity.Total + entity.TpTotal - trueNum;
for (int i = 0; i < num; i++)
{
dt.Rows.Add(dt.NewRow());
}
this.DataGrid1.DataSource = dt;
this.DataGrid1.DataBind();
sql = "select id,c_lsh,c_idcard,c_xm,date_pxshrq,c_hmhp,c_jbr,decode(i_checked,0,'未审核',1,'已审核',2,'审核不过') i_checked,c_check_result from table_yuyue_info"
+ " where i_checked=2 and i_paibanid=" + entity.Id;
dt = DataAccessFactory.GetDataAccess().SelectDataTable(sql, "tmp");
if (dt != null)
{
this.DataGrid2.DataSource = dt;
this.DataGrid2.DataBind();
}
}
public static void Create(WeekRecord week, ArrayList limits)
{
SimpleOrmOperator.Create(week);
string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至'));
DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr));
foreach (object obj in limits)
{
YuyueLimit limit = obj as YuyueLimit;
YuyueLimitOperator.Save(week, limit, begin);
}
}
public static void Update(WeekRecord week, ArrayList limits)
{
SimpleOrmOperator.Update(week);
string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至'));
DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr));
string deleteSql = "delete from table_yuyue_limit where i_week_num=" + week.WeekNum + " and date_ksrq like '" + begin.Year.ToString() + "%'";
DataAccessFactory.GetDataAccess().ExecuteSql(deleteSql);
foreach (object obj in limits)
{
YuyueLimit limit = obj as YuyueLimit;
YuyueLimitOperator.Save(week, limit, begin);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DictOperator.BindDropDownList("考试地点", this.cbKsdd);
DictOperator.BindDropDownList("考试场次", this.cbKscc);
// SchoolCarInfoOperator.Bind(this.cbCarNo, this.Operator.Desp3);
if (Request.Params["id"] != null)
{
YuyueLimit entity = YuyueLimitOperator.Get(Convert.ToInt32(Request.Params["id"]));
//this.yuyueLimit = entity;
this.InitYuyueLimit(entity);
}
}
}
protected void DataGrid1_ItemCommand1(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "Tp")
{
int tp = 0;
try
{
tp = Convert.ToInt32(this.txtNum.Text.Trim());
}
catch (Exception ex)
{
WebTools.Alert(this, "特批数量必须是整数！");
return;
}
int id = Convert.ToInt32(e.CommandArgument);
YuyueLimit limit = YuyueLimitOperator.Get(id);
limit.TpTotal = tp;
YuyueLimitOperator.Update(limit);
WebTools.Alert(this, "特批成功！");
this.ProcedurePager1.Changed = true;
}
}
public static void Update(WeekRecord week)
{
SimpleOrmOperator.Update(week);
string datestr = week.WeekRange.Substring(0, week.WeekRange.IndexOf('至'));
DateTime begin = DateTimeHelper.GetMonday(DateTime.Parse(datestr));
DataAccessFactory.GetDataAccess().ExecuteSql("delete from table_yuyue_limit where i_week_num=" + week.WeekNum + " and date_ksrq like '" + begin.Year.ToString() + "%'");
YuyueLimitOperator.Save(week, 1, 1, datestr, week.Week1km1fp);
YuyueLimitOperator.Save(week, 1, 2, datestr, week.Week1km2fp);
YuyueLimitOperator.Save(week, 1, 3, datestr, week.Week1km3fp);
YuyueLimitOperator.Save(week, 2, 1, datestr, week.Week2km1fp);
YuyueLimitOperator.Save(week, 2, 2, datestr, week.Week2km2fp);
YuyueLimitOperator.Save(week, 2, 3, datestr, week.Week2km3fp);
YuyueLimitOperator.Save(week, 3, 1, datestr, week.Week3km1fp);
YuyueLimitOperator.Save(week, 3, 2, datestr, week.Week3km2fp);
YuyueLimitOperator.Save(week, 3, 3, datestr, week.Week3km3fp);
YuyueLimitOperator.Save(week, 4, 1, datestr, week.Week4km1fp);
YuyueLimitOperator.Save(week, 4, 2, datestr, week.Week4km2fp);
YuyueLimitOperator.Save(week, 4, 3, datestr, week.Week4km3fp);
YuyueLimitOperator.Save(week, 5, 1, datestr, week.Week5km1fp);
YuyueLimitOperator.Save(week, 5, 2, datestr, week.Week5km2fp);
YuyueLimitOperator.Save(week, 5, 3, datestr, week.Week5km3fp);
YuyueLimitOperator.Save(week, 6, 1, datestr, week.Week6km1fp);
YuyueLimitOperator.Save(week, 6, 2, datestr, week.Week6km2fp);
YuyueLimitOperator.Save(week, 6, 3, datestr, week.Week6km3fp);
YuyueLimitOperator.Save(week, 7, 1, datestr, week.Week7km1fp);
YuyueLimitOperator.Save(week, 7, 2, datestr, week.Week7km2fp);
YuyueLimitOperator.Save(week, 7, 3, datestr, week.Week7km3fp);
}
