using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
using System.Web.UI;
|
using System.Web.UI.WebControls;
|
using CY.Infrastructure.Query;
|
using CY.BLL.OA;
|
using CY.Model;
|
using System.Data;
|
using CY.Infrastructure.Common;
|
using CY.BLL;
|
namespace CY.WebForm.Pages.procurement
|
{
|
//库存表信息
|
public partial class InventoryList : BasePage
|
{
|
OA_WarehouseInfoBLL _OA_WarehouseInfoBLL = null;
|
OA_InventoryBLL _OA_InventoryBLL = null;
|
OA_SpecificationBLL _OA_SpecificationBLL = null;
|
OA_GoodsInfoBLL _OA_GoodsInfoBLL = null;
|
OA_PaperWeightBLL _OA_PaperWeightBLL = null;
|
OA_BrandBLL _OA_BrandBLL = null;
|
OA_CommodityBLL _OA_CommodityBLL = null;
|
OA_StaffBLL bll_OA_StaffBLL = null;
|
|
public InventoryList()
|
{
|
bll_OA_StaffBLL = new OA_StaffBLL();
|
_OA_CommodityBLL = new OA_CommodityBLL();
|
_OA_GoodsInfoBLL = new OA_GoodsInfoBLL();
|
_OA_SpecificationBLL = new OA_SpecificationBLL();
|
_OA_WarehouseInfoBLL = new OA_WarehouseInfoBLL();
|
_OA_InventoryBLL = new OA_InventoryBLL();
|
_OA_BrandBLL = new OA_BrandBLL();
|
_OA_PaperWeightBLL = new OA_PaperWeightBLL();
|
}
|
|
protected void Page_Load(object sender, EventArgs e)
|
{
|
UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
|
if (!IsPostBack)
|
{
|
BindList();
|
InitialData();
|
}
|
}
|
|
protected void InitialData()
|
{
|
//仓库
|
this.selWarehouseId.DataSource = _OA_WarehouseInfoBLL.getAllWarehouseInfo(CurrentUser.MemberId);
|
this.selWarehouseId.DataTextField = "WarehouseName";
|
this.selWarehouseId.DataValueField = "Keyid";
|
this.selWarehouseId.DataBind();
|
this.selWarehouseId.Items.Insert(0, new ListItem("全部", ""));
|
//货品类别
|
dwCommity.Items.Insert(0, new ListItem("全部", ""));
|
DataTable ds = _OA_CommodityBLL.SelectModelPage(CurrentUser.MemberId, "", "true");
|
GetDataByLevel(dwCommity, ds, 0, 0);
|
|
dwBrand.Items.Insert(0, new ListItem("全部", ""));
|
dwGoodsList.Items.Insert(0, new ListItem("全部", ""));
|
dwPaperWeight.Items.Insert(0, new ListItem("全部", ""));
|
dwSpecification.Items.Insert(0, new ListItem("全部", ""));
|
|
}
|
|
/// <summary>
|
/// 产品类别
|
/// </summary>
|
/// <param name="dwCommity"></param>
|
/// <param name="data"></param>
|
/// <param name="parentId"></param>
|
/// <param name="level"></param>
|
public static void GetDataByLevel(System.Web.UI.WebControls.DropDownList dwCommity, DataTable data, int parentId, int level)
|
{
|
DataRow[] result = data.Select(string.Format("ParentId={0}", parentId));
|
int i = -1;
|
while (++i < result.Length)
|
{
|
dwCommity.Items.Add(new ListItem(GetSplitChar(level) + result[i]["CommodityName"].ToString2(), result[i]["Keyid"].ToString2()));
|
GetDataByLevel(dwCommity, data, result[i]["Keyid"].ToInt32().Value, level + 1);
|
|
}
|
}
|
|
public static string GetSplitChar(int level)
|
{
|
string splitchar = "";
|
int i = -1;
|
while (++i < level)
|
{
|
splitchar += ".";
|
}
|
return splitchar;
|
}
|
|
/// <summary>
|
/// 类别选取
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
protected void dwCommity_SelectedIndexChanged(object sender, EventArgs e)
|
{
|
DataTable ds = _OA_GoodsInfoBLL.SlectModleByCommity(dwCommity.SelectedValue, CurrentUser.MemberId);
|
if (ds.Rows.Count > 0)
|
{
|
dwGoodsList.DataSource = ds;
|
dwGoodsList.DataTextField = "GoodsName";
|
dwGoodsList.DataValueField = "Keyid";
|
dwGoodsList.DataBind();
|
dwGoodsList.Items.Insert(0, new ListItem("全部", ""));
|
}
|
else
|
{
|
dwGoodsList.Items.Clear();
|
dwGoodsList.Items.Insert(0, new ListItem("全部", ""));
|
}
|
BindList();
|
//indecChage();
|
}
|
|
/// <summary>
|
/// 根据产品名初始化数据
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
protected void dwGoodsList_SelectedIndexChanged(object sender, EventArgs e)
|
{
|
indecChage();
|
BindList();
|
}
|
|
/// <summary>
|
/// 根据货品类别和货品名称选择规格和品牌
|
/// </summary>
|
protected void indecChage()
|
{
|
///品牌
|
DataTable dt_brand = _OA_BrandBLL.getAllBrand(CurrentUser.MemberId, this.dwCommity.SelectedValue, this.dwGoodsList.SelectedValue);
|
if (dt_brand.Rows.Count > 0)
|
{
|
dwBrand.DataSource = dt_brand;
|
dwBrand.DataTextField = "Name";
|
dwBrand.DataValueField = "Keyid";
|
dwBrand.DataBind();
|
dwBrand.Items.Insert(0, new ListItem("全部", ""));
|
}
|
else
|
{
|
dwBrand.Items.Clear();
|
dwBrand.Items.Insert(0, new ListItem("全部", ""));
|
}
|
DataTable dt_Specefiction = _OA_SpecificationBLL.getAllSpecification(CurrentUser.MemberId, this.dwCommity.SelectedValue, this.dwGoodsList.SelectedValue);
|
///规格
|
if (dt_Specefiction.Rows.Count > 0)
|
{
|
dwSpecification.DataSource = dt_Specefiction;
|
dwSpecification.DataTextField = "Name";
|
dwSpecification.DataValueField = "Keyid";
|
dwSpecification.DataBind();
|
dwSpecification.Items.Insert(0, new ListItem("全部", ""));
|
}
|
else
|
{
|
dwSpecification.Items.Clear();
|
dwSpecification.Items.Insert(0, new ListItem("全部", ""));
|
}
|
DataTable dt_PaperWeight = _OA_PaperWeightBLL.getPaperWeight(CurrentUser.MemberId, this.dwCommity.SelectedValue, this.dwGoodsList.SelectedValue);
|
///克重
|
if (dt_PaperWeight.Rows.Count > 0)
|
{
|
dwPaperWeight.DataSource = dt_PaperWeight;
|
dwPaperWeight.DataTextField = "Name";
|
dwPaperWeight.DataValueField = "Keyid";
|
dwPaperWeight.DataBind();
|
dwPaperWeight.Items.Insert(0, new ListItem("全部", ""));
|
}
|
|
|
}
|
|
protected void BindList()
|
{
|
Pagination pa = new Pagination();
|
pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
|
pa.PageSize = UCPager1.AspNetPager.PageSize;
|
List<OA_Inventory> OA_InventoryList = _OA_InventoryBLL.SelectModelList(pa, CurrentUser.MemberId, this.dwPaperWeight.SelectedValue, this.selWarehouseId.Value, this.dwSpecification.SelectedValue, this.dwBrand.SelectedValue, this.dwCommity.SelectedValue, this.dwGoodsList.SelectedValue, this.selOpretor.Value, this.txtRegTimeStart.Value.ToDateTime2(), this.txtRegTimeEnd.Value.ToDateTime2()).ToList();
|
List<OA_Inventory> NEW_OA_InventoryList = new List<OA_Inventory>();
|
foreach (var item in OA_InventoryList)
|
{
|
if (item.IsPaper == 1)
|
{
|
if (item.SpeceicationName.IndexOf("*") > 0)
|
{
|
int wNum = 0;
|
int hNum = 0;
|
try
|
{
|
wNum = item.SpeceicationName.Split('*')[0].ToInt32() ?? 0;
|
hNum = item.SpeceicationName.Split('*')[1].ToInt32() ?? 0;
|
}
|
catch (Exception ex)
|
{
|
PAGEHandleException(ex);
|
}
|
try
|
{
|
//item.TotalPrice = (item.UnitPrice * item.InventoryCount);
|
}
|
catch (Exception ex)
|
{
|
PAGEHandleException(ex);
|
}
|
try
|
{
|
item.LingShu = item.InventoryCount.ToDouble2() / 500.ToDouble2();
|
item.DunShu = item.InventoryCount.ToDouble2() * (wNum.ToDouble2() * hNum.ToDouble2() / (1000 * 1000).ToDouble2()) * (item.PaperWeightName.ToInt32().ToDouble2() / (1000 * 1000).ToDouble2());
|
}
|
catch (Exception ex)
|
{
|
PAGEHandleException(ex);
|
}
|
}
|
}
|
NEW_OA_InventoryList.Add(item);
|
}
|
ReInventoryList.DataSource = NEW_OA_InventoryList;
|
ReInventoryList.DataBind();
|
UCPager1.AspNetPager.RecordCount = pa.RecordCount;
|
|
this.AllMoney.InnerText = _OA_InventoryBLL.SelectModelListTotalPrice(pa, CurrentUser.MemberId, this.dwPaperWeight.SelectedValue, this.selWarehouseId.Value, this.dwSpecification.SelectedValue, this.dwBrand.SelectedValue, this.dwCommity.SelectedValue, this.dwGoodsList.SelectedValue, this.selOpretor.Value, this.txtRegTimeStart.Value.ToDateTime2(), this.txtRegTimeEnd.Value.ToDateTime2()).ToString("0.00") + "元";
|
}
|
|
protected void AspNetPager1_PageChanged(object src, EventArgs e)
|
{
|
BindList();
|
}
|
|
/// <summary>
|
/// 批量入库
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
protected void btn_Bulkstorage_Click(object sender, EventArgs e)
|
{
|
Response.Redirect("/Pages/procurement/StorageVolume.aspx");
|
}
|
|
/// <summary>
|
/// 查询
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
protected void btn_Register_Click(object sender, EventArgs e)
|
{
|
BindList();
|
}
|
}
|
}
|
