protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DepartMentOperator.Bind2(ddlSchoolCode);
ddlSchoolCode.Items.Insert(0, new ListItem("全部", "all"));
DictOperator.BindDropDownList("车辆类型", ddlCarType);
ddlCarType.Items.Insert(0, new ListItem("全部", "all"));
ArrayList localtypes = SimpleOrmOperator.QueryConditionList <FpLocalType>("where km3_verify_ind='Y'");
string localtypeArray = "";
foreach (FpLocalType localtype in localtypes)
{
localtypeArray += localtype.ID;
localtypeArray += ",";
}
string condition = " statue<={0} and localtype in ({1}) ";
condition = string.Format(condition, FpStudentObject.STATUE_TRAIN_END, localtypeArray.TrimEnd(','));
condition += " and km3_verify !='Y' ";
this.ProcedurePager1.TableName = "fp_student";
this.ProcedurePager1.FieldString = @" lsh,idcard ,name ,school_name,car_type ".Replace("\r\n", "").Replace("\t", "");
this.ProcedurePager1.SortString = " order by lsh asc";
this.ProcedurePager1.RowFilter = condition;
//WebTools.Alert(condition);
this.txtQueryValue.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
this._FP = new FpBase(this, new EventHandler(TrustLink_OperDlgPostEvent));
if (!IsPostBack)
{
ArrayList listLoacaltype = SimpleOrmOperator.QueryConditionList <FpLocalType>("");
ddlLocaltype.DataSource = listLoacaltype;
ddlLocaltype.DataTextField = "NAME";
ddlLocaltype.DataValueField = "ID";
ddlLocaltype.DataBind();
DepartMentOperator.Bind2(ddlSchool);
ddlSchool.SelectedValue = "440400";
DictOperator.BindDropDownList("车辆类型", ddlCarType);
string strTmp = Request.Params["strTmp"];
if (!string.IsNullOrEmpty(strTmp))
{
int result = wsFingerM.wsFPEnroll(strTmp);
this.fnUINewEnrollStudentSucess(result == FpBase.SUCCESSED);
}
}
///WebTools.PlaySound("../../sound/test1.wav");
//WebTools.PlayBackGroupSound("孙燕姿-02.追.是时候.mp3", 1);
//Response.Write("<bgsound loop=1 src='孙燕姿-02.追.是时候.mp3' />");
//WebTools.WriteScript("alert('hhlin');");
//WebTools.PlaySound("孙燕姿-02.追.是时候.mp3");
// BeepHelper.Beep(800,8000);
}
public DataTable DgBind()
{
DataTable table = null;
string depName = this.txtDepName.Text;
table = DepartMentOperator.Search(depName);
return(table);
}
protected void DataGrid1_ItemCommand1(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument);
DepartMentOperator.Delete(id);
WebTools.Alert(this, "删除成功！");
this.SimplePager1.Changed = true;
}
else if (e.CommandName == "Detail")
{
int id = Convert.ToInt32(e.CommandArgument);
this.Pop(id);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
qDateStart.Value = DateTime.Now.ToString("yyyy-MM-dd");
qDateEnd.Value = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
DepartMentOperator.Bind2(ddlSchoolCode);
ddlSchoolCode.Items.Insert(0, new ListItem("全部", "all"));
DictOperator.BindDropDownList("车辆类型", ddlCarType);
ddlCarType.Items.Insert(0, new ListItem("全部", "all"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DictOperator.BindDropDownList("考试地点", this.cbKsdd);
DictOperator.BindDropDownList("考试场次", this.cbKscc);
DepartMentOperator.Bind(this.cbSchool, "驾校");
DictOperator.BindDropDownList("考试科目", this.cbKm);
this.ProcedurePager1.TableName = "table_yuyue_info";
this.ProcedurePager1.FieldString = @"id,c_lsh,date_ksrq,c_kscc,c_ksdd,i_km,c_idcard,
c_xm,date_pxshrq,c_hmhp,c_jbr,
decode(i_checked,0,'未审核',1,'已审核',2,'审核不过') i_checked,
c_check_result
" .Replace("\r\n", "").Replace("\t", "");
this.ProcedurePager1.SortString = " order by id desc";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DepartMentOperator.Bind(this.cbDepCodeValue, "驾校");
if (Request.Params["id"] != null)
{
SchoolCarInfo entity = SimpleOrmOperator.Query <SchoolCarInfo>(Convert.ToInt32(Request.Params["id"]));
WebFormHelper.SetDataToForm(this, entity);
}
if (!string.IsNullOrEmpty(Request.Params["depId"]))
{
int depId = this.Operator.DeptId;
DepartMent dep = SimpleOrmOperator.Query <DepartMent>(depId);
cbDepCodeValue.SelectedValue = dep.DepCode;
cbDepCodeValue.Enabled = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.ProcedurePager1.AllowBinded = true;
this.ProcedurePager1.TableName = "table_student_apply_info_c";
this.ProcedurePager1.FieldString = @"id,c_lsh,sfzmhm,c_xm,c_jxmc,
decode(i_checked,0,'未审核',1,'已审核',2,'审核不过') as i_checked,
c_check_result,c_check_operator,
decode(i_photo_syn,0,'未同步',1,'已同步',2,'同步失败') as i_photo_syn
".Replace("\r\n", "").Replace("\t", "");
this.ProcedurePager1.RowFilter = " i_checked=0 ";
this.ProcedurePager1.SortString = " order by id desc";
DepartMentOperator.BindNick(cbJxdm, "驾校");
cbJxdm.Items.Add(new ListItem("全部", ""));
cbJxdm.SelectedIndex = cbJxdm.Items.Count - 1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
this._FP = new FpBase(this, null, false);
if (!IsPostBack)
{
DepartMentOperator.Bind2(ddlSchoolCode);
ddlSchoolCode.Items.Insert(0, new ListItem("全部", "all"));
DictOperator.BindDropDownList("车辆类型", ddlCarType);
ddlCarType.Items.Insert(0, new ListItem("全部", "all"));
this.ProcedurePager1.TableName = "fp_student";
this.ProcedurePager1.FieldString = @" lsh,idcard ,name ,school_name,car_type ".Replace("\r\n", "").Replace("\t", "");
this.ProcedurePager1.SortString = " order by idcard desc";
if (cbFinish.Checked)
{
string condition = " statue>={0}";
this.ProcedurePager1.RowFilter = string.Format(condition, FpStudentObject.STATUE_KM3_ENTER);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// ViewState
DictOperator.BindDropDownList("考试地点", this.cbKsdd);
DictOperator.BindDropDownList("考试场次", this.cbKscc);
DepartMentOperator.BindNick(this.cbSchool, "驾校");
this.InitTableControls();
if (Request.Params["id"] != null)
{
WeekRecord entity = WeekRecordOperator.Get(Convert.ToInt32(Request.Params["id"]));
//weekRocord = WeekRecordOperator.Get(Convert.ToInt32(Request.Params["id"]));
this.InitWeekRecord(entity);
string querySql = string.Format("where I_WEEK_NUM={0}", entity.WeekNum);
ArrayList listLimits = SimpleOrmOperator.QueryConditionList <YuyueLimit>(querySql);
ViewState[VIEWSTATUE_LIMITS] = listLimits;
ViewState[VIEWSTATUE_WEEKRECORD] = entity;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DepartMentOperator.Bind2(ddlSchoolCode);
ddlSchoolCode.Items.Insert(0, new ListItem("全部", "all"));
DictOperator.BindDropDownList("车辆类型", ddlCarType);
ddlCarType.Items.Insert(0, new ListItem("全部", "all"));
string condition = " statue<{0} and lsh is not null ";
condition = string.Format(condition, FpStudentObject.STATUE_LESSON_START);
condition += " and fee_statue != 'Y' ";
this.ProcedurePager1.TableName = "fp_student";
this.ProcedurePager1.FieldString = @" lsh,idcard ,name ,school_name,car_type,fee_verify_date ".Replace("\r\n", "").Replace("\t", "");
this.ProcedurePager1.SortString = " order by lsh asc";
this.ProcedurePager1.RowFilter = condition;
this.btnBatchVerify.Attributes.Add("onclick", "return confirm('确认进行批量审核?');");
this.btnBatchDisVerify.Attributes.Add("onclick", "return confirm('确认进行批量取消审核?');");
}
this.txtQueryValue.Focus();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RoleOperator.Bind(this.cbRoleIdValue);
DepartMentOperator.Bind(this.cbDepIdValue);
if (Request.Params["id"] != null)
{
UserObject dep = SimpleOrmOperator.Query <UserObject>(Convert.ToInt32(Request.Params["id"]));
WebFormHelper.SetDataToForm(this, dep);
string[] ips = dep.BeginIp.Split('.');
this.txtBeginIp1.Text = ips[0].ToString();
this.txtBeginIp2.Text = ips[1].ToString();
this.txtBeginIp3.Text = ips[2].ToString();
this.txtBeginIp4.Text = ips[3].ToString();
ips = dep.EndIp.Split('.');
this.txtEndIp1.Text = ips[0].ToString();
this.txtEndIp2.Text = ips[1].ToString();
this.txtEndIp3.Text = ips[2].ToString();
this.txtEndIp4.Text = ips[3].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this._FP = new FpBase(this, new EventHandler(TrustLink_OperDlgPostEvent));
_FP.isSa = true;
if (!IsPostBack)
{
ArrayList listLoacaltype = SimpleOrmOperator.QueryConditionList <FpLocalType>("");
ddlLocaltype.DataSource = listLoacaltype;
ddlLocaltype.DataTextField = "NAME";
ddlLocaltype.DataValueField = "ID";
ddlLocaltype.DataBind();
DepartMentOperator.Bind2(ddlSchool);
ddlSchool.SelectedValue = "440400";
DictOperator.BindDropDownList("车辆类型", ddlCarType);
}
///WebTools.PlaySound("../../sound/test1.wav");
//WebTools.PlayBackGroupSound("孙燕姿-02.追.是时候.mp3", 1);
//Response.Write("<bgsound loop=1 src='孙燕姿-02.追.是时候.mp3' />");
//WebTools.WriteScript("alert('hhlin');");
//WebTools.PlaySound("孙燕姿-02.追.是时候.mp3");
// BeepHelper.Beep(800,8000);
}