コード例 #1
0
ファイル: FormReceive.cs プロジェクト: marcpiulachs/noahylk
 public FormReceive(string orderId)
 {
     try
     {
         purParent = icommodity.POGetParentInfoByOrderId(orderId);
     }
     catch
     {
         purParent = null;
     }
     InitializeComponent();
 }
コード例 #2
0
 public void addPurOrderParentTest1()
 {
     CommodityImpl_Accessor target = new CommodityImpl_Accessor(); // TODO: 初始化为适当的值
     PurchaseParent purchaseParent = new PurchaseParent(); // TODO: 初始化为适当的值
     purchaseParent.OrderId = "PO_ID_20101206_002";
     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 = "分期付款";
     string actual = target.addPurOrderParent(purchaseParent);
 }
コード例 #3
0
ファイル: FormRecAdd.cs プロジェクト: marcpiulachs/noahylk
        public FormRecAdd(string orderId)
        {
            try
            {
                purParent = icommodity.POGetParentInfoByOrderId(orderId);
            }
            catch
            {
                purParent = null;
            }

            ReloadRecList();

            InitializeComponent();
            Initialize();
        }
コード例 #4
0
ファイル: ComdDAO.cs プロジェクト: marcpiulachs/noahylk
        public int AddPurchaseParent(PurchaseParent purchaseParent, string currentUser)
        {
            string sqlStr = dbUtil.getSqlStatement("SQL_Comd_PurchaseParent_Insert");

            SqlParameter[] sqlParms = {
                new SqlParameter("@PurchaseOrderID",SqlDbType.VarChar,20),
                new SqlParameter("@SupplierID",SqlDbType.VarChar,20),
                new SqlParameter("@PurchaseEmpID",SqlDbType.VarChar,20),
                new SqlParameter("@PurchaseDate",SqlDbType.VarChar,10),
                new SqlParameter("@StatusKBN",SqlDbType.Int),
                new SqlParameter("@ReceivingFLG",SqlDbType.Bit),
                new SqlParameter("@PaymentFLG",SqlDbType.Bit),
                new SqlParameter("@Remark",SqlDbType.NVarChar,800),
                new SqlParameter("@CreateUser",SqlDbType.VarChar,20),
                new SqlParameter("@UpdateUser",SqlDbType.VarChar,20)
            };

            sqlParms[0].Value = purchaseParent.OrderId;
            sqlParms[1].Value = purchaseParent.Supplier;
            sqlParms[2].Value = purchaseParent.PurchaseEmpId;
            sqlParms[3].Value = purchaseParent.PurchaseDate.ToString("yyyy-MM-dd");
            sqlParms[4].Value = purchaseParent.StatusKBN;
            sqlParms[5].Value = purchaseParent.ReceivingFLG;
            sqlParms[6].Value = purchaseParent.PaymentFLG;
            sqlParms[7].Value = purchaseParent.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;
        }
コード例 #5
0
        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);
        }
コード例 #6
0
ファイル: FormReceive.cs プロジェクト: marcpiulachs/noahylk
 private void ReloadOrderData()
 {
     try
     {
         if (purParent != null)
         {
             purParent = icommodity.POGetParentInfoByOrderId(purParent.OrderId);
         }
     }
     catch
     {
         ShowErrorInfo("读取数据失败。");
         purParent = null;
         return;
     }
 }
コード例 #7
0
        public object Clone()
        {
            PurchaseParent parent = new PurchaseParent();
            parent.orderId = orderId;
            parent.supplier = supplier;
            parent.purchaseEmpId = purchaseEmpId;
            parent.purEmpName = purEmpName;
            parent.pruchaseDate = pruchaseDate;
            parent.freight = freight;
            parent.rebate = rebate;
            parent.otherPay = otherPay;
            parent.commPay = commPay;
            parent.duePay = duePay;
            parent.remark = remark;
            parent.statusKBN = statusKBN; // 未生效
            parent.receivingFLG = receivingFLG;
            parent.paymentFLG = paymentFLG;

            return parent;
        }
コード例 #8
0
ファイル: ComdDAO.cs プロジェクト: marcpiulachs/noahylk
        public PurchaseParent SearchPurchaseParentByOrderID(string strPurchaseOrderID)
        {
            PurchaseParent purchaseParent = new PurchaseParent();

            string sqlStr = dbUtil.getSqlStatement("SQL_Comd_PurchaseParent_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);

                UtilService utilService = new UtilService();
                if (!utilService.isNullDataset(searchResult))
                {
                    purchaseParent.OrderId = searchResult.Tables[0].Rows[0]["PurchaseOrderID"].ToString();
                    purchaseParent.Supplier = searchResult.Tables[0].Rows[0]["SupplierID"].ToString();
                    purchaseParent.PurchaseEmpId = searchResult.Tables[0].Rows[0]["PurchaseEmpID"].ToString();
                    purchaseParent.PurEmpName = searchResult.Tables[0].Rows[0]["PurchaseEmpName"].ToString();
                    if (searchResult.Tables[0].Rows[0]["PurchaseDate"].ToString() == string.Empty)
                    {
                        purchaseParent.PurchaseDate = DateTime.MinValue;
                    }
                    else
                    {
                        purchaseParent.PurchaseDate = DateTime.Parse(searchResult.Tables[0].Rows[0]["PurchaseDate"].ToString());
                    }

                    purchaseParent.StatusKBN = (int)searchResult.Tables[0].Rows[0]["StatusKBN"];
                    purchaseParent.ReceivingFLG = (bool)searchResult.Tables[0].Rows[0]["ReceivingFLG"];
                    purchaseParent.PaymentFLG = (bool)searchResult.Tables[0].Rows[0]["PaymentFLG"];
                    purchaseParent.Remark = searchResult.Tables[0].Rows[0]["Remark"].ToString();

                }
            }
            catch (Exception ex)
            {
                throw new DAOException("E0001");
            }
            return purchaseParent;
        }
コード例 #9
0
ファイル: ComdDAO.cs プロジェクト: marcpiulachs/noahylk
        public List<PurchaseParent> SearchPurchaseParentByMultiFilter(Hashtable hashTable)
        {
            List<PurchaseParent> purchaseParentList = new List<PurchaseParent>();

            string sqlStr = dbUtil.getSqlStatement("SQL_Comd_PurchaseParent_SearchByMultiFilter");

            ArrayList listParms = new ArrayList();

            UtilService utilService = new UtilService();
            if (hashTable.Contains("@EmpName"))
            {
                sqlStr = utilService.validSearchFilter(sqlStr, "@EmpName");
                listParms.Add(new SqlParameter("@EmpName", SqlDbType.NVarChar, 40));
            }
            if (hashTable.Contains("@SupplierID"))
            {
                sqlStr = utilService.validSearchFilter(sqlStr, "@SupplierID");
                listParms.Add(new SqlParameter("@SupplierID", SqlDbType.VarChar, 20));
            }
            if (hashTable.Contains("@PurchaseDateStart"))
            {
                sqlStr = utilService.validSearchFilter(sqlStr, "@PurchaseDateStart");
                listParms.Add(new SqlParameter("@PurchaseDateStart", SqlDbType.VarChar, 10));
            }
            if (hashTable.Contains("@PurchaseDateEnd"))
            {
                sqlStr = utilService.validSearchFilter(sqlStr, "@PurchaseDateEnd");
                listParms.Add(new SqlParameter("@PurchaseDateEnd", SqlDbType.VarChar, 10));
            }
            if (hashTable.Contains("@StatusKBN"))
            {
                sqlStr = utilService.validSearchFilter(sqlStr, "@StatusKBN");
                listParms.Add(new SqlParameter("@StatusKBN", SqlDbType.Int));
            }
            if (hashTable.Contains("@ReceivingFLG"))
            {
                sqlStr = utilService.validSearchFilter(sqlStr, "@ReceivingFLG");
                listParms.Add(new SqlParameter("@ReceivingFLG", SqlDbType.Bit));
            }
            if (hashTable.Contains("@PaymentFLG"))
            {
                sqlStr = utilService.validSearchFilter(sqlStr, "@PaymentFLG");
                listParms.Add(new SqlParameter("@PaymentFLG", SqlDbType.Bit));
            }
            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));
            }

            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)
                    {
                        PurchaseParent purchaseParent = new PurchaseParent();

                        purchaseParent.OrderId = dr["PurchaseOrderID"].ToString();
                        purchaseParent.Supplier = dr["SupplierID"].ToString();
                        purchaseParent.PurchaseEmpId = dr["PurchaseEmpID"].ToString();
                        purchaseParent.PurEmpName = dr["PurchaseEmpName"].ToString();

                        if (dr["PurchaseDate"].ToString() == string.Empty)
                        {
                            purchaseParent.PurchaseDate = DateTime.MinValue;
                        }
                        else
                        {
                            purchaseParent.PurchaseDate = DateTime.Parse(dr["PurchaseDate"].ToString());
                        }

                        purchaseParent.StatusKBN = (int)dr["StatusKBN"];
                        purchaseParent.ReceivingFLG = (bool)dr["ReceivingFLG"];
                        purchaseParent.PaymentFLG = (bool)dr["PaymentFLG"];
                        purchaseParent.Remark = dr["Remark"].ToString();

                        purchaseParentList.Add(purchaseParent);
                    }
                }
            }
            catch (Exception ex)
            {
                throw;
            }
            return purchaseParentList;
        }
コード例 #10
0
ファイル: FormRecAdd.cs プロジェクト: marcpiulachs/noahylk
 private void ReloadPurParent()
 {
     if (purParent == null)
     {
         ShowErrorInfo("没有有效数据。");
         return;
     }
     try
     {
         purParent = icommodity.POGetParentInfoByOrderId(purParent.OrderId);
     }
     catch
     {
         ShowErrorInfo("无法取得订单数据。");
         return;
     }
 }
コード例 #11
0
ファイル: CommodityImpl.cs プロジェクト: marcpiulachs/noahylk
        /// <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;
        }
コード例 #12
0
ファイル: CommodityImpl.cs プロジェクト: marcpiulachs/noahylk
 private void validCheckPurReceive(PurchaseParent purchaseParent)
 {
     if (purchaseParent == null || purchaseParent.Valid == false)
     {
         //指定的订单不存在。
         throw new BIZException("W03003");
     }
     else if (purchaseParent.StatusKBN != 1)
     {
         //处于未生效、已关闭或已完成状态的订单,不能执行收货、付款或标记完成操作。
         throw new BIZException("W03009");
     }
     else if (purchaseParent.ReceivingFLG == true)
     {
         //此订单已标记收货完成,不能执行收货操作。
         throw new BIZException("W03007");
     }
 }
コード例 #13
0
ファイル: CommodityImpl.cs プロジェクト: marcpiulachs/noahylk
 private void validCheckPurPay(PurchaseParent purchaseParent)
 {
     if (purchaseParent == null || purchaseParent.Valid == false)
     {
         //指定的订单不存在。
         throw new BIZException("W03003");
     }
     else if (purchaseParent.StatusKBN != 1)
     {
         //处于未生效、已关闭或已完成状态的订单,不能执行收货、付款或标记完成操作。
         throw new BIZException("W03009");
     }
     else if (purchaseParent.PaymentFLG == true)
     {
         //此订单已标记付款完成,不能执行付款操作。
         throw new BIZException("W03008");
     }
 }
コード例 #14
0
ファイル: CommodityImpl.cs プロジェクト: marcpiulachs/noahylk
 private void validCheckPurComplete(PurchaseParent purchaseParent)
 {
     if (purchaseParent == null || purchaseParent.Valid == false)
     {
         //指定的订单不存在。
         throw new BIZException("W03003");
     }
     else if (purchaseParent.StatusKBN != 1)
     {
         //处于未生效、已关闭或已完成状态的订单,不能执行收货、付款或标记完成操作。
         throw new BIZException("W03009");
     }
 }
コード例 #15
0
ファイル: CommodityImpl.cs プロジェクト: marcpiulachs/noahylk
        private void UpdatePurOrderParent(PurchaseParent purchaseParent)
        {
            if (purchaseParent.Valid == false)
            {
                return;
            }

            int resutcount = 0;
            try
            {
                resutcount = comdDAO.UpdatePurchaseParent(purchaseParent, this.currentUser);
                if (resutcount != 1)
                {
                    throw new BIZException("W03003");
                }

            }
            catch (Exception ex)
            {
                throw;
            }
        }
コード例 #16
0
ファイル: CommodityImpl.cs プロジェクト: marcpiulachs/noahylk
        /// <summary>
        /// 
        /// </summary>
        /// <param name="purchaseParent"></param>
        /// <returns>parent OrderID</returns>
        private string addPurOrderParent(PurchaseParent purchaseParent)
        {
            if (purchaseParent.Valid == false)
            {
                purchaseParent.OrderId = this.GeneratePurOrderId();
            }

            int resutcount = 0;
            try
            {
                resutcount = comdDAO.AddPurchaseParent(purchaseParent, this.currentUser);
                if (resutcount != 1)
                {
                    throw new BIZException("W03001");
                }

            }
            catch (Exception ex)
            {
                throw;
            }
            return purchaseParent.OrderId;
        }