/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Dong.Model.InGoods model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update InGoods set ");
strSql.Append("GoodsCode=@GoodsCode,");
strSql.Append("Price=@Price,");
strSql.Append("Counts=@Counts,");
strSql.Append("IDate=@IDate,");
strSql.Append("Supplier=@Supplier,");
strSql.Append("Oper=@Oper,");
strSql.Append("Remark=@Remark");
strSql.Append(" where PCode=@PCode ");
OleDbParameter[] parameters =
{
new OleDbParameter("@GoodsCode", OleDbType.VarChar, 50),
new OleDbParameter("@Price", OleDbType.Double),
new OleDbParameter("@Counts", OleDbType.Integer, 4),
new OleDbParameter("@IDate", OleDbType.Date),
new OleDbParameter("@Supplier", OleDbType.Integer, 4),
new OleDbParameter("@Oper", OleDbType.VarChar, 50),
new OleDbParameter("@Remark", OleDbType.VarChar, 0),
new OleDbParameter("@PCode", OleDbType.VarChar, 50)
};
parameters[0].Value = model.GoodsCode;
parameters[1].Value = model.Price;
parameters[2].Value = model.Counts;
parameters[3].Value = model.IDate;
parameters[4].Value = model.Supplier;
parameters[5].Value = model.Oper;
parameters[6].Value = model.Remark;
parameters[7].Value = model.PCode;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dong.Model.InGoods DataRowToModel(DataRow row)
{
Dong.Model.InGoods model = new Dong.Model.InGoods();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["PCode"] != null)
{
model.PCode = row["PCode"].ToString();
}
if (row["GoodsCode"] != null)
{
model.GoodsCode = row["GoodsCode"].ToString();
}
//model.Price=row["Price"].ToString();
if (row["Counts"] != null && row["Counts"].ToString() != "")
{
model.Counts = int.Parse(row["Counts"].ToString());
}
if (row["IDate"] != null && row["IDate"].ToString() != "")
{
model.IDate = DateTime.Parse(row["IDate"].ToString());
}
if (row["Supplier"] != null && row["Supplier"].ToString() != "")
{
model.Supplier = int.Parse(row["Supplier"].ToString());
}
if (row["Oper"] != null)
{
model.Oper = row["Oper"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 进货单保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
Dong.BLL.InGoods bInGoods = new Dong.BLL.InGoods();
Dong.Model.InGoods mInGoods = new Dong.Model.InGoods();
Dong.BLL.GoodsInfo bGoodsInfo = new Dong.BLL.GoodsInfo();
Dong.Model.GoodsInfo mGoodsInfo = new Dong.Model.GoodsInfo();
for (int i = 0; i < dGV.Rows.Count; i++)
{
//添加进货信息
mGoodsInfo = bGoodsInfo.GetModel(dGV.Rows[i].Cells[1].Value.ToString());
mInGoods.PCode = lblCode.Text;
mInGoods.GoodsCode = dGV.Rows[i].Cells[1].Value.ToString();
mInGoods.Price = double.Parse(dGV.Rows[i].Cells[3].Value.ToString());
mInGoods.Counts = int.Parse(dGV.Rows[i].Cells[4].Value.ToString());
mInGoods.IDate = DateTime.Now.Date;
mInGoods.Oper = txtOper.Text;
mInGoods.Supplier = mGoodsInfo.Supplier;
mInGoods.Remark = "";
bInGoods.Add(mInGoods);
//修改商品信息
//进货价格
double oldPrice1 = (double)mGoodsInfo.Price1;
mGoodsInfo.Price1 = double.Parse(dGV.Rows[i].Cells[3].Value.ToString());
//数量
mGoodsInfo.Counts = mGoodsInfo.Counts + int.Parse(dGV.Rows[i].Cells[4].Value.ToString());
//成本价
int totalCount = (int)mGoodsInfo.Counts + int.Parse(dGV.Rows[i].Cells[4].Value.ToString());
double totalPrice = (oldPrice1 * (int)mGoodsInfo.Counts) + (double.Parse(dGV.Rows[i].Cells[3].Value.ToString()) * int.Parse(dGV.Rows[i].Cells[4].Value.ToString()));
double cbPrice = totalPrice / totalCount;
mGoodsInfo.Price2 = cbPrice;
bGoodsInfo.Update(mGoodsInfo);
}
frmInput frm = (frmInput)this.Owner;
frm.refreshData();
this.Close();
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Dong.Model.InGoods model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into InGoods(");
strSql.Append("PCode,GoodsCode,Price,Counts,IDate,Supplier,Oper,Remark)");
strSql.Append(" values (");
strSql.Append("@PCode,@GoodsCode,@Price,@Counts,@IDate,@Supplier,@Oper,@Remark)");
OleDbParameter[] parameters =
{
new OleDbParameter("@PCode", OleDbType.VarChar, 50),
new OleDbParameter("@GoodsCode", OleDbType.VarChar, 50),
new OleDbParameter("@Price", OleDbType.Double),
new OleDbParameter("@Counts", OleDbType.Integer, 4),
new OleDbParameter("@IDate", OleDbType.Date),
new OleDbParameter("@Supplier", OleDbType.Integer, 4),
new OleDbParameter("@Oper", OleDbType.VarChar, 50),
new OleDbParameter("@Remark", OleDbType.VarChar, 0)
};
parameters[0].Value = model.PCode;
parameters[1].Value = model.GoodsCode;
parameters[2].Value = model.Price;
parameters[3].Value = model.Counts;
parameters[4].Value = model.IDate;
parameters[5].Value = model.Supplier;
parameters[6].Value = model.Oper;
parameters[7].Value = model.Remark;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dong.Model.InGoods GetModel(string PCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,PCode,GoodsCode,Price,Counts,IDate,Supplier,Oper,Remark from InGoods ");
strSql.Append(" where PCode=@PCode ");
OleDbParameter[] parameters =
{
new OleDbParameter("@PCode", OleDbType.VarChar, 50)
};
parameters[0].Value = PCode;
Dong.Model.InGoods model = new Dong.Model.InGoods();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
