/// <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(); }