public bool UpdateEntity(Model.SalesCommodityModel entity)
{
string sql = string.Format("update SALESCOMMODITY set SALESORDERID={0},COMMODITYID={1},COUNT={2},SALESPRICE={3},TOTALPRICE={4} where id={5}",
entity.SalesOrderID, entity.CommodityID, entity.Count, entity.SalesPrice, entity.TotalPrice, entity.ID);
return(OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null) > 0);
}
public bool UpdateEntity(Model.SalesCommodityModel entity)
{
string sql = string.Format("update salesCommodity set orderId={0},commodityId={1},count={2},salesPrice={3},totalPrice={4} where id={5}",
entity.SalesOrderID, entity.CommodityID, entity.Count, entity.SalesPrice, entity.TotalPrice, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null) > 0);
}
public List <Model.SalesCommodityModel> GetEntities(string sqlWhere)
{
string sql = string.Format("select * from View_Sales where 1=1 {0}", sqlWhere);
List <Model.SalesCommodityModel> listSalesCommodity = new List <Model.SalesCommodityModel>();
using (SqlDataReader odr = MSSqlHelper.ExecuteReader(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null))
{
while (odr.Read())
{
Model.SalesCommodityModel salesCommodityModel = new Model.SalesCommodityModel();
salesCommodityModel.ID = odr.GetInt32(10);
salesCommodityModel.SalesOrderID = odr.GetInt32(0);
salesCommodityModel.CommodityID = odr.GetInt32(14);
salesCommodityModel.CommodityName = odr.IsDBNull(15) ? "" : odr.GetString(15);
salesCommodityModel.CommodityType = odr.IsDBNull(18) ? "" : odr.GetString(18);
salesCommodityModel.CommodityManufacturer = odr.IsDBNull(19) ? "" : odr.GetString(19);
//salesCommodityModel.CommodityInventory = odr.IsDBNull(6) ? 0 : odr.GetInt32(6);
salesCommodityModel.CommodityUnitPrice = odr.IsDBNull(16) ? 0M : odr.GetDecimal(16);
salesCommodityModel.CommodityUnit = odr.IsDBNull(17) ? "" : odr.GetString(17);
salesCommodityModel.Count = odr.IsDBNull(11) ? 0 : odr.GetInt32(11);
salesCommodityModel.SalesPrice = odr.IsDBNull(12) ? 0M : odr.GetDecimal(12);
salesCommodityModel.TotalPrice = odr.IsDBNull(13) ? 0M : odr.GetDecimal(13);
listSalesCommodity.Add(salesCommodityModel);
}
}
return(listSalesCommodity);
}
public List <Model.SalesCommodityModel> GetEntities(string sqlWhere)
{
string sql = string.Format("select * from v_salesCommodity where 1=1 {0}", sqlWhere);
List <Model.SalesCommodityModel> listSalesCommodity = new List <Model.SalesCommodityModel>();
using (OracleDataReader odr = OracleHelper.ExecuteReader(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null))
{
while (odr.Read())
{
Model.SalesCommodityModel salesCommodityModel = new Model.SalesCommodityModel();
salesCommodityModel.ID = odr.GetInt32(0);
salesCommodityModel.SalesOrderID = odr.GetInt32(1);
salesCommodityModel.CommodityID = odr.GetInt32(2);
salesCommodityModel.CommodityName = odr.IsDBNull(3) ? "" : odr.GetString(3);
salesCommodityModel.CommodityType = odr.IsDBNull(4) ? "" : odr.GetString(4);
salesCommodityModel.CommodityManufacturer = odr.IsDBNull(5) ? "" : odr.GetString(5);
salesCommodityModel.CommodityInventory = odr.IsDBNull(6) ? 0 : odr.GetInt32(6);
salesCommodityModel.CommodityUnitPrice = odr.IsDBNull(7) ? 0 : odr.GetInt32(7);
salesCommodityModel.CommodityUnit = odr.IsDBNull(8) ? "" : odr.GetString(8);
salesCommodityModel.Count = odr.IsDBNull(9) ? 0 : odr.GetInt32(9);
salesCommodityModel.SalesPrice = odr.IsDBNull(10) ? 0 : odr.GetDecimal(10);
salesCommodityModel.TotalPrice = odr.IsDBNull(11) ? 0 : odr.GetDecimal(11);
listSalesCommodity.Add(salesCommodityModel);
}
}
return(listSalesCommodity);
}
public Model.SalesCommodityModel AddEntity(Model.SalesCommodityModel entity)
{
string sql = string.Format("insert into salesCommodity(orderId,commodityId,count,salesPrice,totalPrice) values({0},{1},{2},{3},{4})",
entity.SalesOrderID, entity.CommodityID, entity.Count, entity.SalesPrice, entity.TotalPrice);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
public Model.SalesCommodityModel AddEntity(Model.SalesCommodityModel entity)
{
entity.ID = GetNewID();
string sql = string.Format("insert into SALESCOMMODITY(ID,SALESORDERID,COMMODITYID,COUNT,SALESPRICE,TOTALPRICE) values({0},{1},{2},{3},{4},{5})",
entity.ID, entity.SalesOrderID, entity.CommodityID, entity.Count, entity.SalesPrice, entity.TotalPrice);
if (OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
private void AddSalesCommodities_Load(object sender, EventArgs e)
{
if (IsUpdate)
{
//加载页面
BLLSalesOrders.SalesManagerServiceClient salesClinet = WCFServiceBLL.GetSalesService();
Model.SalesCommodityModel salesCommodity = salesClinet.GetOneSalesCommodityByID(CID);
UpdateID = salesCommodity.ID;
SalesCommodityID = salesCommodity.CommodityID;
textBoxName.Text = salesCommodity.CommodityName;
labelManufacturer.Text = "[" + salesCommodity.CommodityManufacturer + "]";
labelType.Text = "[" + salesCommodity.CommodityType + "]";
textBoxCount.Text = salesCommodity.Count.ToString();
textBoxPrice.Text = salesCommodity.SalesPrice.ToString();
labelUnit.Text = "[" + salesCommodity.CommodityUnit + "]";
}
}
public Model.SalesCommodityModel AddSalesCommodity(Model.SalesCommodityModel oneSalesCommodity)
{
return(new OracleDAL.SalesCommodityService().AddSalesCommodity(oneSalesCommodity));
}
public Model.SalesCommodityModel AddSalesCommodity(Model.SalesCommodityModel oneSalesCommodity)
{
//return new OracleDAL.SalesCommodityService().AddEntity(oneSalesCommodity);
return(dataFactory.SalesCommodityDal.AddEntity(oneSalesCommodity));
}
public bool UpdateCommodity(Model.SalesCommodityModel commodity)
{
//return new OracleDAL.SalesCommodityService().UpdateEntity(commodity);
return(dataFactory.SalesCommodityDal.UpdateEntity(commodity));
}
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
{
MessageBox.Show("数量或金额有误！");
return;
}
Model.SalesCommodityModel oneSalesCommodity = new Model.SalesCommodityModel();
oneSalesCommodity.ID = UpdateID;
oneSalesCommodity.SalesOrderID = SalesOrderID;
oneSalesCommodity.CommodityID = SalesCommodityID;
oneSalesCommodity.Count = count;
oneSalesCommodity.SalesPrice = price;
oneSalesCommodity.TotalPrice = count * price;//这儿是个业务
BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService();
if (client.UpdateCommodity(oneSalesCommodity))
{
MessageBox.Show("更新成功!");
}
}
else
{
if (SalesCommodityID == 0)
{
MessageBox.Show("请选择一个产品");
return;
}
int count = 0;
decimal price = 0.0M;
try
{
count = int.Parse(textBoxCount.Text);
price = decimal.Parse(textBoxPrice.Text);
}
catch
{
MessageBox.Show("数量或金额有误！");
return;
}
Model.SalesCommodityModel oneSalesCommodity = new Model.SalesCommodityModel();
oneSalesCommodity.SalesOrderID = SalesOrderID;
oneSalesCommodity.CommodityID = SalesCommodityID;
oneSalesCommodity.Count = count;
oneSalesCommodity.SalesPrice = price;
oneSalesCommodity.TotalPrice = count * price;//这儿是个业务
BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService();
oneSalesCommodity = client.AddSalesCommodity(oneSalesCommodity);
if (oneSalesCommodity.Equals(null))
{
MessageBox.Show("保存失败");
this.DialogResult = DialogResult.None;
}
}
}
