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;
}
