public bool UpdateEntity(Model.PurchaseCommodityModel entity)
{
string sql = string.Format("update purchasecommodity set purchaseorderid={0},commodityid={1},count={2},purchaseprice={3},totalprice={4} where id={5}",
entity.PurchaseOrderID, entity.CommodityID, entity.Count, entity.PurchasePrice, entity.TotalPrice, entity.ID);
return(OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null) > 0);
}
public List <Model.PurchaseCommodityModel> GetEntities(string sqlWhere)
{
string sql = string.Format("select * from v_purchasecommodity where 1=1 {0}", sqlWhere);
List <Model.PurchaseCommodityModel> listPurchaseCommodities = new List <Model.PurchaseCommodityModel>();
using (OracleDataReader odr = OracleHelper.ExecuteReader(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null))
{
while (odr.Read())
{
Model.PurchaseCommodityModel purchaseCommodityModel = new Model.PurchaseCommodityModel();
purchaseCommodityModel.ID = odr.GetInt32(0);
//由于数据库在该字段设置了值太大，所以溢出
purchaseCommodityModel.PurchaseOrderID = odr.GetInt32(1);
purchaseCommodityModel.CommodityID = odr.GetInt32(2);
purchaseCommodityModel.CommodityName = odr.IsDBNull(3) ? "" : odr.GetString(3);
purchaseCommodityModel.CommodityType = odr.IsDBNull(4) ? "" : odr.GetString(4);
purchaseCommodityModel.CommodityManufacturer = odr.IsDBNull(5) ? "" : odr.GetString(5);
purchaseCommodityModel.CommodityInventory = odr.IsDBNull(6) ? 0 : odr.GetInt32(6);
purchaseCommodityModel.CommodityUnitPrice = odr.IsDBNull(7) ? 0 : odr.GetDecimal(7);
purchaseCommodityModel.CommodityUnit = odr.IsDBNull(8) ? "": odr.GetString(8);
purchaseCommodityModel.Count = odr.IsDBNull(9) ? 0 : odr.GetInt32(9);
purchaseCommodityModel.PurchasePrice = odr.IsDBNull(10) ? 0 : odr.GetInt32(10);
purchaseCommodityModel.TotalPrice = odr.IsDBNull(11) ? 0 : odr.GetInt32(11);
listPurchaseCommodities.Add(purchaseCommodityModel);
}
}
return(listPurchaseCommodities);
}
public Model.PurchaseCommodityModel AddEntity(Model.PurchaseCommodityModel entity)
{
entity.ID = GetNewID();
string sql = string.Format("insert into purchasecommodity(id,purchaseorderid,commodityid,count,purchaseprice,totalprice) values({0},{1},{2},{3},{4},{5})",
entity.ID, entity.PurchaseOrderID, entity.CommodityID, entity.Count, entity.PurchasePrice, entity.TotalPrice);
if (OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
public Model.PurchaseCommodityModel AddEntity(Model.PurchaseCommodityModel entity)
{
string sql = string.Format("insert into purchaseCommodity(orderId,commodityId,count,purchasePrice,totalPrice) values({0},{1},{2},{3},{4})",
entity.PurchaseOrderID, entity.CommodityID, entity.Count, entity.PurchasePrice, entity.TotalPrice);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null) > 0)
{
//int curID = Convert.ToInt32(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, "select ident_current('purchasecommodity')", null).ToString());
//entity.ID = curID;
return(entity);
}
else
{
return(null);
}
}
private void AddPurchaseCommodities_Load(object sender, EventArgs e)
{
if (IsUpdate)
{
BLLPurchaseOrders.PurchaseManagerServiceClient purchaseClient = WCFServiceBLL.GetPurchaseService();
Model.PurchaseCommodityModel onePurchaseCommodity = purchaseClient.GetOnePurchaseCommoditiesByID(CID);
PurchaseOrderID = onePurchaseCommodity.PurchaseOrderID;
PurchaseCommodityID = onePurchaseCommodity.CommodityID;
textBoxName.Text = onePurchaseCommodity.CommodityName;
labelType.Text = "[" + onePurchaseCommodity.CommodityType + "]";
labelManufacturer.Text = "[" + onePurchaseCommodity.CommodityManufacturer + "]";
textBoxPrice.Text = onePurchaseCommodity.PurchasePrice.ToString();
textBoxCount.Text = onePurchaseCommodity.Count.ToString();
labelUnit.Text = "[" + onePurchaseCommodity.CommodityUnit + "]";
}
}
public Model.PurchaseCommodityModel AddPurchaseCommodityModel(Model.PurchaseCommodityModel onePurchaseCommodity)
{
//return new OracleDAL.PurchaseCommodityService().AddEntity(onePurchaseCommodity);
return(dataFactory.PurchaseCommdityDal.AddEntity(onePurchaseCommodity));
}
public bool UpdatePurchaseCommodity(Model.PurchaseCommodityModel model)
{
//return new OracleDAL.PurchaseCommodityService().UpdateEntity(model);
return(dataFactory.PurchaseCommdityDal.UpdateEntity(model));
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (IsUpdate)
{
int count = 0;
decimal price = 0.0M;
try
{
count = int.Parse(textBoxCount.Text);
price = decimal.Parse(textBoxPrice.Text);
}
catch
{
Exception oe = new Exception();
throw new FaultException <Exception>(oe, "数量或金额有误");
}
Model.PurchaseCommodityModel purchaseCommodity = new Model.PurchaseCommodityModel();
purchaseCommodity.Count = count;
purchaseCommodity.PurchasePrice = price;
purchaseCommodity.TotalPrice = count * price;
purchaseCommodity.PurchaseOrderID = PurchaseOrderID;
purchaseCommodity.CommodityID = PurchaseCommodityID;
purchaseCommodity.ID = CID;
BLLPurchaseOrders.PurchaseManagerServiceClient purchaseClient = WCFServiceBLL.GetPurchaseService();
if (purchaseClient.UpdatePurchaseCommodity(purchaseCommodity))
{
MessageBox.Show("更新成功!");
}
}
else
{
if (PurchaseCommodityID == 0)
{
MessageBox.Show("请选择一件产品");
return;
}
int count = 0;
decimal price = 0.0M;
try
{
count = int.Parse(textBoxCount.Text);
price = decimal.Parse(textBoxPrice.Text);
}
catch
{
Exception oe = new Exception();
throw new FaultException <Exception>(oe, "数量或金额有误");
}
Model.PurchaseCommodityModel purchaseCommodity = new Model.PurchaseCommodityModel();
purchaseCommodity.Count = count;
purchaseCommodity.PurchasePrice = price;
purchaseCommodity.TotalPrice = count * price;
purchaseCommodity.PurchaseOrderID = PurchaseOrderID;
purchaseCommodity.CommodityID = PurchaseCommodityID;
purchaseCommodity = new BLLPurchaseOrders.PurchaseManagerServiceClient().AddPurchaseCommodityModel(purchaseCommodity);
if (purchaseCommodity.Equals(null))
{
MessageBox.Show("保存失败");
this.DialogResult = DialogResult.None;
}
}
}
