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