示例#1
0
    protected void init()
    {
        string str0 = Request.QueryString["ReceiptOrderID"].ToString();
        string str1 = Request.QueryString["ReceiptOrderDate"].ToString();
        string str2 = Request.QueryString["StoreHouseID"].ToString();
        string str3 = Request.QueryString["HouseDetailID"].ToString();
        string str4 = Request.QueryString["BuyOrderID"].ToString();
        string str5 = Request.QueryString["Identitys"].ToString();
        string str6 = Request.QueryString["TradeDate"].ToString();
        string str7 = Request.QueryString["Description"].ToString();

        BuyReceipt b = new BuyReceipt();

        b.BuyOrderID       = str4;
        b.Description      = str7;
        b.HouseDetailID    = int.Parse(str3);
        b.Identitys        = int.Parse(str5);
        b.ReceiptOrderDate = str1;
        b.ReceiptOrderID   = str0;
        b.StoreHouseID     = int.Parse(str2);
        b.TradeDate        = str6;
        b.UserName         = "******";
        if (Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().insertNewEntity(b))
        {
            Response.Write("0");
            Response.End();
        }
        else
        {
            Response.Write("1");
            Response.End();
        }
    }
示例#2
0
        public BuyReceipt getByID(string ReceiptOrderID)
        {
            string s = "";

            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ReceiptOrderID", SqlDbType.NVarChar) };
            parameters[0].Value = ReceiptOrderID;
            BuyReceipt    receipt = new BuyReceipt();
            SqlDataReader reader  = SQLHelper.RunProcedure("p_BuyReceipt_getByID", parameters);

            if (reader.Read())
            {
                receipt.ReceiptOrderDate = reader.GetString(reader.GetOrdinal("ReceiptOrderDate"));
                receipt.ReceiptOrderID   = reader.GetString(reader.GetOrdinal("ReceiptOrderID"));
                receipt.BuyOrderID       = reader.GetString(reader.GetOrdinal("BuyOrderID"));
                receipt.Description      = reader.GetString(reader.GetOrdinal("Description"));
                receipt.HouseDetailID    = reader.GetInt32(reader.GetOrdinal("HouseDetailID"));
                receipt.Identitys        = reader.GetInt32(reader.GetOrdinal("Identitys"));
                receipt.TradeDate        = reader.GetString(reader.GetOrdinal("TradeDate"));
                receipt.State            = reader.GetInt32(reader.GetOrdinal("State"));
                s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString();
                receipt.TotalPrice = float.Parse(s);
                s = reader.GetValue(reader.GetOrdinal("AlreadyPay")).ToString();
                receipt.AlreadyPay   = float.Parse(s);
                receipt.StoreHouseID = reader.GetInt32(reader.GetOrdinal("StoreHouseID"));
                receipt.UserName     = reader.GetString(reader.GetOrdinal("UserName"));
            }
            reader.Close();
            return(receipt);
        }
示例#3
0
    protected void init()
    {
        string str0     = Request.QueryString["ReceiptOrderID"].ToString();
        string username = "******";///////////////////////////////////////////////???

        BuyReceipt b = new BuyReceipt();

        b = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getByID(str0);
        if (b.UserName.Equals(username))
        {
            if (Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().deleteEitity(str0))
            {
                Panel1.Visible = true;
            }
            else
            {
                Response.Write("操作失败");
                Response.End();
            }
        }
        else
        {
            Response.Write("操作失败!没有权限");
            Response.End();
        }
    }
    protected void init()
    {
        string action = Request.QueryString["action"].ToString();

        if (action.Equals("shenhe"))
        {
            string        AuditingId = Request.QueryString["AuditingId"].ToString();
            StringBuilder sb         = new StringBuilder();
            string[]      a          = AuditingId.Split('#');
            Leyp.SQLServerDAL.Buy.BuyReceiptDAL bl = new Leyp.SQLServerDAL.Buy.BuyReceiptDAL();
            int num = 0;
            for (int i = 0; i < a.Length; i++)
            {
                BuyReceipt b = new BuyReceipt();
                b = bl.getByID(a[i]);
                if (b.State == 1)//已经审核
                {
                    sb.Append("订单号:" + a[i] + " 已经审核不能再审核 <br/>");
                }
                else
                {
                    bl.AuditingBuyReceiptOrder(a[i]);
                    num++;
                }
            }
            sb.Append("成功审核入库 " + num + "条 &nbsp; &nbsp;&nbsp; &nbsp; <a href=\"Manager_BuyReceipOrder.aspx\">返回列表</a>");
            Response.Write(sb.ToString());
        }
        else if (action.Equals("delete"))
        {
            string        AuditingId = Request.QueryString["AuditingId"].ToString();
            StringBuilder sb         = new StringBuilder();
            string[]      a          = AuditingId.Split('#');
            Leyp.SQLServerDAL.Buy.BuyReceiptDAL bl = new Leyp.SQLServerDAL.Buy.BuyReceiptDAL();
            int num = 0;

            for (int i = 0; i < a.Length; i++)
            {
                BuyReceipt b = new BuyReceipt();
                b = bl.getByID(a[i]);
                if (b.State == 1) //已经审核
                {
                    sb.Append("订单号:" + a[i] + " 已经审核不能删除 <br/>");
                }
                else
                {
                    bl.deleteEitity(a[i]);
                    num++;
                }
            }
            sb.Append("成功删除 " + num + "条 &nbsp; &nbsp;&nbsp; &nbsp; <a href=\"Manager_BuyReceipOrder.aspx\">返回列表</a>");
            Response.Write(sb.ToString());
        }
    }
示例#5
0
    public void init()
    {
        object action = Request.QueryString["action"].ToString();

        if (action == null)
        {
        }
        else if (action.ToString().Equals("BuyPayLoad"))///在添加采购付款是使用
        {
            string         str0  = Request.QueryString["BuyReceiptID"].ToString();
            float          Total = float.Parse("0.00");
            List <VBuyPay> list  = new List <VBuyPay>();
            BuyReceipt     vb    = new BuyReceipt();
            vb   = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getByID(str0);
            list = Leyp.SQLServerDAL.Buy.Factory.getBuyPayDAL().getByBuyReceiptID(str0);
            for (int i = 0; i < list.Count; i++)
            {
                VBuyPay b = list[i];
                Total = Total + b.RealPay;
            }

            Response.Write(vb.TotalPrice + "$$$" + Total.ToString());
            Response.End();
        }
        else if (action.ToString().Equals("BuyPayLoadAdd"))//添加一个采购单
        {
            string str0 = Request.QueryString["BuyReceiptID"].ToString();
            string str1 = Request.QueryString["Ticket"].ToString();
            string str2 = Request.QueryString["CreateDate"].ToString();
            string str3 = Request.QueryString["PayType"].ToString();
            string str4 = Request.QueryString["RealPay"].ToString();
            string str5 = Request.QueryString["AttachPay"].ToString();
            string str6 = Request.QueryString["Description"].ToString();

            BuyPay b = new BuyPay();
            b.BuyReceiptID = str0;
            b.Ticket       = str1;
            b.CreateDate   = str2;
            b.PayType      = str3;
            b.RealPay      = float.Parse(str4);
            b.AttachPay    = float.Parse(str5);
            b.Description  = str6;
            b.UserName     = "******";
            Leyp.SQLServerDAL.Buy.Factory.getBuyPayDAL().insertNewEntity(b);
            Response.Write("添加成功");
            Response.End();
        }
    }
    protected void init()
    {
        object action = Request.QueryString["action"];

        if (action != null)
        {
            if (action.ToString().Equals("date"))
            {
                string str0 = Request.QueryString["baginData"].ToString();
                string str1 = Request.QueryString["endData"].ToString();
                if (str0.Equals(""))
                {
                    str0 = "1000";
                }
                if (str1.Equals(""))
                {
                    str1 = "3000";
                }

                List <VBuyReceipt> list = new List <VBuyReceipt>();
                list = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getAdminBuyReceiptOrderList(str0, str1, 2);

                CollectionPager1.DataSource    = list;
                CollectionPager1.BindToControl = OrderList;
                OrderList.DataSource           = CollectionPager1.DataSourcePaged;
            }
            else
            {
                string     id = Request.QueryString["ID"].ToString();
                BuyReceipt o  = new BuyReceipt();
                o = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getByID(id);

                Jscript.CloseWindowReturnValues(o.ReceiptOrderID + "$$$" + o.StoreHouseID + "$$$" + o.HouseDetailID);
                return;
            }
        }
        else  //初始化页面
        {
            List <VBuyReceipt> list = new List <VBuyReceipt>();
            list = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getAdminBuyReceiptOrderList("1000", "3000", 2);

            CollectionPager1.DataSource    = list;
            CollectionPager1.BindToControl = OrderList;
            OrderList.DataSource           = CollectionPager1.DataSourcePaged;
        }
    }
示例#7
0
        public bool insertNewEntity(BuyReceipt b)
        {
            int   rowsAffected = 0;
            float num2         = float.Parse("0.00");

            if (b.Identitys == 0)
            {
                BuyReceiptDetailDAL    ldal = new BuyReceiptDetailDAL();
                List <VBuyOrderDetail> list = new List <VBuyOrderDetail>();
                list = new BuyOrderDetailDAL().getBuyOrderDetailByBuyOrderID(b.BuyOrderID);
                for (int i = 0; i < list.Count; i++)
                {
                    BuyReceiptDetail detail  = new BuyReceiptDetail();
                    BuyOrderDetail   detail2 = list[i];
                    detail.Description    = detail2.Description;
                    detail.DiscountRate   = detail2.DiscountRate;
                    detail.Price          = detail2.Price;
                    detail.ProductsID     = detail2.ProductsID;
                    detail.Quantity       = detail2.Quantity;
                    detail.SupplierID     = detail2.SupplierID;
                    detail.TaxRate        = detail2.TaxRate;
                    detail.ReceiptOrderID = b.ReceiptOrderID;
                    ldal.insertNewEitity(detail);
                    num2 += (((detail.Quantity * detail.Price) * (100f + detail.TaxRate)) / 100f) - (((detail.Quantity * detail.Price) * detail.DiscountRate) / 100f);
                }
            }
            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ReceiptOrderID", SqlDbType.NVarChar), new SqlParameter("@ReceiptOrderDate", SqlDbType.NVarChar), new SqlParameter("@StoreHouseID", SqlDbType.Int), new SqlParameter("@HouseDetailID", SqlDbType.Int), new SqlParameter("@BuyOrderID", SqlDbType.NVarChar), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@TotalPrice", SqlDbType.Money), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@Identitys", SqlDbType.Int), new SqlParameter("@AlreadyPay", SqlDbType.Money), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int) };
            parameters[0].Value  = b.ReceiptOrderID;
            parameters[1].Value  = b.ReceiptOrderDate;
            parameters[2].Value  = b.StoreHouseID;
            parameters[3].Value  = b.HouseDetailID;
            parameters[4].Value  = b.BuyOrderID;
            parameters[5].Value  = b.UserName;
            parameters[6].Value  = num2;
            parameters[7].Value  = b.TradeDate;
            parameters[8].Value  = b.Identitys;
            parameters[9].Value  = b.AlreadyPay;
            parameters[10].Value = b.Description;
            parameters[11].Value = b.State;
            SQLHelper.RunProcedure("p_BuyReceipt_insertNewEntity", parameters, out rowsAffected);
            return(0 < rowsAffected);
        }
示例#8
0
        public bool AuditingBuyReceiptOrder(string ReceiptOrderID)
        {
            bool flag = false;

            try
            {
                BuyReceipt receipt            = new BuyReceipt();
                List <VBuyReceiptDetail> list = new List <VBuyReceiptDetail>();
                ProductsStockDAL         kdal = new ProductsStockDAL();
                receipt = new BuyReceiptDAL().getByID(ReceiptOrderID);
                list    = new BuyReceiptDetailDAL().getBuyReceiptDetailByReceiptOrderID(ReceiptOrderID);
                for (int i = 0; i < list.Count; i++)
                {
                    ProductsStock    stock;
                    BuyReceiptDetail detail = list[i];
                    if (kdal.isHaveEitity(receipt.HouseDetailID, detail.ProductsID))
                    {
                        stock = new ProductsStock();
                        stock.HouseDetailID = receipt.HouseDetailID;
                        stock.ProductsID    = detail.ProductsID;
                        stock.Num           = detail.Quantity;
                        kdal.updateAddNum(stock);
                    }
                    else
                    {
                        stock = new ProductsStock();
                        stock.HouseDetailID = receipt.HouseDetailID;
                        stock.ProductsID    = detail.ProductsID;
                        stock.Num           = detail.Quantity;
                        kdal.insertNewEitity(stock);
                    }
                }
                flag = true;
            }
            catch
            {
            }
            return(flag);
        }