public bool UpdateEntity(Model.PurchaseOrdersModel entity)
{
string sql = string.Format("Update purchaseOrders Set orderNumber='{0}',supplier='{1}',person='{2}',telphone='{3}',address='{4}',contract='{5}',orderDate='{6}' Where id={7}",
entity.OrderNumber, entity.SupplierName, entity.Person, entity.Tel, entity.Address, entity.Contract, entity.OrderDate, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0);
}
//几个ID要分清楚
public bool PostPurchaseOrder(int id)
{
Model.PurchaseOrdersModel oneOrder = GetOnePurchaseOrder(id);
if (oneOrder.Status.Equals("已入库"))
{
Exception oe = new Exception();
throw new FaultException <Exception>(oe, "订单已经提交，请务重复提交");
}
List <Model.PurchaseCommodityModel> purchaseCommoditiesList = GetPurchaseCommoditiesByID(id).ToList();
IDAL.ICommodityService commodityService = new MSSQLDAL.CommodityService();
foreach (Model.PurchaseCommodityModel onePurchaseCommodity in purchaseCommoditiesList)
{
Model.CommodityModel commodityModel = new Model.CommodityModel();
commodityModel.ID = onePurchaseCommodity.CommodityID;
commodityModel.Manufacturer = onePurchaseCommodity.CommodityManufacturer;
commodityModel.Name = onePurchaseCommodity.CommodityName;
commodityModel.Type = onePurchaseCommodity.CommodityType;
commodityModel.Unit = onePurchaseCommodity.CommodityUnit;
commodityModel.UnitPrice = onePurchaseCommodity.CommodityUnitPrice;
commodityModel.Inventory = onePurchaseCommodity.CommodityInventory + onePurchaseCommodity.Count;
//这儿不会出现异常了吧，否则要回滚
commodityService.UpdateEntity(commodityModel);
}
oneOrder.Status = "已入库";
return(new MSSQLDAL.PurchaseOrderService().UpdateEntity(oneOrder));
}
/// <summary>
/// 展示订单详情
/// </summary>
private void GetOrderDetail()
{
if (listViewOrders.SelectedItems.Count > 0)
{
toolStripButton4.Enabled = true;
toolStripButton5.Enabled = true;
toolStripButton6.Enabled = true;
toolStripButton8.Enabled = true;
ListViewItem item = listViewOrders.SelectedItems[0];
selectOrder = (Model.PurchaseOrdersModel)item.Tag;
labelOrderNumber.Text = "[" + selectOrder.OrderNumber + "]";
labelOrderDate.Text = "[" + selectOrder.OrderDate.ToString("yyyy-MM-dd HH:mm:ss") + "]";
labelContract.Text = "[" + selectOrder.Contract + "]";
//labelStatus.Text = "[" + selectOrder.Status + "]";
//if (selectOrder.Status.Equals("已入库"))
//{
// toolStripButton4.Enabled = false;
// toolStripButton5.Enabled = false;
// toolStripButton6.Enabled = false;
//}
labelSupplierName.Text = "[" + selectOrder.SupplierName + "]";
labelTel.Text = "[" + selectOrder.Person + "||" + selectOrder.Tel + "]";
labelAddress.Text = "[" + selectOrder.Address + "]";
BLLPurchaseOrders.PurchaseManagerServiceClient purchaseClient = WCFServiceBLL.GetPurchaseService();
dataGridViewPurchaseList.DataSource = purchaseClient.GetPurchaseCommoditiesByID(selectOrder.ID);
}
else
{
clearShowOrderItmList();
}
}
public bool UpdateEntity(Model.PurchaseOrdersModel entity)
{
string sql = string.Format("Update PurchaseOrders Set OrderNumber='{0}',SupplierName='{1}',Tel='{2}',Address='{3}',Contract='{4}',Status='{5}',OrderDate=to_date('{6}','yyyy-MM-dd') Where ID={7}",
entity.OrderNumber, entity.SupplierName, entity.Tel, entity.Address, entity.Contract, entity.Status, entity.OrderDate.ToString("yyyy-MM-dd"), entity.ID);
return(OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, CommandType.Text, sql, null) > 0);
}
public Model.PurchaseOrdersModel AddEntity(Model.PurchaseOrdersModel entity)
{
entity.ID = GetNewID();
string sql = string.Format("insert into purchaseOrders(ID,OrderNumber,SupplierName,Tel,Address,Contract,Status,OrderDate) values({0},'{1}','{2}','{3}','{4}','{5}','{6}',to_date('{7}','yyyy-mm-dd'))",
entity.ID, entity.OrderNumber, entity.SupplierName, entity.Tel, entity.Address, entity.Contract, entity.Status, entity.OrderDate.ToString("yyyy-MM-dd"));
if (OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionString, CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 修改订单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripButton2_Click(object sender, EventArgs e)
{
if (listViewOrders.SelectedItems.Count > 0)
{
Model.PurchaseOrdersModel onePurchase = (Model.PurchaseOrdersModel)listViewOrders.SelectedItems[0].Tag;
orderID = onePurchase.ID;
AddPurchaseOrder updatePurchaseOrder = new AddPurchaseOrder(onePurchase.ID);
if (updatePurchaseOrder.ShowDialog() == DialogResult.OK)
{
GetPurchaseOrdersList();
//修改中ListView失去焦点
GetUpdateOrderDetail();
}
}
}
public Model.PurchaseOrdersModel AddEntity(Model.PurchaseOrdersModel entity)
{
string sql = string.Format("insert into purchaseOrders(orderNumber,supplier,person,telphone,address,contract,OrderDate) values({0},'{1}','{2}','{3}','{4}','{5}','{6}')",
entity.OrderNumber, entity.SupplierName, entity.Person, entity.Tel, entity.Address, entity.Contract, entity.OrderDate);
int resRows = MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null);
if (resRows > 0)
{
int curID = Convert.ToInt32(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, "select ident_current('purchaseOrders')", null).ToString());
entity.ID = curID;
return(entity);
}
else
{
return(null);
}
}
public List <Model.PurchaseOrdersModel> GetEntities(string sqlWhere)
{
string sql = string.Format("select * from PurchaseOrders where 1=1 {0}", sqlWhere);
List <Model.PurchaseOrdersModel> listPurchaseOrders = new List <Model.PurchaseOrdersModel>();
using (OracleDataReader odr = OracleHelper.ExecuteReader(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null))
{
while (odr.Read())
{
Model.PurchaseOrdersModel purchaseOrderModel = new Model.PurchaseOrdersModel();
purchaseOrderModel.ID = odr.GetInt32(0);
purchaseOrderModel.OrderNumber = odr.IsDBNull(1) ? "" : odr.GetString(1);
purchaseOrderModel.SupplierName = odr.IsDBNull(2) ? "" : odr.GetString(2);
purchaseOrderModel.Tel = odr.IsDBNull(3) ? "" : odr.GetString(3);
purchaseOrderModel.Address = odr.IsDBNull(4) ? "" : odr.GetString(4);
purchaseOrderModel.Contract = odr.IsDBNull(5) ? "" : odr.GetString(5);
purchaseOrderModel.Status = odr.IsDBNull(6) ? "" : odr.GetString(6);
purchaseOrderModel.OrderDate = odr.IsDBNull(7) ? DateTime.Now : odr.GetDateTime(7);
listPurchaseOrders.Add(purchaseOrderModel);
}
}
return(listPurchaseOrders);
}
private void buttonOK_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(textBoxOrderNumber.Text))
{
MessageBox.Show("订单编号不能为空");
return;
}
Model.PurchaseOrdersModel purchaseOrder = new Model.PurchaseOrdersModel();
purchaseOrder.OrderNumber = textBoxOrderNumber.Text;
purchaseOrder.SupplierName = combSupplier.Text;
purchaseOrder.Person = textBoxPerson.Text;
purchaseOrder.Address = textBoxAddress.Text;
purchaseOrder.Tel = textBoxTel.Text;
purchaseOrder.Contract = textBoxContract.Text;
purchaseOrder.OrderDate = DateTime.Now;
BLLPurchaseOrders.PurchaseManagerServiceClient purchaseClient = WCFServiceBLL.GetPurchaseService();
if (isUpdate)
{
purchaseOrder.ID = orderID;
if (!purchaseClient.UpdatePurchaseOrder(purchaseOrder))
{
MessageBox.Show("订单更新失败");
this.DialogResult = DialogResult.None;
}
}
else
{
var order = purchaseClient.AddPurchaseOrder(purchaseOrder);
AddSalesID = order.ID;
if (order == null)
{
MessageBox.Show("新增订单失败");
this.DialogResult = DialogResult.None;
return;
}
}
}
private void GetUpdateOrderDetail()
{
toolStripButton4.Enabled = true;
toolStripButton5.Enabled = true;
toolStripButton6.Enabled = true;
toolStripButton8.Enabled = true;
//ListViewItem item = listViewOrders.SelectedItems[0];
//selectOrder = (Model.SalesOrdersModel)item.Tag;
BLLPurchaseOrders.PurchaseManagerServiceClient purchaseClient = WCFServiceBLL.GetPurchaseService();
selectOrder = purchaseClient.GetOnePurchaseOrder(orderID);
labelOrderNumber.Text = "[" + selectOrder.OrderNumber + "]";
labelOrderDate.Text = "[" + selectOrder.OrderDate.ToString("yyyy-MM-dd HH:mm:ss") + "]";
labelContract.Text = "[" + selectOrder.Contract + "]";
labelSupplierName.Text = "[" + selectOrder.SupplierName + "]";
labelAddress.Text = "[" + selectOrder.Address + "]";
labelTel.Text = "[" + selectOrder.Person + "||" + selectOrder.Tel + "]";
BLLPurchaseOrders.PurchaseManagerServiceClient client = WCFServiceBLL.GetPurchaseService();
List <Model.PurchaseCommodityModel> purchaseCommoditiesList = client.GetPurchaseCommoditiesByID(selectOrder.ID).ToList();
dataGridViewPurchaseList.DataSource = purchaseCommoditiesList;
}
public bool UpdatePurchaseOrder(Model.PurchaseOrdersModel onePurchaseOrder)
{
//return new OracleDAL.PurchaseOrderService().UpdateEntity(onePurchaseOrder);
return(dataFactory.PurchaseOrderDal.UpdateEntity(onePurchaseOrder));
}
public Model.PurchaseOrdersModel AddPurchaseOrder(Model.PurchaseOrdersModel purchaseOrder)
{
//return new OracleDAL.PurchaseOrderService().AddEntity(purchaseOrder);
return(dataFactory.PurchaseOrderDal.AddEntity(purchaseOrder));
}
