// 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(); } }
private void InitYuyueLimit(YuyueLimit entity) { this.cbKscc.SelectedValue = entity.KsccCode; this.cbKsdd.SelectedValue = entity.KsddCode; this.lbYkrq.Text = entity.Ksrq; this.cbKm.SelectedValue = entity.Km.ToString(); this.hidPaiBanId.Value = entity.Id.ToString(); this.lbSchoolName.Text = "非培训队报考人员"; }
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); } }
protected void ImageButton_Click(object sender, ImageClickEventArgs e) { ImageButton btn = sender as ImageButton; TableRow row = btn.Parent.Parent as TableRow; TableCell cell = btn.Parent as TableCell; int i = int.Parse(cell.ToolTip); int rownum = int.Parse(cell.CssClass); if (btn.ToolTip == "重新分配") { // row. row.Cells[i + 2].Text = ""; ArrayList limits = ViewState[VIEWSTATUE_LIMITS] as ArrayList; ArrayList removeLimits = new ArrayList(); foreach (object obj in limits) { YuyueLimit limit = obj as YuyueLimit; int km = (i + 2) / 2; int datyOfWeek = rownum - 1; if (limit.DayOfWeek == datyOfWeek && limit.Km == km) { removeLimits.Add(obj); } } foreach (object obj in removeLimits) { limits.Remove(obj); } ViewState[VIEWSTATUE_LIMITS] = limits; //row.Cells[i + 2].Controls.Clear(); //string s = ""; } if (btn.ToolTip == "添加分配") { //int count=row.Cells[i + 2].Controls.Count; if (this.hidRowOld.Value != "-1" && this.hidColOld.Value != "-1") { int j = int.Parse(this.hidColOld.Value); int m = int.Parse(this.hidRowOld.Value); this.Table1.Rows[m].Cells[j + 2].BackColor = System.Drawing.Color.White; } this.hidColNew.Value = i.ToString(); this.hidRowNew.Value = rownum.ToString(); this.hidColOld.Value = i.ToString(); this.hidRowOld.Value = rownum.ToString(); if (this.hidColNew.Value != "-1") { int k = int.Parse(this.hidColNew.Value); row.Cells[k + 2].BackColor = System.Drawing.Color.Red; } } }
private static String genLimitKey(YuyueLimit limit) { String key = ""; key = string.Format("{0}::{1}::{2}::{3}::{4}::{5}", limit.WeekNum , limit.DayOfWeek , limit.Km , limit.KsccCode , limit.KsddCode , limit.SchoolCode ); return(key); }
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); } } }
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); } }
public static void Save(WeekRecord week, int dayofweek, int km, string begindate, string desc) { if (desc == null || desc.Length == 0) { return; } int weeknum = week.WeekNum; DateTime begin = DateTime.Parse(begindate); ArrayList lists = new ArrayList(); string[] array1 = desc.Trim("<br/>".ToCharArray()).Split(new string[] { "<br/>" }, StringSplitOptions.RemoveEmptyEntries); string[] array2 = null; string[] array3 = null; YuyueLimit limit; for (int i = 0; i < array1.Length; i++) { limit = new YuyueLimit(); limit.WeekNum = weeknum; limit.Operator = week.CheckOperator; limit.Ksrq = begin.AddDays(dayofweek - 1).ToString("yyyy-MM-dd"); limit.DayOfWeek = dayofweek; array2 = array1[i].Split(';'); array3 = array2[0].Split(':'); limit.KsddCode = array3[0]; limit.Ksdd = array3[1]; array3 = array2[1].Split(':'); limit.KsccCode = array3[0]; limit.Kscc = array3[1]; array3 = array2[2].Split(':'); limit.SchoolCode = array3[0]; limit.SchoolName = array3[1]; limit.Km = km; limit.Total = Int32.Parse(array2[3]); SimpleOrmOperator.Create(limit); } // SimpleOrmOperator.Delete<YuyueLimit>(id); }
public static void Save(WeekRecord week,int dayofweek,int km,string begindate,string desc) { if (desc == null || desc.Length == 0) { return; } int weeknum = week.WeekNum; DateTime begin = DateTime.Parse(begindate); ArrayList lists = new ArrayList(); string[] array1 = desc.Trim("<br/>".ToCharArray()).Split(new string[]{"<br/>"},StringSplitOptions.RemoveEmptyEntries); string[] array2 = null; string[] array3 = null; YuyueLimit limit; for (int i = 0; i < array1.Length; i++) { limit = new YuyueLimit(); limit.WeekNum = weeknum; limit.Operator = week.CheckOperator; limit.Ksrq = begin.AddDays(dayofweek-1).ToString("yyyy-MM-dd"); limit.DayOfWeek = dayofweek; array2 = array1[i].Split(';'); array3 = array2[0].Split(':'); limit.KsddCode = array3[0]; limit.Ksdd = array3[1]; array3 = array2[1].Split(':'); limit.KsccCode = array3[0]; limit.Kscc = array3[1]; array3 = array2[2].Split(':'); limit.SchoolCode = array3[0]; limit.SchoolName = array3[1]; limit.Km = km; limit.Total =Int32.Parse(array2[3]); SimpleOrmOperator.Create(limit); } // SimpleOrmOperator.Delete<YuyueLimit>(id); }
private void InitYuyueLimit(YuyueLimit entity) { this.cbKscc.SelectedValue = entity.KsccCode; this.cbKsdd.SelectedValue = entity.KsddCode; this.lbYkrq.Text = entity.Ksrq; this.cbKm.SelectedValue = entity.Km.ToString(); this.hidPaiBanId.Value = entity.Id.ToString(); this.lbSchoolName.Text = this.Operator.Desp4; 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(); } }
protected void lbtn_Click(object sender, EventArgs e) { if (this.hidRowOld.Value != "-1" && this.hidColOld.Value != "-1") { int j = int.Parse(this.hidColOld.Value); int m = int.Parse(this.hidRowOld.Value); if (this.GetSl(this.txtNum) > 0) { // this.Table1.Rows[m].Cells[j + 2].Text += "<br/>" + this.cbKsdd.SelectedItem.Value + ":" + // this.cbKsdd.SelectedItem.Text + ";" + this.cbKscc.SelectedItem.Value // + ":" + this.cbKscc.SelectedItem.Text + ";" // + this.cbSchool.SelectedItem.Value + ":" + this.cbSchool.SelectedItem.Text + ";" + this.txtNum.Text.Trim(); string context = string.Format("<br/>{0}({1})", this.cbSchool.SelectedItem.Text, this.txtNum.Text.Trim()); this.Table1.Rows[m].Cells[j + 2].Text += context; int km = (j + 2) / 2; int datyOfWeek = m - 1; WeekRecord weekRecord = ViewState[VIEWSTATUE_WEEKRECORD] as WeekRecord; ArrayList limits = ViewState[VIEWSTATUE_LIMITS] as ArrayList; YuyueLimit tempLimit = new YuyueLimit(); tempLimit.DayOfWeek = datyOfWeek; tempLimit.Km = km; tempLimit.WeekNum = weekRecord.WeekNum; tempLimit.Ksdd = this.cbKsdd.SelectedItem.Text; tempLimit.KsddCode = this.cbKsdd.SelectedItem.Value; tempLimit.Kscc = this.cbKscc.SelectedItem.Text; tempLimit.KsccCode = this.cbKscc.SelectedItem.Value; tempLimit.SchoolName = this.cbSchool.SelectedItem.Text; tempLimit.SchoolCode = this.cbSchool.SelectedItem.Value; tempLimit.Total = int.Parse(this.txtNum.Text.Trim()); limits.Add(tempLimit); ViewState[VIEWSTATUE_LIMITS] = limits; } else { WebTools.Alert("分配的数量不得为0!"); } } }
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; } }
private static String genLimitKey(YuyueLimit limit) { String key = ""; key = string.Format("{0}::{1}::{2}::{3}::{4}::{5}", limit.WeekNum ,limit.DayOfWeek ,limit.Km ,limit.KsccCode ,limit.KsddCode ,limit.SchoolCode ); return key; }
public static void Update(YuyueLimit limit) { SimpleOrmOperator.Update(limit); }
public static bool Save(WeekRecord week, YuyueLimit limit,DateTime beginDate) { limit.Operator = week.CheckOperator; limit.Ksrq = beginDate.AddDays(limit.DayOfWeek - 1).ToString("yyyy-MM-dd"); return SimpleOrmOperator.Create(limit); }
protected void lbtn_Click(object sender, EventArgs e) { if (this.hidRowOld.Value != "-1" && this.hidColOld.Value != "-1") { int j = int.Parse(this.hidColOld.Value); int m = int.Parse(this.hidRowOld.Value); if (this.GetSl(this.txtNum) > 0) { // this.Table1.Rows[m].Cells[j + 2].Text += "<br/>" + this.cbKsdd.SelectedItem.Value + ":" + // this.cbKsdd.SelectedItem.Text + ";" + this.cbKscc.SelectedItem.Value // + ":" + this.cbKscc.SelectedItem.Text + ";" // + this.cbSchool.SelectedItem.Value + ":" + this.cbSchool.SelectedItem.Text + ";" + this.txtNum.Text.Trim(); string context = string.Format("<br/>{0}({1})",this.cbSchool.SelectedItem.Text,this.txtNum.Text.Trim()); this.Table1.Rows[m].Cells[j + 2].Text += context; int km=(j+2)/2; int datyOfWeek=m-1; WeekRecord weekRecord=ViewState[VIEWSTATUE_WEEKRECORD] as WeekRecord; ArrayList limits = ViewState[VIEWSTATUE_LIMITS] as ArrayList; YuyueLimit tempLimit = new YuyueLimit(); tempLimit.DayOfWeek = datyOfWeek; tempLimit.Km = km; tempLimit.WeekNum = weekRecord.WeekNum; tempLimit.Ksdd = this.cbKsdd.SelectedItem.Text; tempLimit.KsddCode =this.cbKsdd.SelectedItem.Value; tempLimit.Kscc = this.cbKscc.SelectedItem.Text; tempLimit.KsccCode = this.cbKscc.SelectedItem.Value; tempLimit.SchoolName = this.cbSchool.SelectedItem.Text; tempLimit.SchoolCode = this.cbSchool.SelectedItem.Value; tempLimit.Total = int.Parse(this.txtNum.Text.Trim()); limits.Add(tempLimit); ViewState[VIEWSTATUE_LIMITS] = limits; } else { WebTools.Alert("分配的数量不得为0!"); } } }
public static bool Save(WeekRecord week, YuyueLimit limit, DateTime beginDate) { limit.Operator = week.CheckOperator; limit.Ksrq = beginDate.AddDays(limit.DayOfWeek - 1).ToString("yyyy-MM-dd"); return(SimpleOrmOperator.Create(limit)); }
private void InitYuyueLimit(YuyueLimit entity) { this.cbKscc.SelectedValue = entity.KsccCode; this.cbKsdd.SelectedValue = entity.KsddCode; this.lbYkrq.Text = entity.Ksrq; this.cbKm.SelectedValue = entity.Km.ToString(); this.hidPaiBanId.Value = entity.Id.ToString(); this.lbSchoolName.Text = this.Operator.Desp4; 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(); } }