public void addPurOrderChildTest1() { CommodityImpl_Accessor target = new CommodityImpl_Accessor(); // TODO: Initialize to an appropriate value PurchaseChild purchaseChild = new PurchaseChild(); // TODO: Initialize to an appropriate value purchaseChild.PurParentId = "PO_ID_20101206_002"; purchaseChild.DetailId = 1; purchaseChild.PurKBN = 1; purchaseChild.CommId = "Comd_ID_00006"; purchaseChild.Amount = 10; purchaseChild.UnitPrice = 2.5f; purchaseChild.TotlePrice = 25f; purchaseChild.Remark = "备注"; target.addPurOrderChild(purchaseChild); }
public int AddPurchaseChild(PurchaseChild purchaseChild, string currentUser) { string sqlStr = dbUtil.getSqlStatement("SQL_Comd_PurchaseChild_Insert"); SqlParameter[] sqlParms = { new SqlParameter("@PurchaseOrderID",SqlDbType.VarChar,20), new SqlParameter("@PurchaseOrderDetailID",SqlDbType.Int), new SqlParameter("@PurchaseKBN",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("@Remark",SqlDbType.NVarChar,800), new SqlParameter("@CreateUser",SqlDbType.VarChar,20), new SqlParameter("@UpdateUser",SqlDbType.VarChar,20) }; sqlParms[0].Value = purchaseChild.PurParentId; sqlParms[1].Value = purchaseChild.DetailId; sqlParms[2].Value = purchaseChild.PurKBN; sqlParms[3].Value = purchaseChild.CommId; sqlParms[4].Value = purchaseChild.Amount; sqlParms[5].Value = purchaseChild.UnitPrice; sqlParms[6].Value = purchaseChild.TotlePrice; sqlParms[7].Value = purchaseChild.Remark; sqlParms[8].Value = currentUser; sqlParms[9].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 void addPurOrderTest() { CommodityImpl_Accessor target = new CommodityImpl_Accessor(); // TODO: Initialize to an appropriate value PurchaseParent purchaseParent = new PurchaseParent(); // TODO: 初始化为适当的值 purchaseParent.OrderId = ""; purchaseParent.Supplier = "北京中关村明基代理"; purchaseParent.PurchaseEmpId = "EMP_ID_001"; purchaseParent.PurchaseDate = DateTime.Parse("2010-12-6"); purchaseParent.StatusKBN = 2; purchaseParent.ReceivingFLG = false; purchaseParent.PaymentFLG = false; purchaseParent.Remark = "分期付款"; List<PurchaseChild> purchaseChildList = new List<PurchaseChild>(); // TODO: Initialize to an appropriate value PurchaseChild purchaseChild = new PurchaseChild(); // TODO: Initialize to an appropriate value purchaseChild.PurParentId = ""; purchaseChild.DetailId = 0; purchaseChild.PurKBN = 1; purchaseChild.CommId = "Comd_ID_00006"; purchaseChild.Amount = 10; purchaseChild.UnitPrice = 2.5f; purchaseChild.TotlePrice = 25f; purchaseChild.Remark = "备注"; purchaseChildList.Add(purchaseChild); purchaseChild = new PurchaseChild(); // TODO: Initialize to an appropriate value purchaseChild.PurParentId = ""; purchaseChild.DetailId = 0; purchaseChild.PurKBN = 1; purchaseChild.CommId = "Comd_ID_00006"; purchaseChild.Amount = 10; purchaseChild.UnitPrice = 2.5f; purchaseChild.TotlePrice = 25f; purchaseChild.Remark = "备注"; purchaseChildList.Add(purchaseChild); string actual = target.addOrUpdatePurOrder(purchaseParent, purchaseChildList); Assert.AreEqual("PO_ID_20101208_00001", actual); }
public List<PurchaseChild> SearchPurchaseChildByOrderID(string strPurchaseOrderID) { List<PurchaseChild> purchaseChildList = new List<PurchaseChild>(); string sqlStr = dbUtil.getSqlStatement("SQL_Comd_PurchaseChild_SearchByOrderID"); SqlParameter[] sqlParms = { new SqlParameter("@PurchaseOrderID",SqlDbType.VarChar,20) }; sqlParms[0].Value = strPurchaseOrderID; 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) { PurchaseChild purchaseChild = new PurchaseChild(); purchaseChild.PurParentId = dr["PurchaseOrderID"].ToString(); purchaseChild.DetailId = Convert.ToInt32(dr["PurchaseOrderDetailID"]); purchaseChild.CommId = dr["ComdID"].ToString(); purchaseChild.CommName = dr["ComdName"].ToString(); purchaseChild.Standard = dr["ComdStandard"].ToString(); purchaseChild.Unit = dr["Unit"].ToString(); purchaseChild.Amount = Convert.ToInt32(dr["amount"]); purchaseChild.UnitPrice = Convert.ToSingle(dr["PriceUnit"]); purchaseChild.TotlePrice = Convert.ToSingle(dr["PriceTotal"]); purchaseChild.PurKBN = Convert.ToInt32(dr["PurchaseKBN"]); purchaseChild.Remark = dr["Remark"].ToString(); purchaseChildList.Add(purchaseChild); } } } catch (Exception ex) { throw new DAOException("E0001"); } return purchaseChildList; }
public object Clone() { PurchaseChild child = new PurchaseChild(); child.purParentId = purParentId; child.detailId = detailId; child.commId = commId; child.commName = commName; child.standard = standard; child.unit = unit; child.amount = amount; child.unitPrice = unitPrice; child.totlePrice = totlePrice; child.remark = remark; child.purKBN = purKBN; return child; }
private void addPurOrderChild(PurchaseChild purchaseChild) { if (purchaseChild.PurParentId == null || purchaseChild.PurParentId == string.Empty) { throw new BIZException("W03003"); } if (purchaseChild.DetailId == 0) { purchaseChild.DetailId = this.GeneratePurOrderDetailId(purchaseChild.PurParentId); } int resutcount = 0; try { resutcount = comdDAO.AddPurchaseChild(purchaseChild, this.currentUser); if (resutcount != 1) { throw new BIZException("W03002"); } } catch (Exception ex) { throw; } }
/// <summary> /// /// </summary> /// <param name="purchaseParent"></param> /// <param name="purchaseChildList"></param> /// <returns>parent OrderID</returns> private string addOrUpdatePurOrder(PurchaseParent purchaseParent, List<PurchaseChild> purchaseChildList) { string parentOrderId = ""; try { //add parent into db if (purchaseParent.Valid == false) { //purchaseParent.OrderId = this.GeneratePurOrderId(); purchaseParent.StatusKBN = 0; purchaseParent.ReceivingFLG = false; purchaseParent.PaymentFLG = false; parentOrderId = this.addPurOrderParent(purchaseParent); } else { purchaseParent.StatusKBN = 0; purchaseParent.ReceivingFLG = false; purchaseParent.PaymentFLG = false; this.UpdatePurOrderParent(purchaseParent); this.DeletePurOrderChild(purchaseParent.OrderId); parentOrderId = purchaseParent.OrderId; } //goods foreach (PurchaseChild purchaseChild in purchaseChildList) { purchaseChild.PurKBN = 1; } //discount PurchaseChild purchaseChildDiscount = new PurchaseChild(); purchaseChildDiscount.PurKBN = 2; purchaseChildDiscount.Amount = 1; purchaseChildDiscount.UnitPrice = purchaseParent.Rebate; purchaseChildDiscount.TotlePrice = purchaseParent.Rebate; //freight PurchaseChild purchaseChildFreight = new PurchaseChild(); purchaseChildFreight.PurKBN = 3; purchaseChildFreight.Amount = 1; purchaseChildFreight.UnitPrice = purchaseParent.Freight; purchaseChildFreight.TotlePrice = purchaseParent.Freight; //other pay PurchaseChild purchaseChildOtherPay = new PurchaseChild(); purchaseChildOtherPay.PurKBN = 4; purchaseChildOtherPay.Amount = 1; purchaseChildOtherPay.UnitPrice = purchaseParent.OtherPay; purchaseChildOtherPay.TotlePrice = purchaseParent.OtherPay; purchaseChildList.Add(purchaseChildDiscount); purchaseChildList.Add(purchaseChildFreight); purchaseChildList.Add(purchaseChildOtherPay); //add child into db foreach (PurchaseChild purchaseChild in purchaseChildList) { //purchaseChild.PurParentId = purchaseParent.OrderId; purchaseChild.PurParentId = parentOrderId; //purchaseChild.DetailId = this.GeneratePurOrderDetailId(purchaseChild.PurParentId); this.addPurOrderChild(purchaseChild); } } catch (Exception ex) { throw; } return parentOrderId; }
private bool ReadDetail(PurchaseChild purChild) { if (cmbCommo.SelectedItem == null) { ShowErrorInfo("必须输入商品名"); return false; } if (cmbStandard.SelectedItem == null) { ShowErrorInfo("必须输入商品规格型号"); return false; } purChild.CommId = (cmbStandard.SelectedItem as ExtItem).Tag.ToString(); purChild.CommName = cmbCommo.SelectedItem.ToString(); purChild.Standard = (cmbStandard.SelectedItem as ExtItem).Item.ToString(); purChild.Unit = txtUnit.Text; purChild.Amount = neAmount.IntValue; purChild.UnitPrice = (float)neUnitPrice.Value; purChild.TotlePrice = purChild.UnitPrice * purChild.Amount; purChild.Remark = txtChildRemark.Text; return true; }
private void DgvCommo_SelChanged(object sender, EventArgs e) { if (DgvCommo.CurrentRow != null) { if (DgvCommo.CurrentRow.Index < purFormEntity.PurChildren.Count) { curPurChild = purFormEntity.PurChildren[DgvCommo.CurrentRow.Index]; } UpdateItemDetail(); } }
private void BtnContinueAdd_Click(object sender, EventArgs e) { this.HideErrorInfo(); ReadOrderInfo(); if (curPurChild.CommId == null || curPurChild.CommId.Equals("")) { if (!ReadDetail(curPurChild)) { return; } purFormEntity.PurChildren.Add(curPurChild); UpdateOrderMoney(); UpdatePage(); ClearSelection(DgvCommo); curPurChild = new PurchaseChild(); UpdateItemDetail(); } else { if (!ReadDetail(curPurChild)) { 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) { curPurChild = null; } UpdateItemDetail(); }
private void BtnAddDetail_Click(object sender, EventArgs e) { this.HideErrorInfo(); // 读取界面数据。 ReadOrderInfo(); ClearSelection(DgvCommo); curPurChild = new PurchaseChild(); UpdateItemDetail(); }