/// <summary> /// 获取所有的入库信息。 /// </summary> public List <Model.Inin> getAllIn() { List <Model.Inin> inin = new List <Model.Inin>(); string sqltext = "select * from inin"; SqlDataReader sdr = DBTools.exereaderSQL(sqltext, new List <SqlParameter> ()); while (sdr.Read()) { Model.Inin i = new Model.Inin(); i.InID = sdr["inID"].ToString(); i.PositionNum = sdr["positionNum"].ToString(); i.GoodsNum = sdr["goodsNum"].ToString(); i.InAmount = int.Parse(sdr["inAmount"].ToString()); i.BatchNum = sdr["batchNum"].ToString(); i.Date = DateTime.Parse(sdr["date"].ToString()); i.UserId = sdr["userId"].ToString(); i.Remark = sdr["remark"].ToString(); i.Position = new DAL.PositionDAO().getPositionByNum(i.PositionNum); i.Goods = new DAL.GoodsDAO().getGoodsByNum(i.GoodsNum); i.Batch = new DAL.BatchDao().getBatchByNum(i.BatchNum); i.SysUser = new DAL.SysUserDAO().getUserById(i.UserId); inin.Add(i); } sdr.Close(); DBTools.DBClose(); return(inin); }
/// <summary> /// 根据id查找相应的信息 /// </summary> /// <param name="id">入库id</param> /// <returns>Inin类对象</returns> public Model.Inin getInsById(string id) { Model.Inin i = null; string sqltext = "select * from Inin where inID=@inID"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@inID", id); para.Add(sqlpara1); SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para); while (sdr.Read()) { i = new Model.Inin(); i.InID = sdr["inID"].ToString(); i.PositionNum = sdr["positionNum"].ToString(); i.GoodsNum = sdr["goodsNum"].ToString(); i.InAmount = int.Parse(sdr["inAmount"].ToString()); i.BatchNum = sdr["batchNum"].ToString(); i.Date = DateTime.Parse(sdr["date"].ToString()); i.UserId = sdr["userId"].ToString(); i.Remark = sdr["remark"].ToString(); i.Position = new DAL.PositionDAO().getPositionByNum(i.PositionNum); i.Goods = new DAL.GoodsDAO().getGoodsByNum(i.GoodsNum); i.Batch = new DAL.BatchDao().getBatchByNum(i.BatchNum); i.SysUser = new DAL.SysUserDAO().getUserById(i.UserId); } sdr.Close(); DBTools.DBClose(); return(i); }
/// <summary> /// 根据Where条件查找相应的信息 /// </summary> /// <param name="sqlWhere">Where条件字符串集合编号</param> /// <returns>Inin类型的集合</returns> public List <Model.Inin> getInsByWhere(List <string> sqlWhere) { List <Model.Inin> inin = new List <Model.Inin>(); string sqltext = "select * from Inin,Goods,Goodstype,Position,Provider,Sysuser,Staff,Batch,Chest where position.chestNum=chest.chestNum and Inin.goodsNum=Goods.goodsNum and Goods.goodsTypeNum=Goodstype.goodsTypeNum and Inin.positionNum=Position.positionNum and Inin.batchNum=Batch.batchNum and Batch.proorrecNum=Provider.providerNum and Inin.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.Inin i = new Model.Inin(); i.InID = sdr["inID"].ToString(); i.PositionNum = sdr["positionNum"].ToString(); i.GoodsNum = sdr["goodsNum"].ToString(); i.InAmount = int.Parse(sdr["inAmount"].ToString()); i.BatchNum = sdr["batchNum"].ToString(); i.Date = DateTime.Parse(sdr["date"].ToString()); i.UserId = sdr["userId"].ToString(); i.Remark = sdr["remark"].ToString(); i.Position = new DAL.PositionDAO().getPositionByNum(i.PositionNum); i.Goods = new DAL.GoodsDAO().getGoodsByNum(i.GoodsNum); i.Batch = new DAL.BatchDao().getBatchByNum(i.BatchNum); i.SysUser = new DAL.SysUserDAO().getUserById(i.UserId); inin.Add(i); } sdr.Close(); DBTools.DBClose(); return(inin); }
/// <summary> /// 根据传进来的供应商编号查找相应的信息 /// </summary> /// <param name="provideNum">供应商编号</param> /// <returns>Inin类型的集合</returns> public List <Model.Inin> getInsByProviderNum(string provideNum) { List <Model.Inin> inin = new List <Model.Inin>(); string sqltext = "select inID,Inin.positionNum,Inin.goodsNum,inAmount,Inin.batchNum,[date],userId,Inin.remark from Inin,batch where inin.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.Inin i = new Model.Inin(); i.InID = sdr["inID"].ToString(); i.PositionNum = sdr["positionNum"].ToString(); i.GoodsNum = sdr["goodsNum"].ToString(); i.InAmount = int.Parse(sdr["inAmount"].ToString()); i.BatchNum = sdr["batchNum"].ToString(); i.Date = DateTime.Parse(sdr["date"].ToString()); i.UserId = sdr["userId"].ToString(); i.Remark = sdr["remark"].ToString(); i.Position = new DAL.PositionDAO().getPositionByNum(i.PositionNum); i.Goods = new DAL.GoodsDAO().getGoodsByNum(i.GoodsNum); i.Batch = new DAL.BatchDao().getBatchByNum(i.BatchNum); i.SysUser = new DAL.SysUserDAO().getUserById(i.UserId); inin.Add(i); } sdr.Close(); DBTools.DBClose(); return(inin); }
/// <summary> /// 根据时间的区间的字符串类型查询一样的Inin类型集合 /// </summary> /// <param name="starttime">开始时间</param> /// <param name="endtime">结束时间</param> /// <returns>Inin类型的集合</returns> public List <Model.Inin> getInsBetweenDate(string starttime, string endtime) { List <Model.Inin> inin = new List <Model.Inin>(); string sqltext = "select * from inin 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.Inin i = new Model.Inin(); i.InID = sdr["inID"].ToString(); i.PositionNum = sdr["positionNum"].ToString(); i.GoodsNum = sdr["goodsNum"].ToString(); i.InAmount = int.Parse(sdr["inAmount"].ToString()); i.BatchNum = sdr["batchNum"].ToString(); i.Date = DateTime.Parse(sdr["date"].ToString()); i.UserId = sdr["userId"].ToString(); i.Remark = sdr["remark"].ToString(); i.Position = new DAL.PositionDAO().getPositionByNum(i.PositionNum); i.Goods = new DAL.GoodsDAO().getGoodsByNum(i.GoodsNum); i.Batch = new DAL.BatchDao().getBatchByNum(i.BatchNum); i.SysUser = new DAL.SysUserDAO().getUserById(i.UserId); inin.Add(i); } sdr.Close(); DBTools.DBClose(); return(inin); }
/// <summary> /// 更新某个入库记录。 /// </summary> /// <param name="iin">入库对象。</param> public bool updateIn(Model.Inin iin) { string sqltext = "update inin set positionNum=@positionNum,goodsNum=@goodsNum,inAmount=@inAmount,batchNum=@batchNum,date=@date,userId=@userId,remark=@remark where inID=@inID"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@positionNum", iin.PositionNum); SqlParameter sqlpara2 = new SqlParameter("@goodsNum", iin.GoodsNum); SqlParameter sqlpara3 = new SqlParameter("@inAmount", iin.InAmount); SqlParameter sqlpara4 = new SqlParameter("@batchNum", iin.BatchNum); SqlParameter sqlpara5 = new SqlParameter("@date", iin.Date.ToString()); SqlParameter sqlpara6 = new SqlParameter("@userId", iin.UserId); SqlParameter sqlpara7 = new SqlParameter("@remark", iin.Remark); SqlParameter sqlpara8 = new SqlParameter("@inID", iin.InID); 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="iin">入库对象。</param> public bool addIn(Model.Inin iin) { string sqltext = "insert inin(num,inID,positionNum,goodsNum,inAmount,V,batchNum,date,userId,remark) values(@num,@inID,@positionNum,@goodsNum,@inAmount,@V,@batchNum,@date,@userId,@remark)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara0 = new SqlParameter("@num", iin.Num); SqlParameter sqlpara1 = new SqlParameter("@inID", iin.InID); SqlParameter sqlpara2 = new SqlParameter("@positionNum", iin.PositionNum); SqlParameter sqlpara3 = new SqlParameter("@goodsNum", iin.GoodsNum); SqlParameter sqlpara4 = new SqlParameter("@inAmount", iin.InAmount); SqlParameter sqlpara10 = new SqlParameter("@V", iin.V); SqlParameter sqlpara5 = new SqlParameter("@batchNum", iin.BatchNum); SqlParameter sqlpara6 = new SqlParameter("@date", iin.Date.ToString()); SqlParameter sqlpara7 = new SqlParameter("@userId", iin.UserId); SqlParameter sqlpara8 = new SqlParameter("@remark", iin.Remark); para.Add(sqlpara0); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara10); 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); } }
protected void Button66_Click(object sender, EventArgs e) { 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(); Model.Inin add = new Model.Inin(); DAL.Query qu = new DAL.Query(); int n = qu.query("Inin"); add.Num = n + 1; add.InID = TextBox11.Text; add.PositionNum = TextBox9.Text; add.GoodsNum = TextBox12.Text; add.InAmount = double.Parse(TextBox2.Text); add.V = (Convert.ToDouble(tiqu.tiqu(TextBox2.Text)) * Convert.ToDouble(tiqu.tiqu(TextBox7.Text))).ToString(); add.BatchNum = TextBox3.Text; add.Date = DateTime.Now; add.UserId = TextBox5.Text; add.Remark = TextBox6.Text; bool xx = new DAL.IninDAO().addIn(add); if (xx) { if ((Convert.ToInt32(new Warehouse.Tools.queryV().query("select count(*) from Amount where goodsNum='" + add.GoodsNum + "' and PositionNum ='" + add.PositionNum + "' ")) > 0) && (Convert.ToInt32(new Warehouse.Tools.queryV().query("select count(*) from Amount where Vp='" + (tiqu.tiqu(TextBox7.Text)).ToString() + "' "))) > 0) { Model.Amount addd = new Model.Amount(); addd.Num = Convert.ToInt32(new Warehouse.Tools.queryV().query("select count(*) from Amount where 1=1 ")) + 1; addd.GoodsNum = add.GoodsNum; addd.PositionNum = add.PositionNum; addd.Vp = (tiqu.tiqu(TextBox7.Text)).ToString(); addd.Amounts = add.InAmount + Convert.ToDouble(new Warehouse.Tools.queryV().query("select amount from Amount where goodsNum='" + add.GoodsNum + "' and PositionNum ='" + add.PositionNum + "' ")); switch (new Warehouse.Tools.queryV().query("select goodsStyle from Goods where goodsNum='" + add.GoodsNum + "'").ToString()) { case "固态": addd.AmountPer = "Kg"; break; case "液态": addd.AmountPer = "L"; break; case "气态": addd.AmountPer = "L"; break; case "其他": addd.AmountPer = "Kg"; break; } addd.V = (Convert.ToDouble(new Warehouse.Tools.queryV().query("select V from Amount where goodsNum='" + add.GoodsNum + "' and PositionNum ='" + add.PositionNum + "' ")) + (Convert.ToDouble(TextBox2.Text) * Convert.ToDouble(tiqu.tiqu(TextBox7.Text)))).ToString(); new DAL.AmountDAO().updateAmount(addd); } else { Model.Amount addd = new Model.Amount(); addd.Num = Convert.ToInt32(new Warehouse.Tools.queryV().query("select count(*) from Amount where 1=1 ")) + 1; addd.GoodsNum = add.GoodsNum; addd.PositionNum = add.PositionNum; addd.Amounts = add.InAmount; switch (new Warehouse.Tools.queryV().query("select goodsStyle from Goods where goodsNum='" + add.GoodsNum + "' ").ToString()) { case "固态": addd.AmountPer = "Kg"; break; case "液态": addd.AmountPer = "L"; break; case "气态": addd.AmountPer = "L"; break; case "其他": addd.AmountPer = "Kg"; break; } addd.Vp = (tiqu.tiqu(TextBox7.Text)).ToString(); addd.V = (Convert.ToDouble(tiqu.tiqu(TextBox2.Text)) * Convert.ToDouble(tiqu.tiqu(TextBox7.Text))).ToString(); new DAL.AmountDAO().addAmount(addd); } Warehouse.Tools.update up = new Tools.update(); double xxxx1 = (tiqu.tiqu(TextBox7.Text) * (tiqu.tiqu(TextBox2.Text))); double xxxx2 = tiqu.tiqu(qq.query("select Rest from Position where positionNum='" + TextBox9.Text + "' ")); string rest = (xxxx2 - xxxx1).ToString(); up.updates("update Position set Rest='" + rest + "' where positionNum='" + TextBox9.Text + "' "); ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加成功!');", true); Div1.Visible = false; GridView1.Visible = true; if (GridView1.Visible == true) { Button1.Visible = true; Button4.Visible = true; ListBox11.Visible = true; TextBox1.Visible = true; Button5.Visible = true; } rg.Refresh("select * from Inin order by num", "inID", GridView1); Warehouse.TextBox_Clear tx = new TextBox_Clear(); tx.clear(Div1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('添加失败!');", true); } } else { Response.Write("<script>window.location.href='#div_kkk'</script>"); } } else if (Button66.Text == "确定") { Model.Inin add = new Model.Inin(); add.InID = TextBox11.Text; add.PositionNum = TextBox9.Text; add.GoodsNum = TextBox12.Text; add.InAmount = Int32.Parse(TextBox2.Text); add.BatchNum = TextBox3.Text; add.Date = DateTime.Now; add.UserId = TextBox5.Text; add.Remark = TextBox6.Text; bool xx = new DAL.IninDAO().updateIn(add); if (xx) { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改成功!');", true); Div1.Visible = false; GridView1.Visible = true; if (GridView1.Visible == true) { Button1.Visible = true; Button4.Visible = true; ListBox11.Visible = true; TextBox1.Visible = true; Button5.Visible = true; } rg.Refresh("select * from Inin order by num", "inID", GridView1); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('修改失败!');", true); } } }
/// <summary> /// 添加一条入库记录。 /// </summary> /// <param name="iin">入库对象。</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool addIn(Model.Inin iin) { throw new System.NotImplementedException(); }