private void ExecuteDeptMonthReport()
{
#region 构造库房部门结存月结报表
CListItem[] deptArray = DictItemUtil.GetDictByDictType("部门");
ReportMonthlyHeaderInfo deptHeaderInfo = GetMainHeader();
deptHeaderInfo.ReportTitle = string.Format("{0}部门结存月报表", DateTime.Now.ToString("yyyy年MM月"));
deptHeaderInfo.ReportType = 1;
int headerID = BLLFactory <ReportMonthlyHeader> .Instance.InsertOrUpdate(deptHeaderInfo);
if (headerID > 0)
{
worker.ReportProgress(10);
int i = 1;
//先删除当月月结的数据，防止重复写入
BLLFactory <ReportMonthlyDetail> .Instance.DeleteByHeaderID(headerID);
//重新写入记录
foreach (CListItem deptItem in deptArray)
{
ReportMonthlyDetailInfo detailInfo = new ReportMonthlyDetailInfo();
detailInfo.Header_ID = headerID;
detailInfo.ReportYear = DateTime.Now.Year;
detailInfo.ReportMonth = DateTime.Now.Month;
detailInfo.YearMonth = DateTime.Now.ToString("yyyy年MM月");
detailInfo.ItemName = deptItem.Value;//项目名称为部门名称
detailInfo.CurrentCount = BLLFactory <ReportMonthlyDetail> .Instance.GetDeptCount(StatisticValueType.CurrentCount, deptItem.Value);
detailInfo.CurrentInCount = BLLFactory <ReportMonthlyDetail> .Instance.GetDeptCount(StatisticValueType.CurrentInCount, deptItem.Value);
detailInfo.CurrentInMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetDeptMoney(StatisticValueType.CurrentInMoney, deptItem.Value);
detailInfo.CurrentMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetDeptMoney(StatisticValueType.CurrentMoney, deptItem.Value);
detailInfo.CurrentOutCount = BLLFactory <ReportMonthlyDetail> .Instance.GetDeptCount(StatisticValueType.CurrentOutCount, deptItem.Value);
detailInfo.CurrentOutMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetDeptMoney(StatisticValueType.CurrentOutMoney, deptItem.Value);;
detailInfo.LastCount = BLLFactory <ReportMonthlyDetail> .Instance.GetDeptCount(StatisticValueType.LastCount, deptItem.Value);
detailInfo.LastMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetDeptMoney(StatisticValueType.LastMoney, deptItem.Value);;
BLLFactory <ReportMonthlyDetail> .Instance.Insert(detailInfo);
i++;
}
worker.ReportProgress(20);
}
#endregion
}
private void InitItemBigTypeInfo(TreeNode node)
{
CListItem[] dictList = DictItemUtil.GetDictByDictType("备件属类");
foreach (CListItem item in dictList)
{
string condition = string.Format(" where d.ItemBigType = '{0}' ", item.Value);
int count = BLLFactory <Stock> .Instance.GetCurrentStockReportCount(condition);
string displayText = string.Format("{0}({1})", item.Value, count);
TreeNode subNode = new TreeNode(displayText, 1, 1);
subNode.Tag = new CustomTreeData(CustomTreeType.ItemBigType, item.Value);
node.Nodes.Add(subNode);
}
}
private void ExecuteEachPartCostMonthlyReport()
{
#region 构造各车间成本月报表
CListItem[] deptArray = DictItemUtil.GetDictByDictType("部门");
CListItem[] itemTypeArray = DictItemUtil.GetDictByDictType("备件类别");
ReportMonthlyHeaderInfo deptCostHeaderInfo = GetMainHeader();
deptCostHeaderInfo.ReportTitle = string.Format("{0}各车间成本月报表", DateTime.Now.ToString("yyyy年MM月"));
deptCostHeaderInfo.ReportType = 4;
int headerID = BLLFactory <ReportMonthlyHeader> .Instance.InsertOrUpdate(deptCostHeaderInfo);
if (headerID > 0)
{
worker.ReportProgress(70);
int i = 1;
int j = 1;
//先删除当月月结的数据，防止重复写入
BLLFactory <ReportMonthlyCostDetail> .Instance.DeleteByHeaderID(headerID);
//重新写入记录
foreach (CListItem deptItem in deptArray)
{
foreach (CListItem itemType in itemTypeArray)
{
ReportMonthlyCostDetailInfo detailInfo = new ReportMonthlyCostDetailInfo();
detailInfo.Header_ID = headerID;
detailInfo.ReportYear = DateTime.Now.Year;
detailInfo.ReportMonth = DateTime.Now.Month;
detailInfo.YearMonth = DateTime.Now.ToString("yyyy年MM月");
detailInfo.DeptName = deptItem.Value;
detailInfo.ItemType = itemType.Value;
detailInfo.TotalMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetPartMonthlyCost(deptItem.Value, itemType.Value, DateTime.Now.Year, DateTime.Now.Month);
//detailInfo.ReportCode = "";//
BLLFactory <ReportMonthlyCostDetail> .Instance.Insert(detailInfo);
j++;
}
i++;
}
worker.ReportProgress(90);
}
#endregion
}
private void ShowGoodsTreeView()
{
this.treeGoods.Nodes.Clear();
this.treeGoods.BeginUpdate();
#region 项目类型信息明细类别
CListItem[] dict = DictItemUtil.GetDictByDictType("备件类别");
foreach (CListItem item in dict)
{
TreeNode typeNode = new TreeNode(item.Value, 0, 0);
typeNode.Tag = item.Value;
this.treeGoods.Nodes.Add(typeNode);
//typeNode.Tag = info;
}
#endregion
this.treeGoods.EndUpdate();
this.treeGoods.ExpandAll();
}
private void InitDictItem()
{
this.txtManufacture.Properties.Items.Clear();
this.txtManufacture.Properties.Items.AddRange(DictItemUtil.GetDictByDictType("供货商"));
this.txtBigType.Properties.Items.Clear();
this.txtBigType.Properties.Items.AddRange(DictItemUtil.GetDictByDictType("备件属类"));
this.txtItemType.Properties.Items.Clear();
this.txtItemType.Properties.Items.AddRange(DictItemUtil.GetDictByDictType("备件类别"));
this.txtSource.Properties.Items.Clear();
this.txtSource.Properties.Items.AddRange(DictItemUtil.GetDictByDictType("来源"));
//this.txtWareHouse.Properties.Items.Clear();
//this.txtWareHouse.Properties.Items.AddRange(BLLFactory<WareHouse>.Instance.GetAllWareHouse().ToArray());
this.txtDept.Properties.Items.Clear();
this.txtDept.Properties.Items.AddRange(DictItemUtil.GetDictByDictType("部门"));
}
private void ExecuteAnnualCostReport()
{
#region 构造全年费用汇总报表
CListItem[] itemTypeArray = DictItemUtil.GetDictByDictType("备件类别");
CListItem[] costCenterArray = DictItemUtil.GetDictByDictType("成本中心");
CListItem[] deptArray = DictItemUtil.GetDictByDictType("部门");
ReportAnnualCostHeaderInfo annualHeaderInfo = GetAnnualMainHeader();
annualHeaderInfo.ReportTitle = string.Format("{0}年费用汇总表", DateTime.Now.Year);
annualHeaderInfo.ReportType = 100;
int headerID = BLLFactory <ReportAnnualCostHeader> .Instance.InsertOrUpdate(annualHeaderInfo);
if (headerID > 0)
{
annualWorker.ReportProgress(10);
//先删除当年汇总的数据，防止重复写入
BLLFactory <ReportAnnualCostDetail> .Instance.DeleteByHeaderID(headerID);
annualWorker.ReportProgress(20);
#region 备件类型-成本中心汇总
//重新写入记录
int i = 1;
int j = 1;
foreach (CListItem itemTypeItem in itemTypeArray)
{
//合计项目
ReportAnnualCostDetailInfo totalInfo = new ReportAnnualCostDetailInfo();
totalInfo.Header_ID = headerID;
totalInfo.ReportYear = DateTime.Now.Year;
totalInfo.ItemType = itemTypeItem.Value;
totalInfo.CostCenterOrDept = string.Format("{0} 汇总", itemTypeItem.Value);
totalInfo.ReportCode = "001";
foreach (CListItem costCenterItem in costCenterArray)
{
#region 十二个月的记录
ReportAnnualCostDetailInfo detailInfo = new ReportAnnualCostDetailInfo();
detailInfo.Header_ID = headerID;
detailInfo.ReportYear = DateTime.Now.Year;
detailInfo.ItemType = itemTypeItem.Value;
detailInfo.CostCenterOrDept = costCenterItem.Value;
detailInfo.One = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 1);
detailInfo.Two = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 2);
detailInfo.Three = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 3);
detailInfo.Four = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 4);
detailInfo.Five = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 5);
detailInfo.Six = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 6);
detailInfo.Seven = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 7);
detailInfo.Eight = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 8);
detailInfo.Nine = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 9);
detailInfo.Ten = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 10);
detailInfo.Eleven = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 11);
detailInfo.Twelve = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeCostCenterSumMoney(itemTypeItem.Value, costCenterItem.Value, DateTime.Now.Year, 12);
detailInfo.Total = detailInfo.One + detailInfo.Two + detailInfo.Three + detailInfo.Four
+ detailInfo.Five + detailInfo.Six + detailInfo.Seven + detailInfo.Eight + detailInfo.Nine
+ detailInfo.Ten + detailInfo.Eleven + detailInfo.Twelve;
detailInfo.ReportCode = "001";
BLLFactory <ReportAnnualCostDetail> .Instance.Insert(detailInfo);
//合计项目的累积
totalInfo.One += detailInfo.One;
totalInfo.Two += detailInfo.Two;
totalInfo.Three += detailInfo.Three;
totalInfo.Four += detailInfo.Four;
totalInfo.Five += detailInfo.Five;
totalInfo.Six += detailInfo.Six;
totalInfo.Seven += detailInfo.Seven;
totalInfo.Eight += detailInfo.Eight;
totalInfo.Nine += detailInfo.Nine;
totalInfo.Ten += detailInfo.Ten;
totalInfo.Eleven += detailInfo.Eleven;
totalInfo.Twelve += detailInfo.Twelve;
totalInfo.Total += detailInfo.Total;
j++;
#endregion
}
BLLFactory <ReportAnnualCostDetail> .Instance.Insert(totalInfo);
i++;
}
annualWorker.ReportProgress(50);
#endregion
#region 备件类型-部门汇总
i = 1;
j = 1;
foreach (CListItem itemTypeItem in itemTypeArray)
{
//合计项目
ReportAnnualCostDetailInfo totalInfo = new ReportAnnualCostDetailInfo();
totalInfo.Header_ID = headerID;
totalInfo.ReportYear = DateTime.Now.Year;
totalInfo.ItemType = itemTypeItem.Value;
totalInfo.CostCenterOrDept = string.Format("{0} 汇总", itemTypeItem.Value);
totalInfo.ReportCode = "002";
foreach (CListItem deptItem in deptArray)
{
#region 十二个月纪录
ReportAnnualCostDetailInfo detailInfo = new ReportAnnualCostDetailInfo();
detailInfo.Header_ID = headerID;
detailInfo.ReportYear = DateTime.Now.Year;
detailInfo.ItemType = itemTypeItem.Value;
detailInfo.CostCenterOrDept = deptItem.Value;
detailInfo.One = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 1);
detailInfo.Two = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 2);
detailInfo.Three = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 3);
detailInfo.Four = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 4);
detailInfo.Five = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 5);
detailInfo.Six = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 6);
detailInfo.Seven = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 7);
detailInfo.Eight = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 8);
detailInfo.Nine = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 9);
detailInfo.Ten = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 10);
detailInfo.Eleven = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 11);
detailInfo.Twelve = BLLFactory <ReportAnnualCostDetail> .Instance.GetItemTypeDeptSumMoney(itemTypeItem.Value, deptItem.Value, DateTime.Now.Year, 12);
detailInfo.Total = detailInfo.One + detailInfo.Two + detailInfo.Three + detailInfo.Four
+ detailInfo.Five + detailInfo.Six + detailInfo.Seven + detailInfo.Eight + detailInfo.Nine
+ detailInfo.Ten + detailInfo.Eleven + detailInfo.Twelve;
detailInfo.ReportCode = "002";
BLLFactory <ReportAnnualCostDetail> .Instance.Insert(detailInfo);
//合计项目的累积
totalInfo.One += detailInfo.One;
totalInfo.Two += detailInfo.Two;
totalInfo.Three += detailInfo.Three;
totalInfo.Four += detailInfo.Four;
totalInfo.Five += detailInfo.Five;
totalInfo.Six += detailInfo.Six;
totalInfo.Seven += detailInfo.Seven;
totalInfo.Eight += detailInfo.Eight;
totalInfo.Nine += detailInfo.Nine;
totalInfo.Ten += detailInfo.Ten;
totalInfo.Eleven += detailInfo.Eleven;
totalInfo.Twelve += detailInfo.Twelve;
totalInfo.Total += detailInfo.Total;
j++;
#endregion
}
BLLFactory <ReportAnnualCostDetail> .Instance.Insert(totalInfo);
i++;
}
annualWorker.ReportProgress(80);
#endregion
#region 特殊部门分月汇总
i = 1;
j = 1;
//合计项目
ReportAnnualCostDetailInfo totalInfo2 = new ReportAnnualCostDetailInfo();
totalInfo2.Header_ID = headerID;
totalInfo2.ReportYear = DateTime.Now.Year;
totalInfo2.CostCenterOrDept = string.Format("{0} 汇总", "功能性承包");
totalInfo2.ReportCode = "003";
foreach (CListItem deptItem in deptArray)
{
#region 十二个月纪录
ReportAnnualCostDetailInfo detailInfo = new ReportAnnualCostDetailInfo();
detailInfo.Header_ID = headerID;
detailInfo.ReportYear = DateTime.Now.Year;
detailInfo.ItemType = "";
detailInfo.CostCenterOrDept = deptItem.Value;
detailInfo.One = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 1);
detailInfo.Two = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 2);
detailInfo.Three = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 3);
detailInfo.Four = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 4);
detailInfo.Five = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 5);
detailInfo.Six = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 6);
detailInfo.Seven = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 7);
detailInfo.Eight = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 8);
detailInfo.Nine = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 9);
detailInfo.Ten = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 10);
detailInfo.Eleven = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 11);
detailInfo.Twelve = BLLFactory <ReportAnnualCostDetail> .Instance.GetDeptSumMoney(deptItem.Value, DateTime.Now.Year, 12);
detailInfo.Total = detailInfo.One + detailInfo.Two + detailInfo.Three + detailInfo.Four
+ detailInfo.Five + detailInfo.Six + detailInfo.Seven + detailInfo.Eight + detailInfo.Nine
+ detailInfo.Ten + detailInfo.Eleven + detailInfo.Twelve;
detailInfo.ReportCode = "003";
BLLFactory <ReportAnnualCostDetail> .Instance.Insert(detailInfo);
//合计项目的累积
totalInfo2.One += detailInfo.One;
totalInfo2.Two += detailInfo.Two;
totalInfo2.Three += detailInfo.Three;
totalInfo2.Four += detailInfo.Four;
totalInfo2.Five += detailInfo.Five;
totalInfo2.Six += detailInfo.Six;
totalInfo2.Seven += detailInfo.Seven;
totalInfo2.Eight += detailInfo.Eight;
totalInfo2.Nine += detailInfo.Nine;
totalInfo2.Ten += detailInfo.Ten;
totalInfo2.Eleven += detailInfo.Eleven;
totalInfo2.Twelve += detailInfo.Twelve;
totalInfo2.Total += detailInfo.Total;
i++;
#endregion
}
BLLFactory <ReportAnnualCostDetail> .Instance.Insert(totalInfo2);
#endregion
}
#endregion
}
private void ExecuteAllWareItemTypeMonthlyReport()
{
#region 构造所有库房结存月结报表(含备件属类、备件类别分类）
CListItem[] itemBigTypeArray = DictItemUtil.GetDictByDictType("备件属类");
CListItem[] itemTypeArray = DictItemUtil.GetDictByDictType("备件类别");
ReportMonthlyHeaderInfo allWareHeaderInfo = GetMainHeader();
allWareHeaderInfo.ReportTitle = string.Format("{0}库房结存月报表", DateTime.Now.ToString("yyyy年MM月"));
allWareHeaderInfo.ReportType = 3;
int headerID = BLLFactory <ReportMonthlyHeader> .Instance.InsertOrUpdate(allWareHeaderInfo);
if (headerID > 0)
{
worker.ReportProgress(50);
int i = 1;
//先删除当月月结的数据，防止重复写入
BLLFactory <ReportMonthlyDetail> .Instance.DeleteByHeaderID(headerID);
//重新写入记录
foreach (CListItem bigItem in itemBigTypeArray)
{
ReportMonthlyDetailInfo detailInfo = new ReportMonthlyDetailInfo();
detailInfo.Header_ID = headerID;
detailInfo.ReportYear = DateTime.Now.Year;
detailInfo.ReportMonth = DateTime.Now.Month;
detailInfo.YearMonth = DateTime.Now.ToString("yyyy年MM月");
detailInfo.ItemName = bigItem.Value;//项目名称为部门名称
detailInfo.CurrentCount = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemBigTypeCount(StatisticValueType.CurrentCount, bigItem.Value);
detailInfo.CurrentInCount = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemBigTypeCount(StatisticValueType.CurrentInCount, bigItem.Value);
detailInfo.CurrentInMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemBigTypeMoney(StatisticValueType.CurrentInMoney, bigItem.Value);
detailInfo.CurrentMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemBigTypeMoney(StatisticValueType.CurrentMoney, bigItem.Value);
detailInfo.CurrentOutCount = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemBigTypeCount(StatisticValueType.CurrentOutCount, bigItem.Value);
detailInfo.CurrentOutMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemBigTypeMoney(StatisticValueType.CurrentOutMoney, bigItem.Value);;
detailInfo.LastCount = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemBigTypeCount(StatisticValueType.LastCount, bigItem.Value);
detailInfo.LastMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemBigTypeMoney(StatisticValueType.LastMoney, bigItem.Value);;
detailInfo.ReportCode = "ItemBigType";//备件属类数据用001表示
BLLFactory <ReportMonthlyDetail> .Instance.Insert(detailInfo);
i++;
}
i = 0;
foreach (CListItem itemType in itemTypeArray)
{
ReportMonthlyDetailInfo detailInfo = new ReportMonthlyDetailInfo();
detailInfo.Header_ID = headerID;
detailInfo.ReportYear = DateTime.Now.Year;
detailInfo.ReportMonth = DateTime.Now.Month;
detailInfo.YearMonth = DateTime.Now.ToString("yyyy年MM月");
detailInfo.ItemName = itemType.Value;//项目名称为部门名称
detailInfo.CurrentCount = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemTypeCount(StatisticValueType.CurrentCount, itemType.Value);
detailInfo.CurrentInCount = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemTypeCount(StatisticValueType.CurrentInCount, itemType.Value);
detailInfo.CurrentInMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemTypeMoney(StatisticValueType.CurrentInMoney, itemType.Value);
detailInfo.CurrentMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemTypeMoney(StatisticValueType.CurrentMoney, itemType.Value);
detailInfo.CurrentOutCount = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemTypeCount(StatisticValueType.CurrentOutCount, itemType.Value);
detailInfo.CurrentOutMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemTypeMoney(StatisticValueType.CurrentOutMoney, itemType.Value);;
detailInfo.LastCount = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemTypeCount(StatisticValueType.LastCount, itemType.Value);
detailInfo.LastMoney = BLLFactory <ReportMonthlyDetail> .Instance.GetWareItemTypeMoney(StatisticValueType.LastMoney, itemType.Value);;
detailInfo.ReportCode = "ItemType";//备件类别数据用002表示
BLLFactory <ReportMonthlyDetail> .Instance.Insert(detailInfo);
i++;
}
worker.ReportProgress(60);
}
#endregion
}
