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