Пример #1
0
        public List<SaleDeliveryEntity> SearchSaleDeliveryListByOrderID(string strSaleOrderID)
        {
            List<SaleDeliveryEntity> saleDeliveryEntityList = new List<SaleDeliveryEntity>();

            string sqlStr = dbUtil.getSqlStatement("SQL_Comd_SaleDeliveryList_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)
                    {
                        SaleDeliveryEntity saleDeliveryEntity = new SaleDeliveryEntity();

                        saleDeliveryEntity.OrderId = dr["SaleOrderID"].ToString();
                        saleDeliveryEntity.DetailId = Convert.ToInt32(dr["SaleOrderDetailID"]);
                        saleDeliveryEntity.CommId = dr["ComdID"].ToString();
                        saleDeliveryEntity.CommName = dr["ComdName"].ToString();
                        saleDeliveryEntity.Standard = dr["ComdStandard"].ToString();
                        saleDeliveryEntity.Unit = dr["Unit"].ToString();

                        saleDeliveryEntity.AmountTotal = Convert.ToInt32(dr["amountTotal"]);
                        saleDeliveryEntity.AmountDelivered = Convert.ToInt32(dr["amountDelivered"]);
                        saleDeliveryEntity.AmountDelivering = 0;

                        saleDeliveryEntity.Remark = dr["Remark"].ToString();
                        saleDeliveryEntity.DeliveringEmp = dr["DeliveryEmp"].ToString();
                        saleDeliveryEntity.DeliveringDate = dr["DeliveryDate"].ToString();

                        saleDeliveryEntityList.Add(saleDeliveryEntity);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new DAOException("E0001");
            }

            return saleDeliveryEntityList;
        }
Пример #2
0
        public int AddSaleDelivery(SaleDeliveryEntity saleDeliveryEntity, string currentUser)
        {
            string sqlStr = dbUtil.getSqlStatement("SQL_Comd_SaleDelivery_Insert");

            SqlParameter[] sqlParms = {
                new SqlParameter("@SaleOrderID",SqlDbType.VarChar,20),
                new SqlParameter("@SaleOrderDetailID",SqlDbType.VarChar,20),
                new SqlParameter("@ComdID",SqlDbType.VarChar,20),
                new SqlParameter("@amount",SqlDbType.Int),
                new SqlParameter("@DeliveryEmp",SqlDbType.VarChar,20),
                new SqlParameter("@DeliveryDate",SqlDbType.VarChar,10),
                new SqlParameter("@Remark",SqlDbType.NVarChar,800),
                new SqlParameter("@CreateUser",SqlDbType.VarChar,20),
                new SqlParameter("@UpdateUser",SqlDbType.VarChar,20)
            };

            sqlParms[0].Value = saleDeliveryEntity.OrderId;
            sqlParms[1].Value = saleDeliveryEntity.DetailId;
            sqlParms[2].Value = saleDeliveryEntity.CommId;
            sqlParms[3].Value = saleDeliveryEntity.AmountDelivering;
            sqlParms[4].Value = saleDeliveryEntity.DeliveringEmp;
            sqlParms[5].Value = saleDeliveryEntity.DeliveringDate;
            sqlParms[6].Value = saleDeliveryEntity.Remark;
            sqlParms[7].Value = currentUser;
            sqlParms[8].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;
        }
Пример #3
0
 private void addSaleDeliveryItem(SaleDeliveryEntity saleDeliveryEntity)
 {
     try
     {
         int resultCount = 0;
         resultCount = comdDAO.AddSaleDelivery(saleDeliveryEntity, this.currentUser);
         if (resultCount == 0)
         {
             throw new DAOException("E0001");
         }
     }
     catch (Exception ex)
     {
         throw;
     }
 }