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