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); }