/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.JHGoodsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into JHGoodsInfo(");
strSql.Append("GoodsID,EmployeeID,CompanyName,DepotName,GoodsName,GoodsNum,GoodsUnit,GoodsJHPrice,GoodsSellPrice,GoodsNeedPay,GoodsHasPay,GoodsRemark,GoodsTime)");
strSql.Append(" values (");
strSql.Append("@GoodsID,@EmployeeID,@CompanyName,@DepotName,@GoodsName,@GoodsNum,@GoodsUnit,@GoodsJHPrice,@GoodsSellPrice,@GoodsNeedPay,@GoodsHasPay,@GoodsRemark,@GoodsTime)");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50),
new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50),
new SqlParameter("@DepotName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsNum", SqlDbType.Int),
new SqlParameter("@GoodsUnit", SqlDbType.NVarChar, 20),
new SqlParameter("@GoodsJHPrice", SqlDbType.Float),
new SqlParameter("@GoodsSellPrice", SqlDbType.Float),
new SqlParameter("@GoodsNeedPay", SqlDbType.Float),
new SqlParameter("@GoodsHasPay", SqlDbType.Float),
new SqlParameter("@GoodsRemark", SqlDbType.NVarChar, 200),
new SqlParameter("@GoodsTime", SqlDbType.DateTime)
};
parameters[0].Value = model.GoodsID;
parameters[1].Value = model.EmployeeID;
parameters[2].Value = model.CompanyName;
parameters[3].Value = model.DepotName;
parameters[4].Value = model.GoodsName;
parameters[5].Value = model.GoodsNum;
parameters[6].Value = model.GoodsUnit;
parameters[7].Value = model.GoodsJHPrice;
parameters[8].Value = model.GoodsSellPrice;
parameters[9].Value = model.GoodsNeedPay;
parameters[10].Value = model.GoodsHasPay;
parameters[11].Value = model.GoodsRemark;
parameters[12].Value = model.GoodsTime;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(Model.JHGoodsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from JHGoodsInfo ");
strSql.Append(" where GoodsID=@GoodsID ");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsID", 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.JHGoodsInfo model)
{
return(dal.Delete(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.JHGoodsInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.JHGoodsInfo model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.JHGoodsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JHGoodsInfo set ");
strSql.Append("EmployeeID=@EmployeeID,");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("DepotName=@DepotName,");
strSql.Append("GoodsName=@GoodsName,");
strSql.Append("GoodsNum=@GoodsNum,");
strSql.Append("GoodsUnit=@GoodsUnit,");
strSql.Append("GoodsJHPrice=@GoodsJHPrice,");
strSql.Append("GoodsSellPrice=@GoodsSellPrice,");
strSql.Append("GoodsNeedPay=@GoodsNeedPay,");
strSql.Append("GoodsHasPay=@GoodsHasPay,");
strSql.Append("GoodsRemark=@GoodsRemark,");
strSql.Append("GoodsTime=@GoodsTime ");
strSql.Append(" where GoodsID=@GoodsID ");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsID", SqlDbType.NVarChar, 50),
new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50),
new SqlParameter("@DepotName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsName", SqlDbType.NVarChar, 50),
new SqlParameter("@GoodsNum", SqlDbType.Int),
new SqlParameter("@GoodsUnit", SqlDbType.NVarChar, 20),
new SqlParameter("@GoodsJHPrice", SqlDbType.Float),
new SqlParameter("@GoodsSellPrice", SqlDbType.Float),
new SqlParameter("@GoodsNeedPay", SqlDbType.Float),
new SqlParameter("@GoodsHasPay", SqlDbType.Float),
new SqlParameter("@GoodsRemark", SqlDbType.NVarChar, 200),
new SqlParameter("@GoodsTime", SqlDbType.DateTime),
new SqlParameter("@Flag", SqlDbType.Int)
};
parameters[0].Value = model.GoodsID;
parameters[1].Value = model.EmployeeID;
parameters[2].Value = model.CompanyName;
parameters[3].Value = model.DepotName;
parameters[4].Value = model.GoodsName;
parameters[5].Value = model.GoodsNum;
parameters[6].Value = model.GoodsUnit;
parameters[7].Value = model.GoodsJHPrice;
parameters[8].Value = model.GoodsSellPrice;
parameters[9].Value = model.GoodsNeedPay;
parameters[10].Value = model.GoodsHasPay;
parameters[11].Value = model.GoodsRemark;
parameters[12].Value = model.GoodsTime;
parameters[13].Value = model.Flag;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void toolSave_Click(object sender, EventArgs e)
{
if (txtGoodsID.Text == "" || txtGoodsName.Text == "" || cboComName.Text == "" || cboDepotName.Text == "")
{
MessageBox.Show("请将信息添加完整！");
return;
}
Model.JHGoodsInfo model = new Model.JHGoodsInfo();//实例化model层
model.GoodsID = txtGoodsID.Text.Trim();
model.EmployeeID = cboEmployeeID.Text.Trim();
model.CompanyName = cboComName.Text.Trim();
model.DepotName = cboDepotName.Text.Trim();
model.GoodsName = txtGoodsName.Text;
model.GoodsNum = int.Parse(numGoodsNum.Value.ToString());
model.GoodsUnit = cmbGoodsUnit.Text.Trim();
model.GoodsJHPrice = float.Parse(txtGoodsJHPrice.Text.Trim());
model.GoodsSellPrice = float.Parse(txtSellGoodsPrice.Text.Trim());
model.GoodsNeedPay = float.Parse(txtGoodsNeedPrice.Text.Trim());
model.GoodsHasPay = float.Parse(txtGoodsHasPay.Text.Trim());
model.GoodsRemark = txtRemarks.Text;
model.GoodsTime = DateTime.Parse(dateTimePicker1.Text);
BLL.JHGoodsInfo bll = new BLL.JHGoodsInfo();//实例化BLL层
Model.KCInfo kcInfo = new Model.KCInfo();
kcInfo.GoodsID = txtGoodsID.Text.Trim();
kcInfo.GoodsName = txtGoodsName.Text;
kcInfo.CompanyName = cboComName.Text.Trim();
kcInfo.DepotName = cboDepotName.Text.Trim();
kcInfo.GoodsNum = int.Parse(numGoodsNum.Value.ToString());
BLL.KCInfo bllkcInfo = new BLL.KCInfo();//实例化BLL层
switch (flag)
{
case 0:
{
} break;
case 1:
{
if (bll.Add(model)) //将员工信息添加到数据库中，根据返回值判断是否添加成功
{
DataBind(); //窗体登录时绑定数据到DataGridView
ControlStatus();
}
if (!bllkcInfo.Add(kcInfo))
{
MessageBox.Show("未能够把数据添加到仓库中");
}
} break;
case 2:
{
if (bll.Update(model)) //根据返回布尔值判断是否修改数据成功
{
DataBind(); //窗体登录时绑定数据到DataGridView
ControlStatus();
}
if (!bllkcInfo.Update(kcInfo))
{
MessageBox.Show("未能够把数据修改到仓库中");
}
} break;
}
}
