public object Clone()
{
SaleChild child = new SaleChild();
child.orderId = orderId;
child.detailId = detailId;
child.commId = commId;
child.commName = commName;
child.standard = standard;
child.unit = unit;
child.amount = amount;
child.priceUnit = priceUnit;
child.priceTotal = priceTotal;
child.priceTotalActual = priceTotalActual;
child.priceUnitForSaleMan = priceUnitForSaleMan;
child.priceTotalForSaleMan = priceTotalForSaleMan;
child.priceTotalForSaleMan = priceTotalForSaleMan;
child.remark = remark;
child.saleKBN = saleKBN;
return child;
}
public List<SaleChild> SearchSaleChildByOrderID(string strSaleOrderID)
{
List<SaleChild> saleChildList = new List<SaleChild>();
string sqlStr = dbUtil.getSqlStatement("SQL_Comd_SaleChild_SearchByOrderID");
SqlParameter[] sqlParms = {
new SqlParameter("@SaleOrderID",SqlDbType.VarChar,20)
};
sqlParms[0].Value = strSaleOrderID;
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)
{
SaleChild saleChild = new SaleChild();
saleChild.OrderId = dr["SaleOrderID"].ToString();
saleChild.DetailId = Convert.ToInt32(dr["SaleOrderDetailID"]);
saleChild.SaleKBN = Convert.ToInt32(dr["SaleKBN"]);
saleChild.Remark = dr["Remark"].ToString();
saleChild.CommId = dr["ComdID"].ToString();
saleChild.CommName = dr["ComdName"].ToString();
saleChild.Standard = dr["ComdStandard"].ToString();
saleChild.Unit = dr["Unit"].ToString();
saleChild.Amount = Convert.ToInt32(dr["amount"]);
saleChild.PriceUnit = Convert.ToSingle(dr["PriceUnit"]);
saleChild.PriceTotal = Convert.ToSingle(dr["PriceTotal"]);
saleChild.PriceTotalActual = Convert.ToSingle(dr["PriceTotalActual"]);
saleChild.PriceUnitForSaleMan = Convert.ToSingle(dr["PriceUnitForSaleMan"]);
saleChild.PriceTotalForSaleMan = Convert.ToSingle(dr["PriceTotalForSaleMan"]);
saleChild.PriceTotalActualForSaleMan = Convert.ToSingle(dr["PriceTotalActualForSaleMan"]);
saleChildList.Add(saleChild);
}
}
}
catch (Exception ex)
{
throw new DAOException("E0001");
}
return saleChildList;
}
public int AddSaleChild(SaleChild saleChild, string currentUser)
{
string sqlStr = dbUtil.getSqlStatement("SQL_Comd_SaleChild_Insert");
SqlParameter[] sqlParms = {
new SqlParameter("@SaleOrderID",SqlDbType.VarChar,20),
new SqlParameter("@SaleOrderDetailID",SqlDbType.Int),
new SqlParameter("@SaleKBN",SqlDbType.Int),
new SqlParameter("@ComdID",SqlDbType.VarChar,20),
new SqlParameter("@amount",SqlDbType.Int),
new SqlParameter("@PriceUnit",SqlDbType.Float),
new SqlParameter("@PriceTotal",SqlDbType.Float),
new SqlParameter("@PriceTotalActual",SqlDbType.Float),
new SqlParameter("@PriceUnitForSaleMan",SqlDbType.Float),
new SqlParameter("@PriceTotalForSaleMan",SqlDbType.Float),
new SqlParameter("@PriceTotalActualForSaleMan",SqlDbType.Float),
new SqlParameter("@Remark",SqlDbType.NVarChar,800),
new SqlParameter("@CreateUser",SqlDbType.VarChar,20),
new SqlParameter("@UpdateUser",SqlDbType.VarChar,20)
};
sqlParms[0].Value = saleChild.OrderId;
sqlParms[1].Value = saleChild.DetailId;
sqlParms[2].Value = saleChild.SaleKBN;
sqlParms[3].Value = saleChild.CommId;
sqlParms[4].Value = saleChild.Amount;
sqlParms[5].Value = saleChild.PriceUnit;
sqlParms[6].Value = saleChild.PriceTotal;
sqlParms[7].Value = saleChild.PriceTotalActual;
sqlParms[8].Value = saleChild.PriceUnitForSaleMan;
sqlParms[9].Value = saleChild.PriceTotalForSaleMan;
sqlParms[10].Value = saleChild.PriceTotalActualForSaleMan;
sqlParms[11].Value = saleChild.Remark;
sqlParms[12].Value = currentUser;
sqlParms[13].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;
}
private void DgvCommo_SelChanged(object sender, EventArgs e)
{
if (DgvCommo.CurrentRow != null)
{
if (DgvCommo.CurrentRow.Index < soFormEntity.SaleChildren.Count)
{
curSaleChild = soFormEntity.SaleChildren[DgvCommo.CurrentRow.Index];
}
UpdateItemDetail();
}
}
private bool ReadDetail(SaleChild saleChild)
{
if (cmbCommo.SelectedItem == null)
{
ShowErrorInfo("必须输入商品名");
return false;
}
if (cmbStandard.SelectedItem == null)
{
ShowErrorInfo("必须输入商品规格型号");
return false;
}
saleChild.CommId = (cmbStandard.SelectedItem as ExtItem).Tag.ToString();
saleChild.CommName = cmbCommo.SelectedItem.ToString();
saleChild.Standard = (cmbStandard.SelectedItem as ExtItem).Item.ToString();
saleChild.Unit = txtUnit.Text;
saleChild.Amount = neAmount.IntValue;
saleChild.PriceUnit = (float)nePriceUnit.Value;
saleChild.PriceTotal = saleChild.PriceUnit * saleChild.Amount;
saleChild.PriceTotalActual = (float)nePriceTotalActual.Value;
saleChild.PriceUnitForSaleMan = (float)nePriceUnitForSaleMan.Value;
saleChild.PriceTotalForSaleMan = saleChild.PriceUnitForSaleMan * saleChild.Amount;
saleChild.PriceTotalActualForSaleMan = (float)nePriceTotalActuaForSaleMan.Value;
saleChild.Remark = txtChildRemark.Text;
return true;
}
private void BtnContinueAdd_Click(object sender, EventArgs e)
{
this.HideErrorInfo();
ReadOrderInfo();
if (curSaleChild.CommId == null || curSaleChild.CommId.Equals(""))
{
if (!ReadDetail(curSaleChild))
{
return;
}
soFormEntity.SaleChildren.Add(curSaleChild);
UpdateOrderMoney();
UpdatePage();
ClearSelection(DgvCommo);
curSaleChild = new SaleChild();
UpdateItemDetail();
}
else
{
if (!ReadDetail(curSaleChild))
{
return;
}
UpdateOrderMoney();
UpdatePage();
DgvCommo.Rows[DgvCommo.Rows.Count - 1].Selected = true;
DgvCommo.CurrentCell = DgvCommo.Rows[DgvCommo.Rows.Count - 1].Cells[0];
}
}
private void BtnCancelAdd_Click(object sender, EventArgs e)
{
this.HideErrorInfo();
if (DgvCommo.CurrentRow == null)
{
curSaleChild = null;
}
UpdateItemDetail();
}
private void BtnAddDetail_Click(object sender, EventArgs e)
{
this.HideErrorInfo();
// 读取界面数据。
ReadOrderInfo();
ClearSelection(DgvCommo);
curSaleChild = new SaleChild();
UpdateItemDetail();
}
private void addSaleOrderChild(SaleChild saleChild)
{
if (saleChild.OrderId == null || saleChild.OrderId == string.Empty)
{
throw new BIZException("W03003");
}
if (saleChild.DetailId == 0)
{
saleChild.DetailId = this.GenerateSaleOrderDetailId(saleChild.OrderId);
}
int resutcount = 0;
try
{
resutcount = comdDAO.AddSaleChild(saleChild, this.currentUser);
if (resutcount != 1)
{
throw new BIZException("W03002");
}
}
catch (Exception ex)
{
throw;
}
}
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;
}
