/// <summary>
/// 根据Where条件查找相应的信息
/// </summary>
/// <param name="sqlWhere">Where条件字符串集合编号</param>
/// <returns>outout类型的集合</returns>
public List <Model.Outout> getOutsByWhere(List <string> sqlWhere)
{
List <Model.Outout> outout = new List <Model.Outout>();
string sqltext = "select * from Outout,Goods,Goodstype,Position,receiver,Sysuser,Staff,Batch,chest where Position.chestNum=chest.chestNum and Outout.goodsNum=Goods.goodsNum and Goods.goodsTypeNum=Goodstype.goodsTypeNum and Outout.positionNum=Position.positionNum and Outout.batchNum=Batch.batchNum and Batch.proorrecNum=Receiver.receiverNum and Outout.userId=Sysuser.userId and Sysuser.staffNum=Staff.staffNum";
foreach (string sql in sqlWhere)
{
sqltext += sql;
}
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, new List <SqlParameter>());
while (sdr.Read())
{
Model.Outout o = new Model.Outout();
o.OuID = sdr["outID"].ToString();
o.PositionNum = sdr["positionNum"].ToString();
o.GoodsNum = sdr["goodsNum"].ToString();
o.OutAmount = int.Parse(sdr["outAmount"].ToString());
o.BatchNum = sdr["batchNum"].ToString();
o.Date = DateTime.Parse(sdr["date"].ToString());
o.UserId = sdr["userId"].ToString();
o.Remark = sdr["remark"].ToString();
o.Position = new DAL.PositionDAO().getPositionByNum(o.PositionNum);
o.Goods = new DAL.GoodsDAO().getGoodsByNum(o.GoodsNum);
o.Batch = new DAL.BatchDao().getBatchByNum(o.BatchNum);
o.SysUser = new DAL.SysUserDAO().getUserById(o.UserId);
outout.Add(o);
}
sdr.Close();
DBTools.DBClose();
return(outout);
}
/// <summary>
/// 添加一条出库信息
/// </summary>
/// <param name="oout">出库对象。</param>
/// <returns>通过布尔类型判断操作是否成功.</returns>
public bool addOut(Model.Outout oout)
{
string sqltext = "insert outout(num,outID,positionNum,goodsNum,outAmount,batchNum,date,userId,remark) values(@num,@outID,@positionNum,@goodsNum,@outAmount,@batchNum,@date,@userId,@remark)";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara = new SqlParameter("@num", oout.Num);
SqlParameter sqlpara1 = new SqlParameter("@outID", oout.OuID);
SqlParameter sqlpara2 = new SqlParameter("@positionNum", oout.PositionNum);
SqlParameter sqlpara3 = new SqlParameter("@goodsNum", oout.GoodsNum);
SqlParameter sqlpara4 = new SqlParameter("@outAmount", oout.OutAmount);
SqlParameter sqlpara5 = new SqlParameter("@batchNum", oout.BatchNum);
SqlParameter sqlpara6 = new SqlParameter("@date", oout.Date.ToString());
SqlParameter sqlpara7 = new SqlParameter("@userId", oout.UserId);
SqlParameter sqlpara8 = new SqlParameter("@remark", oout.Remark);
para.Add(sqlpara);
para.Add(sqlpara1);
para.Add(sqlpara2);
para.Add(sqlpara3);
para.Add(sqlpara4);
para.Add(sqlpara5);
para.Add(sqlpara6);
para.Add(sqlpara7);
para.Add(sqlpara8);
int i = DBTools.exenonquerySQL(sqltext, para);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据传进来的供应商编号查找相应的信息
/// </summary>
/// <param name="provideNum">供应商编号</param>
/// <returns>Outout类型的集合</returns>
public List <Model.Outout> getoutsByProviderNum(string provideNum)
{
List <Model.Outout> outout = new List <Model.Outout>();
string sqltext = "select outID,outout.positionNum,outout.goodsNum,outAmount,outout.batchNum,[date],userId,outout.remark from outout,batch where outout.batchNum=batch.batchNum and batch.proorrecNum='@provideNum'";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@provideNum", provideNum);
para.Add(sqlpara1);
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para);
while (sdr.Read())
{
Model.Outout o = new Model.Outout();
o.OuID = sdr["outID"].ToString();
o.PositionNum = sdr["positionNum"].ToString();
o.GoodsNum = sdr["goodsNum"].ToString();
o.OutAmount = int.Parse(sdr["outAmount"].ToString());
o.BatchNum = sdr["batchNum"].ToString();
o.Date = DateTime.Parse(sdr["date"].ToString());
o.UserId = sdr["userId"].ToString();
o.Remark = sdr["remark"].ToString();
o.Position = new DAL.PositionDAO().getPositionByNum(o.PositionNum);
o.Goods = new DAL.GoodsDAO().getGoodsByNum(o.GoodsNum);
o.Batch = new DAL.BatchDao().getBatchByNum(o.BatchNum);
o.SysUser = new DAL.SysUserDAO().getUserById(o.UserId);
outout.Add(o);
}
sdr.Close();
DBTools.DBClose();
return(outout);
}
/// <summary>
/// 根据id查找相应的信息
/// </summary>
/// <param name="id">入库id</param>
/// <returns>Outout类对象</returns>
public Model.Outout getOutsById(string id)
{
Model.Outout o = null;
string sqltext = "select * from outout where outID=@ouID";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@ouID", id);
para.Add(sqlpara1);
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para);
while (sdr.Read())
{
o = new Model.Outout();
o.OuID = sdr["outID"].ToString();
o.PositionNum = sdr["positionNum"].ToString();
o.GoodsNum = sdr["goodsNum"].ToString();
o.OutAmount = int.Parse(sdr["outAmount"].ToString());
o.BatchNum = sdr["batchNum"].ToString();
o.Date = DateTime.Parse(sdr["date"].ToString());
o.UserId = sdr["userId"].ToString();
o.Remark = sdr["remark"].ToString();
o.Position = new DAL.PositionDAO().getPositionByNum(o.PositionNum);
o.Goods = new DAL.GoodsDAO().getGoodsByNum(o.GoodsNum);
o.Batch = new DAL.BatchDao().getBatchByNum(o.BatchNum);
o.SysUser = new DAL.SysUserDAO().getUserById(o.UserId);
}
sdr.Close();
DBTools.DBClose();
return(o);
}
/// <summary>
/// 根据时间的区间的字符串类型查询一样的Inin类型集合
/// </summary>
/// <param name="starttime">开始时间</param>
/// <param name="endtime">结束时间</param>
/// <returns>Outout类型的集合</returns>
public List <Model.Outout> getOutsBetweenDate(string starttime, string endtime)
{
List <Model.Outout> outout = new List <Model.Outout>();
string sqltext = "select * from outout where date between '@date1 0:00:00' and '@date2 23:59:59'";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@date1", starttime);
SqlParameter sqlpara2 = new SqlParameter("@date2", endtime);
para.Add(sqlpara1);
para.Add(sqlpara2);
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para);
while (sdr.Read())
{
Model.Outout o = new Model.Outout();
o.OuID = sdr["outID"].ToString();
o.PositionNum = sdr["positionNum"].ToString();
o.GoodsNum = sdr["goodsNum"].ToString();
o.OutAmount = int.Parse(sdr["outAmount"].ToString());
o.BatchNum = sdr["batchNum"].ToString();
o.Date = DateTime.Parse(sdr["date"].ToString());
o.UserId = sdr["userId"].ToString();
o.Remark = sdr["remark"].ToString();
o.Position = new DAL.PositionDAO().getPositionByNum(o.PositionNum);
o.Goods = new DAL.GoodsDAO().getGoodsByNum(o.GoodsNum);
o.Batch = new DAL.BatchDao().getBatchByNum(o.BatchNum);
o.SysUser = new DAL.SysUserDAO().getUserById(o.UserId);
outout.Add(o);
}
sdr.Close();
DBTools.DBClose();
return(outout);
}
/// <summary>
/// 获取所有的出库信息。
/// </summary>
/// <returns>Outout类型的集合</returns>
public List <Model.Outout> getAllOut()
{
List <Model.Outout> outout = new List <Model.Outout>();
string sqltext = "select * from outout";
SqlDataReader sdr = DBTools.exereaderSQL(sqltext, new List <SqlParameter> ());
while (sdr.Read())
{
Model.Outout o = new Model.Outout();
o.OuID = sdr["outID"].ToString();
o.PositionNum = sdr["positionNum"].ToString();
o.GoodsNum = sdr["goodsNum"].ToString();
o.OutAmount = int.Parse(sdr["outAmount"].ToString());
o.BatchNum = sdr["batchNum"].ToString();
o.Date = DateTime.Parse(sdr["date"].ToString());
o.UserId = sdr["userId"].ToString();
o.Remark = sdr["remark"].ToString();
o.Position = new DAL.PositionDAO().getPositionByNum(o.PositionNum);
o.Goods = new DAL.GoodsDAO().getGoodsByNum(o.GoodsNum);
o.Batch = new DAL.BatchDao().getBatchByNum(o.BatchNum);
o.SysUser = new DAL.SysUserDAO().getUserById(o.UserId);
outout.Add(o);
}
sdr.Close();
DBTools.DBClose();
return(outout);
}
/// <summary>
/// 更新一条出库信息。
/// </summary>
/// <param name="oout">出库对象。</param>
/// <returns>通过布尔类型判断操作是否成功.</returns>
public bool updateOut(Model.Outout oout)
{
string sqltext = "update outout set positionNum=@positionNum,goodsNum=@goodsNum,outAmount=@outAmount,batchNum=@batchNum,date=@date,userId=@userId,remark=@remark where outID=@outID";
List <SqlParameter> para = new List <SqlParameter>();
SqlParameter sqlpara1 = new SqlParameter("@outID", oout.OuID);
SqlParameter sqlpara2 = new SqlParameter("@positionNum", oout.PositionNum);
SqlParameter sqlpara3 = new SqlParameter("@goodsNum", oout.GoodsNum);
SqlParameter sqlpara4 = new SqlParameter("@outAmount", oout.OutAmount);
SqlParameter sqlpara5 = new SqlParameter("@batchNum", oout.BatchNum);
SqlParameter sqlpara6 = new SqlParameter("@date", oout.Date.ToString());
SqlParameter sqlpara7 = new SqlParameter("@userId", oout.UserId);
SqlParameter sqlpara8 = new SqlParameter("@remark", oout.Remark);
para.Add(sqlpara2);
para.Add(sqlpara3);
para.Add(sqlpara4);
para.Add(sqlpara5);
para.Add(sqlpara6);
para.Add(sqlpara7);
para.Add(sqlpara8);
para.Add(sqlpara1);
int i = DBTools.exenonquerySQL(sqltext, para);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "editt")
{
Div1.Visible = true;
Button1.Visible = false;
Button4.Visible = false;
Button5.Visible = false;
TextBox1.Visible = false;
ListBox11.Visible = false;
GridView2.Visible = false;
int n = Convert.ToInt32(qu.query("select count(*) from Outout where 1=1")) + 1;
string j = "";
Warehouse.Tools.OutoutNum ou = new Tools.OutoutNum();
TextBox11.Text = ou.Num();
Image1.Visible = true;
Image1.ImageUrl = "~/Image/对号.png";
int x = Convert.ToInt32(e.CommandArgument);
TextBox12.Text = GridView2.Rows[x].Cells[1].Text;
TextBox9.Text = GridView2.Rows[x].Cells[2].Text;
TextBox4.Text = DateTime.Now.ToString("yyyy/MM/dd");
Session["max"] = GridView2.Rows[x].Cells[3].Text;
Session["V"] = GridView2.Rows[x].Cells[5].Text;
DateTime date = DateTime.Now;
string dd = date.ToString("yyyyMMdd");
int c = Convert.ToInt32(qu.query("select count(*) from Outout where batchNum like '%" + dd + "%' ")) + 1;
switch (c.ToString().Length)
{
case 1: j = "00" + c.ToString(); break;
case 2: j = "0" + c.ToString(); break;
case 3: j = c.ToString(); break;
}
TextBox3.Text = DateTime.Now.ToString("yyyyMMdd") + "1010" + j;
Image3.Visible = true;
Image3.ImageUrl = "~/Image/对号.png";
Image2.Visible = true;
Image2.ImageUrl = "~/Image/对号.png";
Image5.Visible = true;
Image5.ImageUrl = "~/Image/对号.png";
Image6.Visible = true;
Image6.ImageUrl = "~/Image/对号.png";
Image8.Visible = true;
Image8.ImageUrl = "~/Image/对号.png";
}
else if (e.CommandName == "deletee")
{
Model.Outout delete = new Model.Outout();
int x = Convert.ToInt32(e.CommandArgument);
delete.OuID = GridView1.Rows[x].Cells[1].Text;
ideas.Style["display"] = "inline";
Session["delete"] = delete.OuID;
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "editt")
{
}
else if (e.CommandName == "deletee")
{
Model.Outout delete = new Model.Outout();
int x = Convert.ToInt32(e.CommandArgument);
delete.OuID = GridView1.Rows[x].Cells[1].Text;
ideas.Style["display"] = "inline";
Session["delete"] = delete.OuID;
}
}
protected void Button66_Click(object sender, EventArgs e)
{
Model.Outout add = new Model.Outout();
if (Button66.Text == "增加")
{
if (Image1.ImageUrl == "~/Image/对号.png" && Image2.ImageUrl == "~/Image/对号.png" && Image3.ImageUrl == "~/Image/对号.png" && Image4.ImageUrl == "~/Image/对号.png" && Image5.ImageUrl == "~/Image/对号.png" && Image6.ImageUrl == "~/Image/对号.png" && Image7.ImageUrl == "~/Image/对号.png" && Image8.ImageUrl == "~/Image/对号.png")
{
Warehouse.Tools.queryV qq = new Tools.queryV();
DAL.Query quu = new DAL.Query();
int n = quu.query("Outout");
add.Num = n + 1;
add.OuID = TextBox11.Text;
add.GoodsNum = TextBox12.Text;
add.PositionNum = TextBox9.Text;
add.OutAmount = Convert.ToDouble(TextBox2.Text);
add.BatchNum = TextBox3.Text;
add.Date = Convert.ToDateTime(TextBox4.Text);
add.UserId = qu.query("select staffNum from Staff where staffName='" + TextBox5.Text + "'");
add.Remark = TextBox6.Text;
bool xx = new DAL.OutoutDAO().addOut(add);
if (xx)
{
Model.Amount update = new Model.Amount();
update.Amounts = Convert.ToDouble(Session["max"].ToString()) - Convert.ToDouble(add.OutAmount);
double d = Convert.ToDouble(Session["V"].ToString()) / Convert.ToDouble(Session["max"].ToString());
update.V = (update.Amounts * d).ToString();
update.GoodsNum = TextBox12.Text;
update.PositionNum = TextBox9.Text;
update.Vp = d.ToString();
bool yy = new DAL.AmountDAO().update(update);
if (yy)
{
double rest = Convert.ToDouble(qu.query("select Rest from Position where positionNum='" + TextBox9.Text + "'"));
Model.Position Update = new Model.Position();
Update.Rest = (rest + d * add.OutAmount).ToString();
Update.PositionNum = TextBox9.Text;
bool cc = new DAL.PositionDAO().update(Update);
}
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');window.location.href='出库登记.aspx'", true);
}
}
}
}
/// <summary>
/// 更新一条出库记录。
/// </summary>
/// <param name="oout">出库对象。</param>
public bool updateOut(Model.Outout oout)
{
throw new System.NotImplementedException();
}
