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)); }