public FormDelivery(string orderId) { try { saleParent = icommodity.SOGetParentInfoById(orderId); } catch { saleParent = null; } InitializeComponent(); }
public int AddSaleParent(SaleParent saleParent, string currentUser) { string sqlStr = dbUtil.getSqlStatement("SQL_Comd_SaleParent_Insert"); SqlParameter[] sqlParms = { new SqlParameter("@SaleOrderID",SqlDbType.VarChar,20), new SqlParameter("@CustomerID",SqlDbType.VarChar,20), new SqlParameter("@SaleEmpID",SqlDbType.VarChar,20), new SqlParameter("@SaleDate",SqlDbType.VarChar,10), new SqlParameter("@StatusKBN",SqlDbType.Int), new SqlParameter("@DeliveryFLG",SqlDbType.Bit), new SqlParameter("@PaymentFLG",SqlDbType.Bit), new SqlParameter("@ReceivingAddress",SqlDbType.NVarChar,800), new SqlParameter("@Remark",SqlDbType.NVarChar,800), new SqlParameter("@CreateUser",SqlDbType.VarChar,20), new SqlParameter("@UpdateUser",SqlDbType.VarChar,20) }; sqlParms[0].Value = saleParent.OrderId; sqlParms[1].Value = saleParent.CustomerID; sqlParms[2].Value = saleParent.SaleEmpID; sqlParms[3].Value = saleParent.SaleDate.ToString("yyyy-MM-dd"); sqlParms[4].Value = saleParent.StatusKBN; sqlParms[5].Value = saleParent.DeliveryFLG; sqlParms[6].Value = saleParent.PaymentFLG; sqlParms[7].Value = saleParent.Remark; sqlParms[8].Value = saleParent.ReceivingAddress; sqlParms[9].Value = currentUser; sqlParms[10].Value = currentUser; int resultCount = 0; try { resultCount = (int)DAO.DBAccess.ExecuteNonQuery(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms); } catch (Exception ex) { throw new DAOException("E0001"); } return resultCount; }
public List<SaleParent> SearchSaleParentByMultiFilter(Hashtable hashTable) { List<SaleParent> saleParentList = new List<SaleParent>(); string sqlStr = dbUtil.getSqlStatement("SQL_Comd_SaleParent_SearchByMultiFilter"); ArrayList listParms = new ArrayList(); UtilService utilService = new UtilService(); if (hashTable.Contains("@SaleOrderID")) { sqlStr = utilService.validSearchFilter(sqlStr, "@SaleOrderID"); listParms.Add(new SqlParameter("@SaleOrderID", SqlDbType.NVarChar, 40)); } if (hashTable.Contains("@CustomerID")) { sqlStr = utilService.validSearchFilter(sqlStr, "@CustomerID"); listParms.Add(new SqlParameter("@CustomerID", SqlDbType.VarChar, 20)); } if (hashTable.Contains("@CustomerName")) { sqlStr = utilService.validSearchFilter(sqlStr, "@CustomerName"); listParms.Add(new SqlParameter("@CustomerName", SqlDbType.NVarChar, 100)); } if (hashTable.Contains("@SaleEmpID")) { sqlStr = utilService.validSearchFilter(sqlStr, "@SaleEmpID"); listParms.Add(new SqlParameter("@SaleEmpID", SqlDbType.VarChar, 20)); } if (hashTable.Contains("@SaleEmpName")) { sqlStr = utilService.validSearchFilter(sqlStr, "@SaleEmpName"); listParms.Add(new SqlParameter("@SaleEmpName", SqlDbType.NVarChar, 40)); } if (hashTable.Contains("@ComdID")) { sqlStr = utilService.validSearchFilter(sqlStr, "@ComdID"); listParms.Add(new SqlParameter("@ComdID", SqlDbType.VarChar, 20)); } if (hashTable.Contains("@ComdName")) { sqlStr = utilService.validSearchFilter(sqlStr, "@ComdName"); listParms.Add(new SqlParameter("@ComdName", SqlDbType.NVarChar, 100)); } if (hashTable.Contains("@SaleDateStart")) { sqlStr = utilService.validSearchFilter(sqlStr, "@SaleDateStart"); listParms.Add(new SqlParameter("@SaleDateStart", SqlDbType.VarChar, 10)); } if (hashTable.Contains("@SaleDateEnd")) { sqlStr = utilService.validSearchFilter(sqlStr, "@SaleDateEnd"); listParms.Add(new SqlParameter("@SaleDateEnd", SqlDbType.VarChar, 10)); } if (hashTable.Contains("@StatusKBN")) { sqlStr = utilService.validSearchFilter(sqlStr, "@StatusKBN"); listParms.Add(new SqlParameter("@StatusKBN", SqlDbType.Int)); } if (hashTable.Contains("@DeliveryFLG")) { sqlStr = utilService.validSearchFilter(sqlStr, "@DeliveryFLG"); listParms.Add(new SqlParameter("@DeliveryFLG", SqlDbType.Bit)); } if (hashTable.Contains("@PaymentFLG")) { sqlStr = utilService.validSearchFilter(sqlStr, "@PaymentFLG"); listParms.Add(new SqlParameter("@PaymentFLG", SqlDbType.Bit)); } SqlParameter[] sqlParms = (SqlParameter[])listParms.ToArray(typeof(SqlParameter)); foreach (SqlParameter parm in sqlParms) { parm.Value = hashTable[parm.ParameterName]; } DataSet searchResult = null; try { searchResult = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms); foreach (DataTable dt in searchResult.Tables) { foreach (DataRow dr in dt.Rows) { SaleParent saleParent = new SaleParent(); saleParent.OrderId = dr["SaleOrderID"].ToString(); saleParent.CustomerID = dr["CustomerID"].ToString(); saleParent.CustomerName = dr["CustomerName"].ToString(); saleParent.SaleEmpID = dr["SaleEmpID"].ToString(); saleParent.SaleEmpName = dr["SaleEmpName"].ToString(); if (dr["SaleDate"].ToString() == string.Empty) { saleParent.SaleDate = DateTime.MinValue; } else { saleParent.SaleDate = DateTime.Parse(dr["SaleDate"].ToString()); } saleParent.StatusKBN = (int)dr["StatusKBN"]; saleParent.DeliveryFLG = (bool)dr["DeliveryFLG"]; saleParent.PaymentFLG = (bool)dr["PaymentFLG"]; saleParent.Remark = dr["Remark"].ToString(); saleParent.ReceivingAddress = dr["ReceivingAddress"].ToString(); saleParentList.Add(saleParent); } } } catch (Exception ex) { throw; } return saleParentList; }
private void ReloadSaleParent() { if (saleParent == null) { ShowErrorInfo("没有有效数据。"); return; } try { saleParent = icommodity.SOGetParentInfoById(saleParent.OrderId); } catch { ShowErrorInfo("无法取得订单数据。"); return; } }
public object Clone() { SaleParent parent = new SaleParent(); parent.orderId = orderId; parent.customerID = customerID; parent.customerName = customerName; parent.saleEmpID = saleEmpID; parent.saleEmpName = saleEmpName; parent.saleDate = saleDate; parent.freight = freight; parent.rebate = rebate; parent.otherPay = otherPay; parent.commPay = commPay; parent.duePay = duePay; parent.remark = remark; parent.statusKBN = statusKBN; // 未生效 parent.deliveryFLG = deliveryFLG; parent.paymentFLG = paymentFLG; parent.receivingAddress = receivingAddress; return parent; }
private void ReloadOrderData() { try { if (saleParent != null) { saleParent = icommodity.SOGetParentInfoById(saleParent.OrderId); } } catch { ShowErrorInfo("读取数据失败。"); saleParent = null; return; } }
private void UpdateSaleOrderParent(SaleParent saleParent) { if (saleParent == null || saleParent.OrderId == null || saleParent.OrderId == string.Empty) { return; } int resutcount = 0; try { resutcount = comdDAO.UpdateSaleParent(saleParent, this.currentUser); if (resutcount != 1) { throw new BIZException("W03003"); } } catch (Exception ex) { throw; } }
private void SOCheckValidPay(SaleParent saleParent) { if (saleParent == null || saleParent.OrderId == null || saleParent.OrderId == string.Empty) { //指定的订单不存在。 throw new BIZException("W03003"); } else if (saleParent.StatusKBN != 1) { //处于未生效、已关闭或已完成状态的订单,不能执行收货、付款或标记完成操作。 throw new BIZException("W03009"); } else if (saleParent.PaymentFLG == true) { //此订单已标记付款完成,不能执行付款操作。 throw new BIZException("W03008"); } }
private void SOCheckValidComplete(SaleParent saleParent) { if (saleParent == null || saleParent.OrderId == null || saleParent.OrderId == string.Empty) { //指定的订单不存在。 throw new BIZException("W03003"); } else if (saleParent.StatusKBN != 1) { //处于未生效、已关闭或已完成状态的订单,不能执行收货、付款或标记完成操作。 throw new BIZException("W03009"); } }
private string addSaleOrderParent(SaleParent saleParent) { if (saleParent == null || saleParent.OrderId == null || saleParent.OrderId == string.Empty) { saleParent.OrderId = this.GenerateSaleOrderId(); } int resutcount = 0; try { resutcount = comdDAO.AddSaleParent(saleParent, this.currentUser); if (resutcount != 1) { throw new BIZException("W03001"); } } catch (Exception ex) { throw; } return saleParent.OrderId; }
private string addOrUpdateSaleOrder(SaleParent saleParent, List<SaleChild> saleChildList) { string parentOrderId = ""; try { //add parent into db if (saleParent == null || saleParent.OrderId == null || saleParent.OrderId == string.Empty) { saleParent.StatusKBN = 0; saleParent.DeliveryFLG = false; saleParent.PaymentFLG = false; parentOrderId = this.addSaleOrderParent(saleParent); } else { saleParent.StatusKBN = 0; saleParent.DeliveryFLG = false; saleParent.PaymentFLG = false; this.UpdateSaleOrderParent(saleParent); this.DeleteSaleOrderChild(saleParent.OrderId); parentOrderId = saleParent.OrderId; } //goods foreach (SaleChild saleChild in saleChildList) { saleChild.SaleKBN = 1; } //discount SaleChild saleChildDiscount = new SaleChild(); saleChildDiscount.SaleKBN = 2; saleChildDiscount.Amount = 1; saleChildDiscount.PriceUnit = saleParent.Rebate; saleChildDiscount.PriceTotal = saleParent.Rebate; saleChildDiscount.PriceTotalActual = saleParent.Rebate; saleChildDiscount.PriceUnitForSaleMan = 0; saleChildDiscount.PriceTotalForSaleMan = 0; saleChildDiscount.PriceTotalActualForSaleMan = 0; //freight SaleChild saleChildFreight = new SaleChild(); saleChildFreight.SaleKBN = 3; saleChildFreight.Amount = 1; saleChildFreight.PriceUnit = saleParent.Freight; saleChildFreight.PriceTotal = saleParent.Freight; saleChildFreight.PriceTotalActual = saleParent.Freight; saleChildFreight.PriceUnitForSaleMan = 0; saleChildFreight.PriceTotalForSaleMan = 0; saleChildFreight.PriceTotalActualForSaleMan = 0; //other pay SaleChild saleChildOtherPay = new SaleChild(); saleChildOtherPay.SaleKBN = 4; saleChildOtherPay.Amount = 1; saleChildOtherPay.PriceUnit = saleParent.OtherPay; saleChildOtherPay.PriceTotal = saleParent.OtherPay; saleChildOtherPay.PriceTotalActual = saleParent.OtherPay; saleChildOtherPay.PriceUnitForSaleMan = 0; saleChildOtherPay.PriceTotalForSaleMan = 0; saleChildOtherPay.PriceTotalActualForSaleMan = 0; saleChildList.Add(saleChildDiscount); saleChildList.Add(saleChildFreight); saleChildList.Add(saleChildOtherPay); //add child into db foreach (SaleChild saleChild in saleChildList) { //saleChild.PurParentId = purchaseParent.OrderId; saleChild.OrderId = parentOrderId; //saleChild.DetailId = this.GeneratePurOrderDetailId(saleChild.PurParentId); this.addSaleOrderChild(saleChild); } } catch (Exception ex) { throw; } return parentOrderId; }