protected void btn_set_postnl_rate_Click(object sender, EventArgs e) { try { string username = Request.Form["username"]; string ratetype = Request.Form["postnlrate"]; int result = new SetPostNLRateForUserDAO().setRateForUser(username, ratetype, staffname); if (result == 1) { alert("更新成功!!"); } else if (result == 2) { alert("跟新失败!!"); } else if (result == 3) { alert("设置成功!"); } else if (result == 4) { alert("设置失败!!"); } pageNow = 1; rate_count = new SetPostNLRateForUserDAO().getUserRateCount(); rate_page_count = new SetPostNLRateForUserDAO().getPageCount(rate_count, pageSize); initUserHasDiscountDataList(pageNow, pageSize); } catch (Exception) { alert("用户的用户名必须唯一"); } }
/// <summary> /// 分页创建 用户邮费表 /// </summary> /// <param name="pageNow">当前页</param> /// <param name="pageSize">每页显示条数</param> /// <returns></returns> public DataTable createUserRateTable(int pageNow, int pageSize) { DataTable table = new DataTable(); DataColumn dc = new DataColumn("name", typeof(string)); table.Columns.Add(dc); dc = new DataColumn("type", typeof(string)); table.Columns.Add(dc); dc = new DataColumn("seter", typeof(string)); table.Columns.Add(dc); dc = new DataColumn("time", typeof(string)); table.Columns.Add(dc); DataTable staffTable = new SetPostNLRateForUserDAO().getUserRate(pageNow, pageSize); for (int i = 0; i < staffTable.Rows.Count; i++) { DataRow dr = table.NewRow(); dr["name"] = staffTable.Rows[i]["username"].ToString(); dr["type"] = staffTable.Rows[i]["ratetype"].ToString(); dr["seter"] = staffTable.Rows[i]["setername"].ToString(); dr["time"] = Convert.ToDateTime(staffTable.Rows[i]["settime"].ToString()).ToString("yyyy:MM:dd HH:mm"); table.Rows.Add(dr); } return(table); }
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; }