private void toolSave_Click(object sender, EventArgs e)
{
if (txtThGoodsID.Text == "" || txtSellID.Text == "" || txtGoodsID.Text == "" || txtSellID.Text == "" || txtThGoodsName.Text == "" || numSellGoodsNum.Text == "" || txtThHasPay.Text == "" || txtThNeedPay.Text == "" || cboEmpID.Text == "")
{
MessageBox.Show("请将信息添加完整！");
return;
}
Model.THGoodsInfo model = new Model.THGoodsInfo();//实例化model层
model.THGoodsID = txtThGoodsID.Text.Trim();
model.KCID = "";
model.GoodsID = txtGoodsID.Text.Trim();
model.SellID = txtSellID.Text.Trim();
model.EmploayeeID = cboEmpID.Text.Trim();
model.THGoodsName = txtThGoodsName.Text.Trim();
model.THGoodsNum = int.Parse(numSellGoodsNum.Text.Trim());
model.THGoodsTime = DateTime.Parse(daThGoodsTime.Value.ToString());
model.THGoodsPrice = float.Parse(txtThGoodsPrice.Text.Trim());
model.THNeedPay = float.Parse(txtThNeedPay.Text.Trim());
model.THHasPay = float.Parse(txtThHasPay.Text.Trim());
model.THGoodsResult = txtThGoodsResult.Text;
BLL.THGoodsInfo bll = new BLL.THGoodsInfo();//实例化BLL层
Model.KCInfo kcInfo = new Model.KCInfo();
kcInfo.GoodsID = txtGoodsID.Text.Trim();
kcInfo.GoodsName = txtThGoodsName.Text.Trim();
kcInfo.DepotName = txtDepotName.Text.Trim();
kcInfo.CompanyName = txtCompanyName.Text.Trim();
string strWhere = " GoodsID = '" + kcInfo.GoodsID + "'";
BLL.KCInfo bllkcInfo = new BLL.KCInfo();//实例化BLL层
DataSet ds = new DataSet();
ds = bllkcInfo.GetList(strWhere);
int sum = int.Parse(ds.Tables[0].Rows[0]["商品数量"].ToString());
kcInfo.GoodsNum = sum + int.Parse(numSellGoodsNum.Value.ToString());
switch (flag)
{
case 0:
{
} break;
case 1:
{
if (bll.Add(model)) //将员工信息添加到数据库中，根据返回值判断是否添加成功
{
DataBind(); //窗体登录时绑定数据到DataGridView
ControlStatus();
}
if (!bllkcInfo.Update(kcInfo))
{
MessageBox.Show("未能够把数据添加到仓库中");
}
} break;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.THGoodsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update THGoodsInfo set ");
strSql.Append("KCID=@KCID,");
strSql.Append("GoodsID=@GoodsID,");
strSql.Append("SellID=@SellID,");
strSql.Append("EmployeeID=@EmployeeID,");
strSql.Append("THGoodsName=@THGoodsName,");
strSql.Append("THGoodsNum=@THGoodsNum,");
strSql.Append("THGoodsTime=@THGoodsTime,");
strSql.Append("THGoodsPrice=@THGoodsPrice,");
strSql.Append("THNeedPay=@THNeedPay,");
strSql.Append("THHasPay=@THHasPay,");
strSql.Append("ThGoodsResult=@ThGoodsResult ");
strSql.Append(" where THGoodsID=@THGoodsID ");
SqlParameter[] parameters =
{
new SqlParameter("@THGoodsID", SqlDbType.NVarChar, 50),
new SqlParameter("@KCID", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50),
new SqlParameter("@SellID", SqlDbType.NVarChar, 50),
new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 50),
new SqlParameter("@THGoodsName", SqlDbType.NVarChar, 50),
new SqlParameter("@THGoodsNum", SqlDbType.Int),
new SqlParameter("@THGoodsTime", SqlDbType.DateTime),
new SqlParameter("@THGoodsPrice", SqlDbType.Float),
new SqlParameter("@THNeedPay", SqlDbType.Float),
new SqlParameter("@THHasPay", SqlDbType.Float),
new SqlParameter("@ThGoodsResult", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.THGoodsID;
parameters[1].Value = model.KCID;
parameters[2].Value = model.GoodsID;
parameters[3].Value = model.SellID;
parameters[4].Value = model.EmploayeeID;
parameters[5].Value = model.THGoodsName;
parameters[6].Value = model.THGoodsNum;
parameters[7].Value = model.THGoodsTime;
parameters[8].Value = model.THGoodsPrice;
parameters[9].Value = model.THNeedPay;
parameters[10].Value = model.THHasPay;
parameters[11].Value = model.THGoodsResult;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.THGoodsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into THGoodsInfo(");
strSql.Append("THGoodsID,KCID,GoodsID,SellID,EmployeeID,THGoodsName,THGoodsNum,THGoodsTime,THGoodsPrice,THNeedPay,THHasPay,ThGoodsResult)");
strSql.Append(" values (");
strSql.Append("@THGoodsID,@KCID,@GoodsID,@SellID,@EmployeeID,@THGoodsName,@THGoodsNum,@THGoodsTime,@THGoodsPrice,@THNeedPay,@THHasPay,@ThGoodsResult)");
SqlParameter[] parameters =
{
new SqlParameter("@THGoodsID", SqlDbType.NVarChar, 50),
new SqlParameter("@KCID", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50),
new SqlParameter("@SellID", SqlDbType.NVarChar, 50),
new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 50),
new SqlParameter("@THGoodsName", SqlDbType.NVarChar, 50),
new SqlParameter("@THGoodsNum", SqlDbType.Int),
new SqlParameter("@THGoodsTime", SqlDbType.DateTime),
new SqlParameter("@THGoodsPrice", SqlDbType.Float),
new SqlParameter("@THNeedPay", SqlDbType.Float),
new SqlParameter("@THHasPay", SqlDbType.Float),
new SqlParameter("@ThGoodsResult", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.THGoodsID;
parameters[1].Value = model.KCID;
parameters[2].Value = model.GoodsID;
parameters[3].Value = model.SellID;
parameters[4].Value = model.EmploayeeID;
parameters[5].Value = model.THGoodsName;
parameters[6].Value = model.THGoodsNum;
parameters[7].Value = model.THGoodsTime;
parameters[8].Value = model.THGoodsPrice;
parameters[9].Value = model.THNeedPay;
parameters[10].Value = model.THHasPay;
parameters[11].Value = model.THGoodsResult;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(Model.THGoodsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from THGoodsInfo ");
strSql.Append(" where THGoodsID=@THGoodsID ");
SqlParameter[] parameters =
{
new SqlParameter("@THGoodsID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.GoodsID;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(Model.THGoodsInfo model)
{
return(dal.Delete(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.THGoodsInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.THGoodsInfo model)
{
return(dal.Add(model));
}
