protected void sub_Click(object sender, EventArgs e) { //Response.Write("<script type='text/javascript'>alert('" + Session["tempid"] + "');</script>"); pdm.Model.Stock_Manage stock = new pdm.Model.Stock_Manage(); stock.Dealer_ID = Convert.ToInt32(Session["tempid"].ToString()); stock.P_Model = Session["tempmodel"].ToString(); Session.Remove("tempmodel"); Session.Remove("tempid"); if (Convert.ToInt32(num.Text) >= 0) { stock.Inventory = Convert.ToInt32(num.Text); } if (new pdm.BLL.Stock_Manage().Update(stock)) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "edit_Stock"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = stock.P_Model; log.Number = Convert.ToInt32(num.Text); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('修改成功');window.location.href='./EditStock.aspx';</script>"); } else { Response.Write("<script type='text/javascript'>alert('修改失败');window.location.href='./EditStock.aspx';</script>"); } }
protected void sub_Click(object sender, EventArgs e) { int dealer_id = Convert.ToInt32(Session["UserID"].ToString());// if (model.SelectedValue != "0") { pdm.Model.Stock_Manage stock = new pdm.Model.Stock_Manage(); stock.Dealer_ID = dealer_id; stock.P_Model = model.SelectedValue; stock.Inventory = Convert.ToInt32(num.Text); if (new pdm.BLL.Stock_Manage().Exists(dealer_id, model.SelectedValue))//判断是否存在库存信息,如果有则更新若无则添加 { int i = new pdm.BLL.Stock_Manage().GetModel(dealer_id, model.SelectedValue).Inventory; stock.Inventory += i; if (new pdm.BLL.Stock_Manage().Update(stock)) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "supply"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = stock.P_Model; log.Number = Convert.ToInt32(num.Text); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('进货成功');</script>"); } else { Response.Write("<script type='text/javascript'>alert('进货失败');</script>"); } } else { if (new pdm.BLL.Stock_Manage().Add(stock)) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "supply"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = stock.P_Model; log.Number = Convert.ToInt32(num.Text); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('进货成功');</script>"); } else { Response.Write("<script type='text/javascript'>alert('进货失败');</script>"); } } } else { Response.Write("<script type='text/javascript'>alert('请选择进货的手机型号');</script>"); } }
protected void SignIn_Click(object sender, EventArgs e) { if (null != username.Text.Trim() && null != password.Text.Trim()) { try { //根据输入框中的用户名来取出一个Dataset,搜索语句采用传参的方式 DataSet userDS = new DataSet(); string sql = "select * from Users where Dealer_Name = @name"; pdm.BLL.DealerInfo dealer = new pdm.BLL.DealerInfo(); System.Data.SqlClient.SqlParameter us = new System.Data.SqlClient.SqlParameter("@name", username.Text.Trim()); userDS = Maticsoft.DBUtility.DbHelperSQL.Query(sql, us); //判断是否密码是否正确 if (userDS.Tables[0].Rows.Count > 0) { if (userDS.Tables[0].Rows[0]["Dealer_Psw"].ToString() == password.Text.Trim()) { Session["UserID"] = userDS.Tables[0].Rows[0]["Dealer_ID"].ToString(); Session["UserName"] = userDS.Tables[0].Rows[0]["Dealer_Name"].ToString(); Session["UserLevel"] = userDS.Tables[0].Rows[0]["Dealer_Level"].ToString(); Session["Parent"] = userDS.Tables[0].Rows[0]["Parent_ID"].ToString(); if (int.Parse(userDS.Tables[0].Rows[0]["Parent_ID"].ToString()) == -1) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "login"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('登陆成功');window.location.href='./SystemManagerForm/index.aspx';</script>"); } else { Response.Write("<script type='text/javascript'>alert('登陆成功');window.location.href='./NormalUserForm/index.aspx'</script>"); } } else { Response.Write("<script type='text/javascript'>alert('请检查用户名或密码是否正确')</script>"); } } } catch { Response.Write("<script type='text/javascript'>alert('登陆失败')</script>"); } } }
protected void sub_Click(object sender, EventArgs e) { if (("" != color.Text.Trim()) && ("" != Deploy.Text.Trim()) && ("" != brand.Text.Trim())) { pdm.Model.PhoneInfo phone = new pdm.Model.PhoneInfo(); phone.P_Model = Session["phone"].ToString(); Session.Remove("phone"); phone.P_Address = address.Text.Trim(); phone.P_Color = color.Text.Trim(); phone.P_Deploy = Deploy.Text.Trim(); phone.P_Brand = brand.Text.Trim(); try { if ((new pdm.BLL.PhoneInfo().Update(phone))) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "edit_phone_info"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = phone.P_Model; new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('更新成功')</script>"); } else { Response.Write("<script type='text/javascript'>alert('更新失败')</script>"); } } catch { Response.Write("<script type='text/javascript'>alert('更新失败')</script>"); } } else { Response.Write("<script type='text/javascript'>alert('请完善所有信息,带‘*’的为必填项')</script>"); } }
protected void sub_Click(object sender, EventArgs e) { pdm.Model.DealerInfo di = new pdm.Model.DealerInfo(); di.Dealer_ID = Convert.ToInt32(Session["d_id"]); di.Name = dealer_name.Text.Trim(); di.Province = Convert.ToInt32(Province.SelectedValue); di.City = Convert.ToInt32(City.SelectedValue); di.County = Convert.ToInt32(County.SelectedValue); di.Tel = Convert.ToInt32(telephone_number.Text); di.Address = addr.Text; new pdm.BLL.DealerInfo().Update(di); //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "edit_user_info"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('修改成功')</script>"); }
protected void sub_Click(object sender, EventArgs e) { if ((null != model.Text.Trim()) && (null != color.Text.Trim()) && (null != Deploy.Text.Trim()) && (null != brand.Text.Trim())) { if (!(new pdm.BLL.PhoneInfo().Exists(model.Text.Trim()))) { pdm.Model.PhoneInfo phone = new pdm.Model.PhoneInfo(); phone.P_Model = model.Text; phone.P_Address = address.Text; phone.P_Color = color.Text; phone.P_Deploy = Deploy.Text; phone.P_Brand = brand.Text; if (new pdm.BLL.PhoneInfo().Add(phone)) { //添加操作记录 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "add_phone_model"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = phone.P_Model; new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('添加成功')</script>"); } else { Response.Write("<script type='text/javascript'>alert('添加失败')</script>"); } } else { Response.Write("<script type='text/javascript'>alert('已存在该型号')</script>"); } } else { Response.Write("<script type='text/javascript'>alert('请完善所有信息,带‘*’的为必填项')</script>"); } }
protected void submit_Click(object sender, EventArgs e)//提交按钮点击触发事件 { pdm.Model.DealerInfo di = new pdm.Model.DealerInfo(); pdm.Model.Users user = new pdm.Model.Users(); if ((null != username.Text.Trim()) && ((null != password.Text.Trim()) == (null != password2.Text.Trim())) && (0 != Convert.ToInt32(Province.SelectedValue)) && (0 != Convert.ToInt32(County.SelectedValue)) && (0 != Convert.ToInt32(City.SelectedValue)) && (null != addr.Text.Trim())) { if (!(new pdm.BLL.Users().Exists(username.Text.Trim()))) { user.Dealer_Name = username.Text.Trim(); user.Dealer_Psw = password.Text.Trim(); user.Parent_ID = Convert.ToInt32(Session["UserID"]); user.Dealer_Level = Convert.ToInt32(Session["UserLevel"]) + 1; try { //将数据写入Users表 new pdm.BLL.Users().Add(user); //获取插入数据的Dealer_ID,存放在dealer_id中 DataSet userDS = new DataSet(); string sql = "select * from Users where Dealer_Name = @name"; System.Data.SqlClient.SqlParameter us = new System.Data.SqlClient.SqlParameter("@name", username.Text.Trim()); userDS = Maticsoft.DBUtility.DbHelperSQL.Query(sql, us); int dealer_id = Convert.ToInt32(userDS.Tables[0].Rows[0]["Dealer_ID"].ToString()); //Response.Write("<script type='text/javascript'>alert('" + dealer_id+ "')</script>"); //将资料写入DealerInfo表中 di.Dealer_ID = dealer_id; di.Name = dealer_name.Text.Trim(); di.Province = Convert.ToInt32(Province.SelectedValue); di.City = Convert.ToInt32(City.SelectedValue); di.County = Convert.ToInt32(County.SelectedValue); di.Tel = Convert.ToInt32(telephone_number.Text); di.Address = addr.Text; new pdm.BLL.DealerInfo().Add(di); Response.Write("<script type='text/javascript'>alert('添加成功')</script>"); //重置所有输入框 username.Text = ""; password.Text = ""; password2.Text = ""; dealer_name.Text = ""; telephone_number.Text = ""; addr.Text = ""; Province.SelectedIndex = 0; City.Visible = false; County.Visible = false; //添加日志记录 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "add_user"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); new pdm.BLL.UseLog().Add(log); } catch { Response.Write("<script type='text/javascript'>alert('添加失败,请重试')</script>"); } } else { Response.Write("<script type='text/javascript'>alert('用户名已存在')</script>"); } } else { Response.Write("<script type='text/javascript'>alert('请检查信息是否有错')</script>"); } }
protected void sub_Click(object sender, EventArgs e) { if (("" != num.Text.Trim()) && (dealer.SelectedValue != "0") && (model.SelectedValue != "0")) { try { if ((Convert.ToInt32(num.Text) < (new pdm.BLL.Stock_Manage().GetModel(Convert.ToInt32(Session["UserID"].ToString()), model.SelectedValue).Inventory))) //判断发货方是否有足够库存 { if ((new pdm.BLL.Stock_Manage().Exists(Convert.ToInt32(dealer.SelectedValue), model.SelectedValue))) //判断是否已经存在下级库存 { //加下级库存,下级已有库存 pdm.Model.Stock_Manage del = new pdm.Model.Stock_Manage(); del.Dealer_ID = Convert.ToInt32(dealer.SelectedValue); del.P_Model = model.SelectedValue; del.Inventory = (new pdm.BLL.Stock_Manage().GetModel(Convert.ToInt32(dealer.SelectedValue), model.SelectedValue).Inventory) + Convert.ToInt32(num.Text); //减上级库存 pdm.Model.Stock_Manage sys = new pdm.BLL.Stock_Manage().GetModel(Convert.ToInt32(Session["UserID"].ToString()), model.SelectedValue); sys.Inventory = sys.Inventory - Convert.ToInt32(num.Text); if (new pdm.BLL.Stock_Manage().Update(del) && (new pdm.BLL.Stock_Manage().Update(sys))) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "delivery"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = del.P_Model; log.Number = Convert.ToInt32(num.Text); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('发货成功')</script>"); } else { Response.Write("<script type='text/javascript'>alert('发货失败')</script>"); } } else { //加下级库存,下级暂无相应型号手机库存 pdm.Model.Stock_Manage del = new pdm.Model.Stock_Manage(); del.Dealer_ID = Convert.ToInt32(dealer.SelectedValue); del.P_Model = model.SelectedValue; del.Inventory = Convert.ToInt32(num.Text); //减上级库存 pdm.Model.Stock_Manage sys = new pdm.BLL.Stock_Manage().GetModel(Convert.ToInt32(Session["UserID"].ToString()), model.SelectedValue); sys.Inventory = sys.Inventory - Convert.ToInt32(num.Text); if (new pdm.BLL.Stock_Manage().Add(del) && (new pdm.BLL.Stock_Manage().Update(sys))) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "delivery"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = del.P_Model; log.Number = del.Inventory; new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('发货成功')</script>"); } else { Response.Write("<script type='text/javascript'>alert('发货失败')</script>"); } } } else { Response.Write("<script type='text/javascript'>alert('库存不足')</script>"); } } catch { Response.Write("<script type='text/javascript'>alert('出错')</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session.Count > 0 && Session["userID"].ToString() != "") { } else { Response.Redirect("/loginout.aspx?method=sb"); } } string method = Request.QueryString["method"]; string id = Request.QueryString["id"]; // 通过method来决定执行操作 switch (method) { case "delete": //删除用户信息及该用户所有库存 int dealer_id = Convert.ToInt32(id); if ((new pdm.BLL.Users().Delete(dealer_id)) && (new pdm.BLL.DealerInfo().Delete(dealer_id))) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "delete_user"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('删除成功');window.location.href='./ViewNextLevelDealers.aspx';</script>"); } else { Response.Write("<script type='text/javascript'>alert('删除失败');window.location.href='./ViewNextLevelDealers.aspx'</script>"); } break; case "deletePhoneInfo": //删除手机信息 if (new pdm.BLL.PhoneInfo().Delete(id)) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "delete_phone_info"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = id; new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('删除成功');window.location.href='./DisplayAllPhoneInfo.aspx';</script>"); } else { Response.Write("<script type='text/javascript'>alert('删除失败');window.location.href='./DisplayAllPhoneInfo.aspx';</script>"); } break; case "deleteStock": //删除库存 string model = Request.QueryString["model"]; if (new pdm.BLL.Stock_Manage().Delete(Convert.ToInt32(id), model)) { //添加操作记录 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "delete_stock"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = model; new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('删除成功');window.location.href='./EditStock.aspx';</script>"); } else { Response.Write("<script type='text/javascript'>alert('删除失败');window.location.href='./EditStock.aspx';</script>"); } break; default: Response.Redirect("./main.aspx"); break; } }
protected void sub_Click(object sender, EventArgs e) { if ((num.Text.Trim() != "") && (Convert.ToInt32(num.Text.Trim()) >= 0) && (model.SelectedValue != "0")) //判断选择的型号与输入的数量是否是合法值 { if ((Convert.ToInt32(num.Text.Trim()) <= (new pdm.BLL.Stock_Manage().GetModel(Convert.ToInt32(Session["userID"].ToString()), model.SelectedValue).Inventory))) //判断输入的数量是否小于等于库存 { try { //当前用户减库存 pdm.Model.Stock_Manage son = new pdm.Model.Stock_Manage(); son.Dealer_ID = Convert.ToInt32(Session["userID"]); son.P_Model = model.SelectedValue; son.Inventory = (new pdm.BLL.Stock_Manage().GetModel(Convert.ToInt32(Session["userID"].ToString()), model.SelectedValue).Inventory) - Convert.ToInt32(num.Text.Trim()); new pdm.BLL.Stock_Manage().Update(son); //上级用户加库存 pdm.Model.Stock_Manage parent = new pdm.Model.Stock_Manage(); parent.Dealer_ID = (new pdm.BLL.Users().GetModel(Convert.ToInt32(Session["userID"].ToString())).Parent_ID); parent.P_Model = model.SelectedValue; if (new pdm.BLL.Stock_Manage().Exists(parent.Dealer_ID, parent.P_Model)) { parent.Inventory = Convert.ToInt32(num.Text.Trim()) + (new pdm.BLL.Stock_Manage().GetModel(parent.Dealer_ID, parent.P_Model).Inventory); if (new pdm.BLL.Stock_Manage().Update(parent)) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "return"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = model.SelectedValue; log.Number = Convert.ToInt32(num.Text.Trim()); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('退货成功');</script>"); } else { Response.Write("<script type='text/javascript'>alert('退货失败');</script>"); } } else {//库存中上级没有该型号的记录 parent.Inventory = Convert.ToInt32(num.Text.Trim()); if (new pdm.BLL.Stock_Manage().Add(parent)) { //添加操作日志 pdm.Model.UseLog log = new pdm.Model.UseLog(); log.Method = "return"; log.Time = DateTime.Now; log.Dealer_ID = Convert.ToInt32(Session["userID"].ToString()); log.P_Model = model.SelectedValue; log.Number = Convert.ToInt32(num.Text.Trim()); new pdm.BLL.UseLog().Add(log); Response.Write("<script type='text/javascript'>alert('退货成功');</script>"); } else { Response.Write("<script type='text/javascript'>alert('退货失败');</script>"); } } } catch { Response.Write("<script type='text/javascript'>alert('出错');</script>"); } } else { Response.Write("<script type='text/javascript'>alert('数量超过已有库存');</script>"); } } else { Response.Write("<script type='text/javascript'>alert('请输入正确的型号与数量');</script>"); } }