/// <summary> /// 恢复IC卡 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnHF_Click(object sender, ImageClickEventArgs e) { try { if (string.IsNullOrEmpty(this.hidCValue.Value)) { this.PrintfError("没有选择要修改的纪录!"); return; } string icflag = ICParam.GetFlag(this.hidCValue.Value); if (icflag == "使用") { this.PrintfError("此卡是使用状态,不必恢复!"); return; } else { ACCTRUE.WMSBLL.Model.User user = (ACCTRUE.WMSBLL.Model.User)(Session[Config.Curren_User]); ICParam parm = new ICParam(); parm.Update(this.hidCValue.Value, "使用", DBNull.Value.ToString(), DateTime.MinValue); InitICPassHid(); BindICByEnter(); } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); return; } }
/// <summary> /// 挂失IC卡 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnGS_Click(object sender, ImageClickEventArgs e) { try { if (string.IsNullOrEmpty(this.hidCValue.Value)) { this.PrintfError("没有选择要修改的纪录!"); return; } string icflag = ICParam.GetFlag(this.hidCValue.Value); if (icflag == "挂失") { this.PrintfError("此卡是挂失状态,不能重复挂失!"); return; } else { ACCTRUE.WMSBLL.Model.User user = (ACCTRUE.WMSBLL.Model.User)(Session[Config.Curren_User]); ICParam parm = new ICParam(this.hidCValue.Value, this.hidCValue.Value, "", "", this.txtKHName.Text, "挂失", this.txtCPH.Text, "", DateTime.Now, user.UserID, DateTime.Now, ""); parm.Update(this.hidCValue.Value, "挂失", user.UserID, DateTime.Now); InitICPassHid(); BindICByEnter(); } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); return; } }
/// <summary> /// 退卡 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnTK_Click(object sender, ImageClickEventArgs e) { try { if (string.IsNullOrEmpty(this.hidCValue.Value)) { this.PrintfError("没有选择要修改的纪录!"); this.txtICID.Text = ""; this.txtKHName.Text = ""; this.hidCValue.Value = ""; return; } ACCTRUE.WMSBLL.Model.User user = (ACCTRUE.WMSBLL.Model.User)(Session[Config.Curren_User]); ICParam parm = new ICParam(this.hidCValue.Value, "", "", "", "", "", "", "", DateTime.Now, "", DateTime.Now, ""); parm.Delete(); this.txtICID.Text = ""; this.txtKHName.Text = ""; this.hidCValue.Value = ""; //BindICParam(); BindICByEnter(); } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); return; } }
private void BindGrid() { try { DataSet ds = ICParam.GetKHInfo(GetSqlWhere()); this.grvKHList.DataSource = ds; this.grvKHList.DataBind(); } catch { this.PrintfError("数据访问错误,请重试!"); return; } }
/// <summary> /// 调用导出Excel方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExpToExcel_Click(object sender, ImageClickEventArgs e) { try { ICParam icpara = new ICParam(this.hidSICID.Value, "", "", "", this.hidSKHName.Value, "", this.hidSCPH.Value, "", DateTime.MinValue, "", DateTime.MinValue, this.hidSProposer.Value); DataSet ds = icpara.GetxlsDS(); this.CreateExcel(ds.Tables[0], "IC.xls", ds.Tables[0].Rows.Count); } catch { this.PrintfError("数据访问错误,请重试!"); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (string.IsNullOrEmpty(Request["TYPE"])) { return; } string icNum = Request["ICNUM"]; string icPass = Request["ICPASS"]; ICParam par = new ICParam(); par.ChangeICPass(icNum, icPass); } }
//#region 规定页面加载时显示近几个月内发放的IC卡 ///// <summary> ///// 规定页面加载时显示近几个月内发放的IC卡 ///// </summary> ///// <param name="date"></param> ///// <returns></returns> //public static string GetBeginTime(System.DateTime date) //{ // int monthInterval = 0; // try // { // monthInterval = 12;//规定页面加载时显示近12个月内发放的IC卡 // } // catch (Exception e) // { // e.ToString(); // } // return date.AddMonths(monthInterval * (-1)).ToString("yyyy-MM-dd"); //} //public static string GetBeginTime() //{ // return GetBeginTime(DateTime.Now); //} //#endregion protected void grdInfo_PageIndexChanging(object sender, GridViewPageEventArgs e) { grdInfo.PageIndex = e.NewPageIndex; string sqlWhere = GetSqlWhereSort(); if (string.IsNullOrEmpty(this.hidStrSort.Value)) { sqlWhere += " order by FK_Time desc"; } else { sqlWhere += this.hidStrSort.Value; } DataSet ds = ICParam.GetDataSetsort(sqlWhere); this.grdInfo.DataSource = ds; this.grdInfo.DataBind(); }
protected void btnOK_Click(object sender, EventArgs e) { try { if (this.txtPassword.Text == "1") { this.lblResult.ForeColor = Color.Red; this.lblResult.Text = "修改口令失败:口令不能为初始值!"; return; } ICParam parm = new ICParam(); parm.ChangeICPass(this.lblICNum.Text, this.txtPassword.Text); this.lblResult.ForeColor = Color.Red; this.lblResult.Text = "修改口令成功!"; } catch { this.lblResult.ForeColor = Color.Red; this.lblResult.Text = "修改口令失败:数据访问失败!"; } }
/// <summary> /// 绑定查询申请人下拉列表 /// </summary> private void BindSearchProposer() { try { DataSet ds = ICParam.GetSearchProposer(""); if (ds != null) { this.DDlistSearchProposer.DataSource = ds; this.DDlistSearchProposer.DataTextField = "UserDesc"; this.DDlistSearchProposer.ToolTip = "申请人"; this.DDlistSearchProposer.DataValueField = "Proposer"; this.DDlistSearchProposer.DataBind(); this.DDlistSearchProposer.Items.Insert(0, "请选择"); } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); return; } }
protected void imgCZ_Click(object sender, ImageClickEventArgs e) { try { if (string.IsNullOrEmpty(this.hidCValue.Value)) { this.PrintfError("没有选择要重置的纪录!"); return; } ACCTRUE.WMSBLL.Model.User user = (ACCTRUE.WMSBLL.Model.User)(Session[Config.Curren_User]); ICParam parm = new ICParam(); parm.UpdatePass(this.hidCValue.Value, "1", DBNull.Value.ToString(), DateTime.Now); InitICPassHid(); BindICByEnter(); } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); return; } }
protected void grdInfo_Sorting(object sender, GridViewSortEventArgs e) { if (string.IsNullOrEmpty(this.hidsort.Value)) { this.hidsort.Value = "DESC"; } else { if (this.hidsort.Value.Trim() == "DESC") { this.hidsort.Value = "ASC"; } else { this.hidsort.Value = "DESC"; } } string sortField = e.SortExpression.ToString(); string strSort = " order by " + sortField + " " + this.hidsort.Value; this.hidStrSort.Value = strSort; string sqlWhere = GetSqlWhereSort(); sqlWhere += strSort; DataSet ds = ICParam.GetDataSetsort(sqlWhere); int ICsum = 0; foreach (DataRow dr in ds.Tables[0].Rows) { ICsum += 1; } this.lblICsum.Text = ICsum.ToString(); this.grdInfo.DataSource = ds; this.grdInfo.DataBind(); }
/// <summary> /// 绑定查询车牌号下拉列表 /// </summary> private void BindSearchCPH() { try { DataSet ds = ICParam.GetSearchCPH(""); if (ds != null) { this.DDlistSearchCPH.DataTextField = "CPH"; this.DDlistSearchCPH.DataValueField = "CPH"; this.DDlistSearchCPH.DataSource = ds; this.DDlistSearchCPH.ToolTip = "车牌号"; this.DDlistSearchCPH.DataBind(); } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); return; } }
/// <summary> /// 初始化页面时绑定IC管理主界面列表 /// </summary> private void BindICParam() { try { DataSet ds = ICParam.GetList(""); if (ds != null) { int ICsum = 0; foreach (DataRow dr in ds.Tables[0].Rows) { ICsum += 1; } this.lblICsum.Text = ICsum.ToString(); this.grdInfo.DataSource = ds; this.grdInfo.DataBind(); } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); } }
private void Bind() { string khbm = Request["khbm"]; string cph = Request["cph"]; if (khbm != "0") { string sql = " khbm = '" + khbm + "'"; ICParam icpara = new ICParam(); DataSet ds = icpara.GetListFYD(sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { this.grdInfo.DataSource = ds; this.grdInfo.DataBind(); } else { this.PrintfError("该IC卡没有发运单信息"); } } else { string sql = " cph = '" + cph + "'"; ICParam icpara = new ICParam(); DataSet ds = icpara.GetListFYD(sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { this.grdInfo.DataSource = ds; this.grdInfo.DataBind(); } else { this.PrintfError("该IC卡没有发运单信息"); } } }
/// <summary> /// 根据查询条件查询IC卡信息并绑定到主界面列表 /// </summary> private void BindICByEnter() { try { ICParam icpara = new ICParam(this.txtICIDSearch.Text, "", "", "", this.txtKHNameSearch.Text, "", this.DDlistSearchCPH.Text.Trim(), "", DateTime.MinValue, "", DateTime.MinValue, this.DDlistSearchProposer.SelectedValue); DataSet ds = icpara.GetICByEnter(); if (ds != null) { int ICsum = 0; foreach (DataRow dr in ds.Tables[0].Rows) { ICsum += 1; } this.lblICsum.Text = ICsum.ToString(); this.grdInfo.DataSource = ds; this.grdInfo.DataBind(); } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request["ICNUM"])) { this.lblICNum.Text = Request["ICNUM"]; ICParam parm = new ICParam(); DataSet ds = parm.GetICInforbyID(Request["ICNUM"]); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { this.PrintfError("不存在该IC卡!"); return; } else { this.lblICNum.Text = Request["ICNUM"]; this.lblName.Text = ds.Tables[0].Rows[0]["KHName"].ToString(); this.txtPassword.Text = ""; this.txtConfirm.Text = ""; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request["TYPE"])) { string type = Request["TYPE"]; switch (type) { case "1": //打印完工单 if (!string.IsNullOrEmpty(Request["QUERYSQL"])) { try { DataSet ds = WGDQuery.QueryWGDExcel(Request["QUERYSQL"]); string strPrin = this.DGPrint(ds.Tables[0]); Response.Write(strPrin); } catch { return; } } break; case "2": //打印IC卡信息 try { DataSet ds = ICParam.GetPrintDS(Request["QUERYSQL"]); string strPrin = this.DGPrint(ds.Tables[0]); Response.Write(strPrin); } catch { return; } break; case "3": //打印发运单(进出门管理的查看发运单模块) try { DataSet ds1 = InDoorParam.GetPrintDS(Request["QUERYSQL"]); string strPrin1 = this.DGPrint(ds1.Tables[0]); Response.Write(strPrin1); } catch { return; } break; case "4": //打印发运单(查询) break; case "5": //打印转库单(查询) try { DataSet ds = ZKDQuery.QueryZKDExcel(Request["QUERYSQL"]); string strPrin = this.DGPrint(ds.Tables[0]); Response.Write(strPrin); } catch { return; } break; case "6": //打印移位单(查询) try { DataSet ds = YWDQuery.QueryYWDExcel(Request["QUERYSQL"]); string strPrin = this.DGPrint(ds.Tables[0]); Response.Write(strPrin); } catch { return; } break; case "7": //打印退货单(查询) try { DataSet ds = THDQuery.QueryTHDExcel(Request["QUERYSQL"]); string strPrin = this.DGPrint(ds.Tables[0]); Response.Write(strPrin); } catch { return; } break; case "8": //打印待判品查询单(查询) try { DataSet ds = DPPQuery.QueryPDDExcel(Request["QUERYSQL"]); string strPrin = this.DGPrint(ds.Tables[0]); Response.Write(strPrin); } catch { return; } break; case "9": //打印入库账簿单(查询) try { DataSet ds = RKZBQuery.QueryRKZBExcel(Request["QUERYSQL"]); string strPrin = this.DGPrint(ds.Tables[0]); Response.Write(strPrin); } catch { return; } break; case "10": //打印出库账簿单(查询) try { DataSet ds = CKZBQuery.QueryCKZBExcel(Request["QUERYSQL"]); string strPrin = this.DGPrint(ds.Tables[0]); Response.Write(strPrin); } catch { return; } break; } } }
/// <summary> /// 保存发卡信息提交数据库保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveFK_Click(object sender, ImageClickEventArgs e) { try { if (string.IsNullOrEmpty(this.hidKHID.Value)) { this.PrintfError("请选择客户!"); return; } else if (string.IsNullOrEmpty(this.txtICID.Text) || string.IsNullOrEmpty(this.txtICNumber.Text)) { this.PrintfError("IC卡ID和卡号不能为空!"); return; } else if (ICParam.hasICID(this.txtICID.Text) == true) { this.PrintfError("本卡被重复使用!"); return; } else if ((this.hidKHLB.Value.Trim() == "0") && (string.IsNullOrEmpty(this.txtCPH.Text.Trim()) == true)) { this.PrintfError("邢钢内部车辆必须填写车牌号!"); return; } else if ((this.DDListProposer.SelectedValue == "请选择") || (string.IsNullOrEmpty(this.DDListProposer.SelectedValue))) { this.PrintfError("选择申请人!"); return; } else if (this.txtPassOne.Text.Trim() != this.txtPassTwo.Text.Trim()) { this.PrintfError("密码确认错误!"); return; } else { ACCTRUE.WMSBLL.Model.User user = (ACCTRUE.WMSBLL.Model.User)(Session[Config.Curren_User]); ICParam parm = new ICParam(this.txtICID.Text.Trim(), this.txtICNumber.Text.Trim(), this.txtPassOne.Text.Trim(), this.hidKHID.Value.ToString().Trim(), this.txtKHName.Text.Trim(), "使用", this.txtCPH.Text.Trim(), user.UserID, DateTime.Now, "", DateTime.MinValue, this.DDListProposer.SelectedValue); bool b = parm.Add(); if (b == false) { Response.Write("<script>window.alert('您修改过客户名!录入失败!')</script>"); return; } else { InitICPassHid(); BindICParam(); this.btnGS.Enabled = true; this.btnHF.Enabled = true; this.btnICFK.Enabled = true; this.btnTK.Enabled = true; this.btnPrint.Enabled = true; this.btnCheckFYD.Enabled = true; } } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); return; } }