Exemplo n.º 1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Permissions.ComRedirect(Page, Permissions.redirUrl);
     Response.Cache.SetExpires(DateTime.Now);
     Permissions.CheckManagePermission(EnumCompanyPermission.StorageAddReWareHouse);
     if (!Common.WPermission(Session["Company"].ToString()))
     {
         visdiv.Visible = false;
         Response.Write(Common.ReturnAlert("该管理员没有仓库权限!!"));
         return;
     }
     visdiv.Visible = true;
     if (!IsPostBack)
     {
         CountryModel mode   = CountryBLL.GetCountryModels()[0];
         DataView     dataev = new DataView(BillOutOrderBLL.GetWareHouseName());
         dataev.RowFilter         = "[CountryCode]=" + CountryBLL.GetCountryByCode(mode.ID);
         ddlcangku.DataSource     = dataev;
         ddlcangku.DataTextField  = "WareHouseName";
         ddlcangku.DataValueField = "WareHouseID";
         ddlcangku.DataBind();
         if (string.IsNullOrEmpty(ddlcangku.SelectedValue))
         {
             ViewState["Ekuc"] = "false";
         }
         else
         {
             ViewState["Ekuc"] = "true";
         }
         ddlcangku_SelectedIndexChanged(null, null);
         BtnConfirm_Click(null, null);
     }
     Translations();
 }
Exemplo n.º 2
0
    /// <summary>
    /// 国家与仓库联动
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Country1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataView dataev = new DataView(BillOutOrderBLL.GetWareHouseName());

        //UserControl_Country cou = Page.FindControl("Country1") as UserControl_Country;
        dataev.RowFilter            = "[CountryCode]=" + Convert.ToInt32(this.DropDownList1.SelectedValue);
        ddlWareHouse.DataSource     = dataev;
        ddlWareHouse.DataTextField  = "WareHouseName";
        ddlWareHouse.DataValueField = "WareHouseID";
        ddlWareHouse.DataBind();
        if (string.IsNullOrEmpty(ddlWareHouse.SelectedValue))
        {
            //ddlkuwei.DataSource = AddReportProfit.GetProductWareHouseInfo();
            //ddlkuwei.DataTextField = "name";
            //ddlkuwei.DataValueField = "id";
            //ddlkuwei.DataBind();
            //ddlkuwei.Enabled = false;
            //ddlcangku.Enabled = false;
            ddlWareHouse.Items.Add(new ListItem(GetTran("000592", "无仓库"), "-2"));
            ViewState["Ekuc"] = "false";
        }
        else
        {
            ViewState["Ekuc"] = "true";
        }
        ddlWareHouse_SelectedIndexChanged(null, null);
    }
Exemplo n.º 3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Permissions.ComRedirect(Page, Permissions.redirUrl);
        Response.Cache.SetExpires(DateTime.Now);
        Permissions.CheckManagePermission(EnumCompanyPermission.StorageBrowseBills);
        if (!Common.WPermission(Session["Company"].ToString()))
        {
            vistable.Visible  = false;
            vistable1.Visible = false;
            Response.Write(Common.ReturnAlert("该管理员没有仓库权限!!"));
            return;
        }
        vistable.Visible  = true;
        vistable1.Visible = true;
        if (!IsPostBack)
        {
            //绑定单据类型
            ddltype.DataSource     = DocTypeTableDAL.GetDocTypeTableInfo();
            ddltype.DataTextField  = "DocTypeName";
            ddltype.DataValueField = "DocTypeID";
            ddltype.DataBind();

            CountryModel mode   = CountryBLL.GetCountryModels()[0];
            DataView     dataev = new DataView(BillOutOrderBLL.GetWareHouseName());
            dataev.RowFilter         = "[CountryCode]=" + CountryBLL.GetCountryByCode(mode.ID);
            ddlcangku.DataSource     = dataev;
            ddlcangku.DataTextField  = "WareHouseName";
            ddlcangku.DataValueField = "WareHouseID";
            ddlcangku.DataBind();
            if (string.IsNullOrEmpty(ddlcangku.SelectedValue))
            {
                ViewState["Ekuc"] = "false";
            }
            else
            {
                ViewState["Ekuc"] = "true";
            }
            ddlcangku_SelectedIndexChanged(null, null);

            btnSeach_Click(null, null);

            this.txtshenheren.Text = GetTran("000881", "不限");
            this.txtkaichuren.Text = GetTran("000881", "不限");

            Translations();
        }
    }
Exemplo n.º 4
0
    /// <summary>
    /// 国家与仓库联动
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Country1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataView            dataev = new DataView(BillOutOrderBLL.GetWareHouseName());
        UserControl_Country cou    = Page.FindControl("Country1") as UserControl_Country;

        dataev.RowFilter         = "[CountryCode]='" + CountryBLL.GetCountryByCode(cou.CID) + "'";
        ddlcangku.DataSource     = dataev;
        ddlcangku.DataTextField  = "WareHouseName";
        ddlcangku.DataValueField = "WareHouseID";
        ddlcangku.DataBind();
        if (string.IsNullOrEmpty(ddlcangku.SelectedValue))
        {
            ddlcangku.Items.Add(new ListItem(GetTran("000592", "无仓库"), "-1"));
            ViewState["Ekuc"] = "false";
        }
        else
        {
            ViewState["Ekuc"] = "true";
        }
        ddlcangku_SelectedIndexChanged(null, null);
    }
Exemplo n.º 5
0
    /// <summary>
    /// 国家与仓库联动
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Country1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataView dataev = new DataView(BillOutOrderBLL.GetWareHouseName());

        dataev.RowFilter            = "[CountryCode]=" + Convert.ToInt32(this.DropDownList1.SelectedValue);
        ddlWareHouse.DataSource     = dataev;
        ddlWareHouse.DataTextField  = "WareHouseName";
        ddlWareHouse.DataValueField = "WareHouseID";
        ddlWareHouse.DataBind();
        Translations();
        if (string.IsNullOrEmpty(ddlWareHouse.SelectedValue))
        {
            ddlWareHouse.Items.Add(new ListItem(GetTran("000592", "无仓库"), "-2"));
            ViewState["Ekuc"] = "false";
        }
        else
        {
            ViewState["Ekuc"] = "true";
        }
        ddlWareHouse_SelectedIndexChanged(null, null);
    }
Exemplo n.º 6
0
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (isButton == "出库")
        {
            if (DropCurrery.SelectedItem != null)
            {
                string currency = DropCurrery.SelectedItem.Value;

                string storeOrderID = ((Label)GridView_BillOutOrder.SelectedRow.FindControl("Lab_StoreOrderID")).Text;

                Response.Redirect("Outstock.aspx?StoreOrderID=" + storeOrderID + "&title=" + GetTran("001164", "请填写出库单") + "&enable=N&isBut=CK&source=ck&Country=" + currency);
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("000058", "请选择国家") + "');</script>");
            }
        }
        else if (isButton == "查看")
        {
            string storeOrderID = ((Label)GridView_BillOutOrder.SelectedRow.FindControl("Lab_StoreOrderID")).Text;
            Response.Redirect("ViewStoreOrderD.aspx?storeOrderID=" + storeOrderID);
        }
        else if (isButton == "s查看")
        {
            string storeOrderID = ((Label)GridView2_BilloutOrder.SelectedRow.FindControl("sLab_StoreOrderID")).Text;
            Response.Redirect("ViewStoreOrder.aspx?storeOrderID=" + storeOrderID);
        }
        else if (isButton == "撤单")
        {
            string storeorderid = ((Label)GridView2_BilloutOrder.SelectedRow.FindControl("sLab_StoreOrderID")).Text;

            DataTable dt = DBHelper.ExecuteDataTable("select docid from InventoryDoc where StoreOrderID='" + storeorderid + "'");
            int       i  = 0;
            foreach (DataRow dr in dt.Rows)
            {
                List <InventoryDocDetailsModel> l_ddm = new List <InventoryDocDetailsModel>();
                DataTable l_odm = InventoryDocDetailsBLL.GetInventoryDocDetailsByDocID(dr[0].ToString()); //BillOutOrderBLL.GetOrderDetailModelList(dr[0].ToString());
                foreach (DataRow row in l_odm.Rows)
                {
                    InventoryDocDetailsModel ddm = new InventoryDocDetailsModel();

                    ddm.ProductID       = Convert.ToInt32(row["ProductId"]);
                    ddm.ProductQuantity = Convert.ToDouble(row["ProductQuantity"]);
                    ddm.UnitPrice       = Convert.ToDouble(row["UnitPrice"]);
                    ddm.PV           = Convert.ToDouble(row["PV"]);
                    ddm.ProductTotal = Convert.ToDouble(row["totalPrice"]);
                    ddm.MeasureUnit  = "";

                    l_ddm.Add(ddm);
                }
                if (BillOutOrderBLL.SetQuashBillOutOrder(dr[0].ToString(), l_ddm, storeorderid))
                {
                    i++;
                }
            }

            if (i > 0)
            {
                GridView_BillOutOrder.Visible  = false;
                GridView2_BilloutOrder.Visible = true;


                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("001168", "撤单成功!") + "');</script>");

                Pager1.PageBind(0, 10, " StoreOrder so  left outer join city on so.cpccode=city.cpccode ", @" isSent,StoreID,StoreOrderID,OutStorageOrderID,ExpectNum, OrderType,
                            TotalMoney,TotalPv,IsCheckOut,PayMentDateTime,InceptPerson,InceptAddress,Telephone,Weight,Carriage,OrderDateTime,city.country,city.province,city.city,
                            Description ", ViewState["condition"].ToString(), "StoreOrderID", "GridView2_BilloutOrder", "OrderDateTime", 0);
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("001171", "撤单失败!") + "');</script>");
            }
        }
    }
Exemplo n.º 7
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Permissions.ComRedirect(Page, Permissions.redirUrl);
        Response.Cache.SetExpires(DateTime.Now);
        Permissions.CheckManagePermission(EnumCompanyPermission.LogisticsCompanyConsignOut);

        this.DataBind();

        if (!IsPostBack)
        {
            string storeOrderID = Request.QueryString["StoreOrderID"].ToString();

            TextBox3.Text = GetTran("001711", "订单发货");

            //DataTable dt = BillOutOrderBLL.GetWareHouseName();

            DataTable dt = BillOutOrderBLL.GetWareHouseName_Currency("1");

            if (dt.Rows.Count == 0)
            {
                Response.Write("<script>alert('" + GetTran("001293", "你没有仓库权限,所以不能查看此页面") + "')</script>");
                Response.End();
                return;
            }
            string sql = "select inWareHouseID,inDepotSeatID,storeorderid from InventoryDoc where docid='" + storeOrderID + "'";

            DataTable wd = DBHelper.ExecuteDataTable(sql);
            ViewState["storeorderid"]    = wd.Rows[0][2].ToString();
            DropDownList1.DataTextField  = "WareHouseName";
            DropDownList1.DataValueField = "WareHouseID";
            DropDownList1.DataSource     = dt;
            DropDownList1.DataBind();
            DropDownList1.SelectedValue = wd.Rows[0][0] == null ? "1" : wd.Rows[0][0].ToString();
            DropDownList1.Enabled       = false;
            string wareHouseID = DropDownList1.SelectedItem.Value;

            DropDownList2.DataTextField  = "SeatName";
            DropDownList2.DataValueField = "DepotSeatID";
            DropDownList2.DataSource     = CompanyConsignBLL.GetDepotSeat(wareHouseID);
            DropDownList2.DataBind();
            DropDownList2.Enabled       = false;
            DropDownList2.SelectedValue = wd.Rows[0][1] == null ? "1" : wd.Rows[0][1].ToString();
            string admin = Session["Company"].ToString();

            string[] arrtime = DateTime.Now.ToString("yyyy-MM-dd").Split('-');

            string timestr = arrtime[0];

            if (arrtime[1].Length == 1)
            {
                timestr = timestr + "0" + arrtime[1];
            }
            else
            {
                timestr = timestr + arrtime[1];
            }

            if (arrtime[2].Length == 1)
            {
                timestr = timestr + "0" + arrtime[2];
            }
            else
            {
                timestr = timestr + arrtime[2];
            }

            TextBox1.Text = timestr;
            TextBox2.Text = ViewState["storeorderid"].ToString();

            TextBox4.Text = admin;
            TextBox5.Text = storeOrderID;

            DataTable dtt = DBHelper.ExecuteDataTable("select Number,LogisticsCompany from Logistics");
            DropDownList3.DataTextField  = "LogisticsCompany";
            DropDownList3.DataValueField = "Number";
            DropDownList3.DataSource     = dtt;
            DropDownList3.DataBind();


            ////用于已出库的单不允许选择库位
            //SqlDataReader dr = DAL.DBHelper.ExecuteReader("select IsGeneOutBill,OutStorageOrderID from StoreOrder where StoreOrderID='" + Request.QueryString["StoreOrderID"] + "'");
            //if (dr.Read())
            //{
            //    if (dr["IsGeneOutBill"].ToString().ToLower() == "y")
            //    {
            //        SqlDataReader dr2 = DAL.DBHelper.ExecuteReader("select Note,inWareHouseID,inDepotSeatID from InventoryDoc where DocId='" + dr["OutStorageOrderID"] + "'");

            //        dr.Close();

            //        if (dr2.Read())
            //        {
            //            DropDownList1.SelectedValue = dr2["inWareHouseID"].ToString().Trim();


            //            string bdwareHouseID = DropDownList1.SelectedItem.Value;

            //            DropDownList2.DataSource = null;
            //            DropDownList2.DataTextField = "SeatName";
            //            DropDownList2.DataValueField = "DepotSeatID";
            //            DropDownList2.DataSource = CompanyConsignBLL.GetDepotSeat(bdwareHouseID);
            //            DropDownList2.DataBind();
            //        }

            //        TextBox6.Text = dr2["Note"].ToString();

            //        dr2.Close();

            //        DropDownList1.Enabled = false;
            //        DropDownList2.Enabled = false;
            //    }
            //}
        }
    }
Exemplo n.º 8
0
    protected void loadData()
    {
        string storeOrderID = Request.QueryString["StoreOrderID"];

        Label1.Text = Request.QueryString["title"].ToString();
        string isEnabledDropDownList = Request.QueryString["enable"].ToString().Replace("'", "").Replace("-", "").Replace("/*", "");
        string isButton = Request.QueryString["isBut"].ToString().Replace("'", "").Replace("-", "").Replace("/*", "");

        if (isEnabledDropDownList == "Y")
        {
            DropDownList1.Enabled = false;
            DropDownList2.Enabled = false;

            fhck.Visible = false;
        }

        if (isButton == "CK")
        {
            TextBox3.Text = GetTran("001294", "订单出库");
        }
        else
        {
            Button1.Visible = false;
            TextBox3.Text   = GetTran("001711", "订单发货");
        }

        if (storeOrderID.EndsWith(","))
        {
            storeOrderID = storeOrderID.Substring(0, storeOrderID.Length - 1);
        }

        string allStoreOrderID = ("'" + storeOrderID + "'").Replace(",", "','");

        string sql = "select w.WareHouseid,d.DepotSeatid from storeorder s join city c on s.cpccode=c.cpccode join DepotSeat d on c.DepotSeatid=d.DepotSeatid join WareHouse w on d.WareHouseid=w.WareHouseid where storeorderid in(" + allStoreOrderID + ")";

        DataTable dt = BillOutOrderBLL.GetWareHouseName_Currency("1");

        if (dt.Rows.Count == 0)
        {
            Response.Write("<script>alert('" + GetTran("001293", "你没有仓库权限,所以不能查看此页面") + "')</script>");
            Response.End();
            return;
        }
        DropDownList1.DataSource = dt;
        DropDownList1.DataBind();

        string wareHouseID = DropDownList1.SelectedItem.Value;

        DropDownList2.DataSource = CompanyConsignBLL.GetDepotSeat(wareHouseID);
        DropDownList2.DataBind();

        string admin = Session["Company"].ToString();

        string[] arrtime = DateTime.Now.ToString("yyyy-MM-dd").Split('-');

        string timestr = arrtime[0];

        if (arrtime[1].Length == 1)
        {
            timestr = timestr + "0" + arrtime[1];
        }
        else
        {
            timestr = timestr + arrtime[1];
        }

        if (arrtime[2].Length == 1)
        {
            timestr = timestr + "0" + arrtime[2];
        }
        else
        {
            timestr = timestr + arrtime[2];
        }

        TextBox1.Text = timestr;
        TextBox2.Text = storeOrderID;

        TextBox4.Text = admin;
        TextBox5.Text = storeOrderID;

        string bind = "select p.productid,productcode,productname,quantity,price,pv ,outbillquantity,(quantity-outbillquantity) as [count] from orderdetail o " +
                      " join product p on o.productid=p.productid where storeorderid='" + Request.QueryString["StoreOrderID"] + "'";
        DataTable dt2 = DBHelper.ExecuteDataTable(bind);

        Repeater1.DataSource = dt2;
        Repeater1.DataBind();

        Translations();
    }
Exemplo n.º 9
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (DropDownList2.SelectedItem == null || DropDownList1.SelectedItem == null)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("001301", "请选择创库和库位!") + "')</script>");
            this.Button1.Text = GetTran("001290", "确定出库");
        }
        else
        {
            string err = "";
            string PrepareProduct_PrepareTime = DateTime.Now.ToString();
            string PrepareProduct_OperateNum  = Session["Company"].ToString();
            string PrepareProduct_OperateIP   = Request.UserHostAddress;
            string outStorageOrderID          = "";
            string GroupCK = "";

            string[] arrstoreOrderID = Request.QueryString["StoreOrderID"].ToString().Replace("'", "").Replace("-", "").Replace("/*", "").Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);

            for (int k = 0; k < arrstoreOrderID.Length; k++)
            {
                outStorageOrderID = "CK" + OrderGoodsBLL.GetNewOrderID();
                GroupCK           = GroupCK + outStorageOrderID + ",";

                StoreOrderModel         som   = BillOutOrderBLL.GetStoreOrderModel_II(arrstoreOrderID[k]);
                List <OrderDetailModel> l_odm = BillOutOrderBLL.GetOrderDetailModelList(arrstoreOrderID[k]);

                string            sql     = "select isnull(m.number,'') number,s.storeid,s.sendway from storeorder s left join ordergoods o on s.storeorderid=o.fahuoorder left join memberorder m on o.memberorderid=m.orderid where s.storeorderid='" + arrstoreOrderID[k] + "'";
                DataTable         dt      = DBHelper.ExecuteDataTable(sql);
                string            sendway = dt.Rows[0]["sendway"].ToString();
                string            number  = dt.Rows[0]["number"].ToString();
                string            storeid = dt.Rows[0]["storeid"].ToString();
                InventoryDocModel idm     = new InventoryDocModel();

                //idm.DocAuditTime = som.AuditingDate;
                idm.DocTypeID = Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select DocTypeId from dbo.DocTypeTable where DocTypeCode='CK'"));   //出库单
                idm.DocMaker  = TextBox4.Text;
                if (sendway == "1")
                {
                    idm.Client = number;
                }
                else
                {
                    idm.Client = storeid;
                }
                idm.DepotSeatID     = Convert.ToInt32(DropDownList2.SelectedItem.Value);
                idm.WareHouseID     = Convert.ToInt32(DropDownList1.SelectedItem.Value);
                idm.ExpectNum       = som.ExpectNum;
                idm.Note            = TextBox6.Text.Trim();
                idm.StateFlag       = 1;
                idm.CloseFlag       = 0;
                idm.OperationPerson = "";//业务员
                idm.OriginalDocID   = arrstoreOrderID[k];
                idm.Address         = som.InceptAddress;
                idm.Storeorderid    = arrstoreOrderID[k];

                List <InventoryDocDetailsModel> l_ddm = new List <InventoryDocDetailsModel>();
                double totalmoney = 0;
                double totalpv    = 0;
                foreach (RepeaterItem item in Repeater1.Items)
                {
                    HiddenField HF        = (HiddenField)item.FindControl("HF");
                    Label       lblPrice  = (Label)item.FindControl("lblPrice");
                    Label       lblPV     = (Label)item.FindControl("lblPV");
                    Label       txtCount1 = (Label)item.FindControl("txtCount1");
                    TextBox     txtCount  = (TextBox)item.FindControl("txtCount");
                    int         count     = 0;

                    int.TryParse(txtCount.Text, out count);

                    if (count > 0)
                    {
                        if (Convert.ToInt32(txtCount.Text) > Convert.ToInt32(txtCount1.Text))
                        {
                            ScriptManager.RegisterStartupScript(this, GetType(), "msg", "alert('" + GetTran("007716", "出库数量不能大于剩余数量!") + "');", true);
                            this.Button1.Text = GetTran("001290", "确定出库");
                            return;
                        }

                        if (Convert.ToInt32(DAL.DBHelper.ExecuteScalar("select COUNT(0) from OrderDetail where StoreOrderID='" + arrstoreOrderID[k] + "' and ProductID=" + Convert.ToInt32(HF.Value) + " and (Quantity-OutBillQuantity)<" + count)) > 0)
                        {
                            ScriptManager.RegisterStartupScript(this, GetType(), "msg", "alert('" + GetTran("007716", "出库数量不能大于剩余数量!") + "');", true);
                            this.Button1.Text = GetTran("001290", "确定出库");
                            loadData();
                            return;
                        }

                        InventoryDocDetailsModel ddm = new InventoryDocDetailsModel();

                        ddm.ProductID       = Convert.ToInt32(HF.Value);
                        ddm.ProductQuantity = Convert.ToInt32(txtCount.Text);
                        ddm.UnitPrice       = Convert.ToDouble(lblPrice.Text);
                        ddm.PV           = Convert.ToDouble(lblPV.Text);
                        ddm.ProductTotal = Convert.ToDouble(txtCount.Text) * Convert.ToDouble(lblPrice.Text);
                        ddm.MeasureUnit  = "";
                        totalmoney      += Convert.ToDouble(txtCount.Text) * Convert.ToDouble(lblPrice.Text);
                        totalpv         += Convert.ToDouble(txtCount.Text) * Convert.ToDouble(lblPV.Text);
                        l_ddm.Add(ddm);
                    }
                }
                idm.TotalMoney = totalmoney;
                idm.TotalPV    = totalpv;
                if (l_ddm.Count <= 0)
                {
                    string getcount = " select sum(quantity-outbillquantity) from orderdetail where storeorderid='" + arrstoreOrderID[k] + "'";
                    object ckk      = DBHelper.ExecuteScalar(getcount, CommandType.Text);
                    if (ckk.ToString() == null || ckk.ToString() == "")
                    {
                        ScriptManager.RegisterStartupScript(this, GetType(), "msg", "alert('没有商品暂时没法出库!')", true);
                    }
                    else
                    {
                        if (int.Parse(ckk.ToString()) <= 0)
                        {
                            DBHelper.ExecuteNonQuery("update storeorder set IsGeneOutBill='A' where storeorderid='" + arrstoreOrderID[k] + "'");
                        }
                    }
                    ScriptManager.RegisterStartupScript(this, GetType(), "msg", "alert('" + GetTran("007721", "请输入出库数量!") + "')", true);
                    this.Button1.Text = GetTran("001290", "确定出库");
                    return;
                }

                string rt = BillOutOrderBLL.OutOrder(arrstoreOrderID[k], outStorageOrderID, idm, l_ddm);

                if (rt == "1")
                {
                    int hs = 0;

                    string getcount = " select sum(quantity-outbillquantity) from orderdetail where storeorderid='" + arrstoreOrderID[k] + "'";
                    if (int.Parse(DBHelper.ExecuteScalar(getcount, CommandType.Text).ToString()) <= 0)
                    {
                        hs = DBHelper.ExecuteNonQuery("update storeorder set IsGeneOutBill='A' where storeorderid='" + arrstoreOrderID[k] + "'");
                    }
                    else
                    {
                        hs = DBHelper.ExecuteNonQuery("update storeorder set IsGeneOutBill='Y' where storeorderid='" + arrstoreOrderID[k] + "'");
                    }
                    if (hs == 1)
                    {
                        //PrepareProduct_DocIDs = PrepareProduct_DocIDs + arrstoreOrderID[k] + ",";
                        //PrepareProduct_TotalMoney = PrepareProduct_TotalMoney + Convert.ToDouble(idm.TotalMoney);
                        //PrepareProduct_TotalPv = PrepareProduct_TotalPv + Convert.ToDouble(idm.TotalPV);
                    }
                    else
                    {
                        err = err + GetTran("000079", "订单号:") + arrstoreOrderID[k] + GetTran("007722", " 的产品出库失败!");
                    }
                }
                else if (rt == "0")
                {
                    err = err + GetTran("000079", "订单号:") + arrstoreOrderID[k] + GetTran("007723", " 的产品库存不够!");
                }
                else if (rt == "-6")
                {
                    err = err + GetTran("000079", "订单号:") + arrstoreOrderID[k] + GetTran("007724", " 的产品仓库库位上没有货!");
                }
                else if (rt == "-5")
                {
                    err = err + GetTran("000079", "订单号:") + arrstoreOrderID[k] + GetTran("007725", " 的产品更新出库数量错误!");
                }
                else if (rt == "-88")
                {
                    err = err + GetTran("000079", "订单号:") + arrstoreOrderID[k] + GetTran("007726", " 的产品已经出库!");
                }
                else
                {
                    err = err + GetTran("000079", "订单号:") + arrstoreOrderID[k] + GetTran("007727", " 的产品出库失败!");
                }
            }

            if (err == "")
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>if(window.confirm('" + GetTran("001297", "生成的出库单号为:") + outStorageOrderID + GetTran("001298", ",您要打印此出库单吗?") + "')) window.open('docPrint.aspx?docID=" + outStorageOrderID + "');window.location.href='BillOutOrder.aspx';</script>");
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + err + "');window.location.href='BillOutOrder.aspx'</script>");
            }

            this.Button1.Text = GetTran("001290", "确定出库");
        }
    }
Exemplo n.º 10
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Permissions.ComRedirect(Page, Permissions.redirUrl);
        if (!IsPostBack)
        {
            Response.Cache.SetExpires(DateTime.Now);
            Permissions.CheckManagePermission(EnumCompanyPermission.StorageAddReWareHouse);

            this.DropCurrery.DataSource     = CountryBLL.GetCountryModels();
            this.DropCurrery.DataTextField  = "name";
            this.DropCurrery.DataValueField = "countrycode";
            this.DropCurrery.DataBind();

            int cID = Convert.ToInt32(DropCurrery.SelectedItem.Value);

            //绑定入库仓库
            //this.ddlinwareHouse.DataSource = BillOutOrderBLL.GetWareHouseName();

            CountryModel mode   = CountryBLL.GetCountryModels()[0];
            DataView     dataev = new DataView(BillOutOrderBLL.GetWareHouseName());
            dataev.RowFilter                   = "[CountryCode]=" + CountryBLL.GetCountryByCode(mode.ID);
            ddlinwareHouse.DataSource          = dataev;
            this.ddlinwareHouse.DataTextField  = "WareHouseName";
            this.ddlinwareHouse.DataValueField = "WareHouseID";
            this.ddlinwareHouse.DataBind();
            if (string.IsNullOrEmpty(ddlinwareHouse.SelectedValue))
            {
                ddlinwareHouse.DataSource     = AddReportProfit.GetProductWareHouseInfo();
                ddlinwareHouse.DataTextField  = "name";
                ddlinwareHouse.DataValueField = "id";
                ddlinwareHouse.DataBind();
                ddlinwareHouse.Enabled    = false;
                ddlintDepotSeatID.Enabled = false;
                ViewState["Ekuc"]         = "false";
            }
            //绑定出库仓库
            //this.ddloutWareHouse.DataSource = BillOutOrderBLL.GetWareHouseName();

            DataView dataev1 = new DataView(BillOutOrderBLL.GetWareHouseName());
            dataev1.RowFilter                   = "[CountryCode]=" + CountryBLL.GetCountryByCode(mode.ID);
            ddloutWareHouse.DataSource          = dataev1;
            this.ddloutWareHouse.DataTextField  = "WareHouseName";
            this.ddloutWareHouse.DataValueField = "WareHouseID";
            this.ddloutWareHouse.DataBind();
            if (string.IsNullOrEmpty(ddloutWareHouse.SelectedValue))
            {
                ddloutWareHouse.DataSource     = AddReportProfit.GetProductWareHouseInfo();
                ddloutWareHouse.DataTextField  = "name";
                ddloutWareHouse.DataValueField = "id";
                ddloutWareHouse.DataBind();
                ddloutWareHouse.Enabled   = false;
                ddloutDepotSeatID.Enabled = false;
                ViewState["Ekuc"]         = "false";
            }
            else
            {
                ViewState["Ekuc"] = "true";
            }
            ddloutWareHouse_SelectedIndexChanged(null, null);
            ddlinwareHouse_SelectedIndexChanged(null, null);
            //绑定产品列表
            gridBind(cID, Convert.ToInt32(ddloutWareHouse.SelectedValue), Convert.ToInt32(ddloutDepotSeatID.SelectedValue));
        }
        Translations();
    }