protected void btn_change_pwd_Click(object sender, EventArgs e) { string oldpwd = Request.Form["oldpwd"]; string newpwd = Request.Form["newpwd"]; string name = Session["admin"].ToString(); string str = "select password from tb_staff where name='" + name + "'"; DataTable table = new DBOperateCommon().excuteQuery(str); if (table.Rows[0]["password"].ToString().Equals(oldpwd)) { string update = "update tb_staff set password='******' where name='" + name + "' and type=1"; if (new DBOperateCommon().excuteNoQuery(update)) { alert("修改成功!!"); } else { alert("修改失败!!"); } } else { alert("旧密码错误!!"); } }
protected void btn_add_staff_right_Click(object sender, EventArgs e) { string name = Request.Form["staffname"].ToString(); string password = Request.Form["password"].ToString(); string phone = Request.Form["staffphone"].ToString(); string email = Request.Form["staffemail"].ToString(); string type = Request.Form["type"].ToString(); string has = "select * from tb_staff where name='" + name + "' and type='" + type + "'"; DataTable table = new DBOperateCommon().excuteQuery(has); if (table.Rows.Count > 0) { alert("该员工已经存在,不能重复添加!!"); } else { string sql = "insert into tb_staff values('" + name + "','" + phone + "','" + email + "','" + password + "','" + type + "','" + DateTime.Now.ToString() + "')"; if (new DBOperateCommon().excuteNoQuery(sql)) { alert("添加成功!!!"); } else { alert("添加失败"); } } }
protected void btn_pf_rate_Click(object sender, EventArgs e) { string ratetype = rate_list.SelectedValue; string freights = Request.Form["freight"]; string[] freight_array = freights.Split(','); for (int i = 0; i < freight_array.Length; i++) { float money = Convert.ToSingle(freight_array[i].ToString()); string up_str = "update tb_rate_pf_gpr_delivery set " + ratetype + "=" + money + " where id=" + (i + 1); new DBOperateCommon().excuteNoQuery(up_str); } initRateArray(); string sql = "select " + ratetype + " from tb_rate_pf_gpr_delivery"; DataTable table = new DBOperateCommon().excuteQuery(sql); current_rate.Clear(); for (int i = 0; i < table.Rows.Count; i++) { current_rate.Add(Math.Round(Convert.ToSingle(table.Rows[i][0].ToString()), 2)); } }
/// <summary> /// 初始化 rate 数组列表 /// </summary> private void initRateArray() { rate1.Clear(); rate2.Clear(); rate3.Clear(); rate4.Clear(); rate5.Clear(); rate6.Clear(); rate7.Clear(); rate8.Clear(); rate9.Clear(); rate10.Clear(); string sql = "select * from tb_rate_ems"; DataTable table = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < table.Rows.Count; i++) { rate1.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate1"].ToString()), 2)); rate2.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate2"].ToString()), 2)); rate3.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate3"].ToString()), 2)); rate4.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate4"].ToString()), 2)); rate5.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate5"].ToString()), 2)); rate6.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate6"].ToString()), 2)); rate7.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate7"].ToString()), 2)); rate8.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate8"].ToString()), 2)); rate9.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate9"].ToString()), 2)); rate10.Add(Math.Round(Convert.ToSingle(table.Rows[i]["rate10"].ToString()), 2)); } }
/// <summary> /// 下拉列表事件响应 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void rate_list_SelectedIndexChanged(object sender, EventArgs e) { string type = rate_list.SelectedValue; string sql = "select " + type + " from tb_rate_pf_gpr_delivery"; DataTable table = new DBOperateCommon().excuteQuery(sql); current_rate.Clear(); for (int i = 0; i < table.Rows.Count; i++) { current_rate.Add(Math.Round(Convert.ToSingle(table.Rows[i][0].ToString()), 2)); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["admin"] == null && Session["manager"] == null) { Response.Redirect("../error-page.aspx"); } else { initRateArray(); string type = rate_list.SelectedValue; string sql = "select " + type + " from tb_rate_pf_gpr_delivery"; DataTable table = new DBOperateCommon().excuteQuery(sql); current_rate.Clear(); for (int i = 0; i < table.Rows.Count; i++) { current_rate.Add(Math.Round(Convert.ToSingle(table.Rows[i][0].ToString()), 2)); } } } }
protected void check_rate_Click(object sender, EventArgs e) { initArray(); string name = Request.Form["username"]; username = name; UserRate emsRate = new SetEMSRateForUserDAO().getUserRate(name); if (emsRate == null) { emsRate = new UserRate(); emsRate.Name = name; emsRate.Ratetype = "rate1"; } type.Add(emsRate.Ratetype); UserRate postnlRate = new SetPostNLRateForUserDAO().getUserRate(name); if (postnlRate == null) { postnlRate = new UserRate(); postnlRate.Name = name; postnlRate.Ratetype = "rate22"; } type.Add(postnlRate.Ratetype); UserRate pfgprcRate = new SetPFGPRCRateForUserDAO().getUserRate(name); if (pfgprcRate == null) { pfgprcRate = new UserRate(); pfgprcRate.Name = name; pfgprcRate.Ratetype = "rate1"; } type.Add(pfgprcRate.Ratetype); UserRate pfgprdRate = new SetPFGPRDRateForUserDAO().getUserRate(name); if (pfgprdRate == null) { pfgprdRate = new UserRate(); pfgprdRate.Name = name; pfgprdRate.Ratetype = "rate1"; } type.Add(pfgprdRate.Ratetype); UserRate pfipecRate = new SetPFIPECollectionRateForUserDAO().getUserRate(name); if (pfipecRate == null) { pfipecRate = new UserRate(); pfipecRate.Name = name; pfipecRate.Ratetype = "rate1"; } type.Add(pfipecRate.Ratetype); UserRate pfipedRate = new SetPFIPEDepotRateForUserDAO().getUserRate(name); if (pfipedRate == null) { pfipedRate = new UserRate(); pfipedRate.Name = name; pfipedRate.Ratetype = "rate1"; } type.Add(pfipedRate.Ratetype); UserRate pfipepRate = new SetPFIPEPolRateForUserDAO().getUserRate(name); if (pfipepRate == null) { pfipepRate = new UserRate(); pfipepRate.Name = name; pfipepRate.Ratetype = "rate1"; } type.Add(pfipepRate.Ratetype); UserRate pfipetRate = new SetPFIPETrailerRateForUserDAO().getUserRate(name); if (pfipetRate == null) { pfipetRate = new UserRate(); pfipetRate.Name = name; pfipetRate.Ratetype = "rate1"; } type.Add(pfipetRate.Ratetype); string sql = "select " + emsRate.Ratetype + " from tb_rate_ems"; DataTable emstable = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < emstable.Rows.Count; i++) { emsArray.Add(Math.Round(Convert.ToSingle(emstable.Rows[i][0].ToString()), 2)); } sql = "select " + postnlRate.Ratetype + " from tb_rate_postnl"; DataTable postnltable = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < postnltable.Rows.Count; i++) { postnlArray.Add(Math.Round(Convert.ToSingle(postnltable.Rows[i][0].ToString()), 2)); } sql = "select " + pfgprcRate.Ratetype + " from tb_rate_pf_gpr_collection"; DataTable pftable = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < pftable.Rows.Count; i++) { pfgprcArray.Add(Math.Round(Convert.ToSingle(pftable.Rows[i][0].ToString()), 2)); } sql = "select " + pfgprdRate.Ratetype + " from tb_rate_pf_gpr_delivery"; DataTable pfgprdtable = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < pfgprdtable.Rows.Count; i++) { pfgprdArray.Add(Math.Round(Convert.ToSingle(pfgprdtable.Rows[i][0].ToString()), 2)); } sql = "select " + pfipecRate.Ratetype + " from tb_rate_pf_ipe_Collection"; DataTable pfipectable = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < pfipectable.Rows.Count; i++) { pfipecArray.Add(Math.Round(Convert.ToSingle(pfipectable.Rows[i][0].ToString()), 2)); } sql = "select " + pfgprdRate.Ratetype + " from tb_rate_pf_ipe_depot"; DataTable pfipedtable = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < pfipedtable.Rows.Count; i++) { pfipedArray.Add(Math.Round(Convert.ToSingle(pfipedtable.Rows[i][0].ToString()), 2)); } sql = "select " + pfgprdRate.Ratetype + " from tb_rate_pf_ipe_pol"; DataTable pfipeptable = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < pfipeptable.Rows.Count; i++) { pfipepArray.Add(Math.Round(Convert.ToSingle(pfipeptable.Rows[i][0].ToString()), 2)); } sql = "select " + pfgprdRate.Ratetype + " from tb_rate_pf_ipe_trailer"; DataTable pfipettable = new DBOperateCommon().excuteQuery(sql); for (int i = 0; i < pfipettable.Rows.Count; i++) { pfipetArray.Add(Math.Round(Convert.ToSingle(pfipettable.Rows[i][0].ToString()), 2)); } user_rate_info.Visible = true; }