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