From dfcab5f73b1f07e63ca9483d457bcfddccc95bf3 Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期四, 10 十月 2024 14:27:44 +0800
Subject: [PATCH] 班组列表返回数据调用方法修改，增加根据用户过滤显示班组；PDA模块所调用的班组返回数据方法新增
---
DAL/采购管理/ClsCg_POInStockBackBill.cs | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
diff --git "a/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POInStockBackBill.cs" "b/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POInStockBackBill.cs"
index ce36020..53867dd 100644
--- "a/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POInStockBackBill.cs"
+++ "b/DAL/\351\207\207\350\264\255\347\256\241\347\220\206/ClsCg_POInStockBackBill.cs"
@@ -12,11 +12,11 @@
public ClsCg_POInStockBackBill()
{
- base.MvarItemKeySub = "Cg_POInStockBillSub";
+ base.MvarItemKeySub = "Cg_POInStockBackBillSub";
base.MvarItemKeySub2 = "";
base.MvarItemKeySub3 = "";
base.MvarItemKeySub4 = "";
- base.MvarItemKey="Cg_POInStockBillMain";
+ base.MvarItemKey= "Cg_POInStockBackBillMain";
base.MvarReportTitle="閫�鏂欓�氱煡鍗�";
base.BillType="1105";
base.HBillSubType = "1105";
@@ -91,7 +91,7 @@
//
oCn.BeginTran();
//鏇存柊涓昏〃
- oCn.RunProc("UpDate Cg_POInStockBillMain set " +
+ oCn.RunProc("UpDate Cg_POInStockBackBillMain set " +
" HBillNo='" + omodel.HBillNo + "'" + //鍥哄畾璧嬪��===============
",HDate='" + omodel.HDate + "'" +
",HYear='" + omodel.HYear.ToString() + "'" +
@@ -119,7 +119,7 @@
omodel.HInterID = lngBillKey;
foreach (Model.ClsCg_POInStockBackBillSub oSub in DetailColl)
{
- oCn.RunProc("Insert into Cg_POInStockBillSub " +
+ oCn.RunProc("Insert into Cg_POInStockBackBillSub " +
" (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
",HMaterID,HUnitID,HQty,HPrice,HMoney,HTaxPrice,HTaxMoney,HWHID" +
@@ -166,7 +166,7 @@
//
oCn.BeginTran();
//涓昏〃
- oCn.RunProc("Insert Into Cg_POInStockBillMain " +
+ oCn.RunProc("Insert Into Cg_POInStockBackBillMain " +
"(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" +
",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
",HAddress,HSupID,HCurID,HWHID,HExRate" +
@@ -180,7 +180,7 @@
//鎻掑叆瀛愯〃
foreach (Model.ClsCg_POInStockBackBillSub oSub in DetailColl)
{
- oCn.RunProc("Insert into Cg_POInStockBillSub " +
+ oCn.RunProc("Insert into Cg_POInStockBackBillSub " +
" (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
",HMaterID,HUnitID,HQty,HPrice,HMoney,HTaxPrice,HTaxMoney,HWHID" +
@@ -215,7 +215,7 @@
{
//鏌ヨ涓昏〃
DataSet Ds ;
- Ds = oCn.RunProcReturn("Select * from Cg_POInStockBillMain Where HInterID=" + lngBillKey.ToString(), "Cg_POInStockBillMain");
+ Ds = oCn.RunProcReturn("Select * from Cg_POInStockBackBillMain Where HInterID=" + lngBillKey.ToString(), "Cg_POInStockBackBillMain");
if(Ds.Tables[0].Rows.Count==0)
{
sReturn = "鍗曟嵁鏈壘鍒帮紒";
@@ -263,7 +263,7 @@
//寰幆
DataSet DsSub ;
- DsSub = oCn.RunProcReturn("Select * from Cg_POInStockBillSub Where HInterID=" + lngBillKey.ToString(), "Cg_POInStockBillSub");
+ DsSub = oCn.RunProcReturn("Select * from Cg_POInStockBackBillSub Where HInterID=" + lngBillKey.ToString(), "Cg_POInStockBackBillSub");
DetailColl.Clear();//娓呯┖
for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
{
--
Gitblit v1.9.1