/// <summary> /// 手动更新销售单总价 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripButton8_Click(object sender, EventArgs e) { BLLSalesOrders.SalesManagerServiceClient salesClient = WCFServiceBLL.GetSalesService(); if (listViewOrders.SelectedItems.Count > 0) { decimal refreshTotalPrice = 0.0M; SalesOrdersModel selectedSalesOrder = listViewOrders.SelectedItems[0].Tag as Model.SalesOrdersModel; List <Model.SalesCommodityModel> listSalesCommoditys = salesClient.GetSalesCommoditiesByID(selectedSalesOrder.ID).ToList(); foreach (SalesCommodityModel orderItem in listSalesCommoditys) { refreshTotalPrice += orderItem.TotalPrice; } selectedSalesOrder.Contract = refreshTotalPrice.ToString(); if (salesClient.UpdateSalesOrder(selectedSalesOrder)) { labelContract.Text = selectedSalesOrder.Contract; } else { MessageBox.Show("更新订单总价失败!"); } } else { MessageBox.Show("请选择一条订单"); } }
public bool UpdateEntity(SalesOrdersModel entity) { //OrderNumber 这儿写上吧,实际业务里不能被修改 string sql = string.Format("Update salesOrders Set orderNumber='{0}',customerId={1},customerName='{2}',telphone='{3}',address='{4}',contract='{5}',orderDate='{6}' Where id={7}", entity.OrderNumber, entity.CustomerId, entity.CustomerName, entity.Tel, entity.Address, entity.Contract, entity.OrderDate, entity.ID); return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0); }
public bool UpdateEntity(SalesOrdersModel entity) { //OrderNumber 这儿写上吧,实际业务里不能被修改 //Oracle时间类型都是to_date() string sql = string.Format("Update SalesOrders Set OrderNumber='{0}',CustomerName='{1}',Tel='{2}',Address='{3}',Contract='{4}',Status='{5}',OrderDate=to_date('{6}','yyyy-MM-dd') Where ID={7}", entity.OrderNumber, entity.CustomerName, 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); }
/// <summary> /// 修改订单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripButton2_Click(object sender, EventArgs e) { if (listViewOrders.SelectedItems.Count > 0) { SalesOrdersModel oneSales = (SalesOrdersModel)listViewOrders.SelectedItems[0].Tag; salesID = oneSales.ID; AddSalesOrder updateSalesOrder = new AddSalesOrder(oneSales.ID); if (updateSalesOrder.ShowDialog() == DialogResult.OK) { GetSalesOrdersList(); //修改中ListView失去焦点 GetUpdateOrderDetail(); } } }
public SalesOrdersModel AddEntity(SalesOrdersModel entity) { entity.ID = GetNewID(); string sql = string.Format("insert into salesOrders(ID,OrderNumber,CustomerName,Tel,Address,Contract,Status,OrderDate) values({0},'{1}','{2}','{3}','{4}','{5}','{6}',to_date('{7}','yyyy-mm-dd'))", entity.ID, entity.OrderNumber, entity.CustomerName, 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); } }
public SalesOrdersModel AddEntity(SalesOrdersModel entity) { string sql = string.Format("insert into salesOrders(orderNumber,customerId,customerName,telphone,address,contract,orderDate) values('{0}',{1},'{2}','{3}','{4}','{5}','{6}')", entity.OrderNumber, entity.CustomerId, entity.CustomerName, entity.Tel, entity.Address, entity.Contract, entity.OrderDate); if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0) { int curID = Convert.ToInt32(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, "select ident_current('salesOrders')", null).ToString()); entity.ID = curID; return(entity); } else { return(null); } }
private void AddSalesOrder_Load(object sender, EventArgs e) { if (isUpdate) { //Model.SalesOrdersModel salesOrder =new BLLSalesOrders.SalesManagerServiceClient() BLLSalesOrders.SalesManagerServiceClient salesClient = WCFServiceBLL.GetSalesService(); SalesOrdersModel order = salesClient.GetOneSalesOrder(orderID); labelCustomerId.Text = order.CustomerId.ToString(); textBoxOrderNumber.Text = order.OrderNumber; textBoxCustomer.Text = order.CustomerName; labelTotalMoney.Text = "[]"; textBoxTel.Text = order.Tel; textBoxAddress.Text = order.Address; textBoxContract.Text = order.Contract; } }
public List <SalesOrdersModel> GetEntities(string sqlWhere) { string sql = string.Format("select * from SalesOrders where 1=1 {0}", sqlWhere); List <Model.SalesOrdersModel> listSalesOrders = new List <SalesOrdersModel>(); using (OracleDataReader odr = OracleHelper.ExecuteReader(OracleHelper.ConnectionString, System.Data.CommandType.Text, sql, null)) { while (odr.Read()) { Model.SalesOrdersModel salesOrdersModel = new SalesOrdersModel(); salesOrdersModel.ID = odr.GetInt32(0); salesOrdersModel.OrderNumber = odr.IsDBNull(1) ? "" : odr.GetString(1); salesOrdersModel.CustomerName = odr.IsDBNull(2) ? "" : odr.GetString(2); salesOrdersModel.Tel = odr.IsDBNull(3) ? "" : odr.GetString(3); salesOrdersModel.Address = odr.IsDBNull(4) ? "" : odr.GetString(4); salesOrdersModel.Contract = odr.IsDBNull(5) ? "" : odr.GetString(5); salesOrdersModel.Status = odr.IsDBNull(6) ? "" : odr.GetString(6); salesOrdersModel.OrderDate = odr.IsDBNull(7) ? DateTime.Now : odr.GetDateTime(7); listSalesOrders.Add(salesOrdersModel); } } return(listSalesOrders); }