using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
using System.Web.UI;
|
using System.Web.UI.WebControls;
|
using CY.Model;
|
using CY.BLL.OA;
|
using CY.Infrastructure.Common;
|
using CY.Infrastructure.Query;
|
using CY.BLL.Sys;
|
using System.Data;
|
|
namespace CY.WebForm.Pages.financial
|
{
|
//吴辉
|
//采购付款
|
public partial class PurchasePayments : BasePage
|
{
|
Sys_DictionaryBLL _Sys_DictionaryBLL = null;
|
OA_SuppliersBLL _OA_SuppliersBLL = null;
|
OA_CommodityBLL _OA_CommodityBLL = null;
|
OA_GoodsInfoBLL _OA_GoodsInfoBLL = null;
|
OA_ProcurementBLL _OA_ProcurementBLL = null;
|
OA_Procurement Procuremet = null;
|
|
//初始化
|
public PurchasePayments()
|
{
|
Procuremet = new OA_Procurement();
|
_OA_CommodityBLL = new OA_CommodityBLL();
|
_Sys_DictionaryBLL = new Sys_DictionaryBLL();
|
_OA_SuppliersBLL = new OA_SuppliersBLL();
|
_OA_GoodsInfoBLL = new OA_GoodsInfoBLL();
|
_OA_ProcurementBLL = new OA_ProcurementBLL();
|
}
|
|
//页面加载
|
protected void Page_Load(object sender, EventArgs e)
|
{
|
|
UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
|
if (!IsPostBack)
|
{
|
}
|
|
if (!IsPostBack)
|
{
|
|
if (Request["Keyid"].ToInt32() > 0) //如果keyid>0 则删除对应对象
|
{
|
Procuremet = _OA_ProcurementBLL.SelectSingleModel(Request["Keyid"].ToString2());
|
if (_OA_ProcurementBLL.DeleteModel(Procuremet))
|
{
|
JavaScript.MessageBox("删除成功", this);
|
BindList();
|
}
|
else
|
{
|
JavaScript.MessageBox("删除失败", this);
|
BindList();
|
}
|
}
|
else
|
{
|
|
BindList();
|
InitialData();
|
}
|
}
|
|
}
|
|
//加载收入list数据
|
protected void BindList()
|
{
|
DateTime? beginTime = null;
|
DateTime? endTime = null;
|
Pagination pa = new Pagination();
|
pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
|
pa.PageSize = UCPager1.AspNetPager.PageSize;
|
ReProcurentList.DataSource = _OA_ProcurementBLL.getModelList(pa, CurrentUser.MemberId, "", this.selPurchaseStatus.Value, this.selClearingStatus.Value, this.selSuppliers.Value, this.selGoodsName.Value, this.dwCommity.SelectedValue, string.IsNullOrEmpty(this.txtRegTimeStart.Value) ? beginTime : Convert.ToDateTime(this.txtRegTimeStart.Value), string.IsNullOrEmpty(this.txtRegTimeEnd.Value) ? endTime : MyConvert.GetDateTime(this.txtRegTimeEnd.Value), this.txtBrandName.Value, this.txtPaperWeight.Value);
|
ReProcurentList.DataBind();
|
UCPager1.AspNetPager.RecordCount = pa.RecordCount;
|
|
OA_Procurement m_OA_Procurement = _OA_ProcurementBLL.SumMoney(pa, CurrentUser.MemberId, "", this.selPurchaseStatus.Value, this.selClearingStatus.Value, this.selSuppliers.Value, this.selGoodsName.Value, this.dwCommity.SelectedValue, string.IsNullOrEmpty(this.txtRegTimeStart.Value) ? beginTime : Convert.ToDateTime(this.txtRegTimeStart.Value), string.IsNullOrEmpty(this.txtRegTimeEnd.Value) ? endTime : MyConvert.GetDateTime(this.txtRegTimeEnd.Value), this.txtBrandName.Value, this.txtPaperWeight.Value);
|
if (m_OA_Procurement != null && m_OA_Procurement.AllMoney > 0)
|
{
|
this.AllMoney.InnerHtml = m_OA_Procurement.AllMoney.Value.ToString("0.00");
|
this.PayMoney.InnerHtml = m_OA_Procurement.ReceiveMoney.Value.ToString("0.00");
|
this.OweMoney.InnerHtml = (m_OA_Procurement.AllMoney - m_OA_Procurement.ReceiveMoney).Value.ToString("0.00");
|
}
|
}
|
|
//加载查询条件
|
protected void InitialData()
|
{
|
//采购状态
|
this.selPurchaseStatus.DataSource = _Sys_DictionaryBLL.GetDataByType("采购状态");
|
this.selPurchaseStatus.DataBind();
|
this.selPurchaseStatus.Items.Insert(0, new ListItem("全部", ""));
|
|
//结账状态
|
this.selClearingStatus.DataSource = _Sys_DictionaryBLL.GetDataByType("结账状态");
|
this.selClearingStatus.DataBind();
|
this.selClearingStatus.Items.Insert(0, new ListItem("全部", ""));
|
|
//供应商
|
this.selSuppliers.DataSource = _OA_SuppliersBLL.getSupplierTable(CurrentUser.MemberId);
|
this.selSuppliers.DataBind();
|
this.selSuppliers.Items.Insert(0, new ListItem("全部", ""));
|
|
//货品名称
|
this.selGoodsName.DataSource = _OA_GoodsInfoBLL.SelectTableList(CurrentUser.MemberId);
|
this.selGoodsName.DataBind();
|
this.selGoodsName.Items.Insert(0, new ListItem("全部", ""));
|
|
//产品类别
|
DataTable ds = _OA_CommodityBLL.SelectModelPage(CurrentUser.MemberId, "", "true");
|
GetDataByLevel(this.dwCommity, ds, 0, 0);
|
this.dwCommity.Items.Insert(0, new ListItem("全部", ""));
|
}
|
|
//产品类别
|
public static void GetDataByLevel(System.Web.UI.WebControls.DropDownList dwCommity, DataTable data, int parentId, int level)
|
{
|
|
if (data == null || data.Rows.Count == 0)
|
return;
|
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;
|
}
|
|
//分页事件
|
protected void AspNetPager1_PageChanged(object src, EventArgs e)
|
{
|
BindList();
|
}
|
|
//查询事件
|
protected void btn_Register_Click(object sender, EventArgs e)
|
{
|
BindList();
|
}
|
}
|
}
|
