WEBS引用更新

yxj

2025-10-24 ae36a4639fff74935c27c8e7bb0ce6b39ad039a5

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
 
namespace WebAPI.DLL
{
    public class ClsGy_WorkPayTypeBill : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsGy_WorkPayType_Model omodel = new Model.ClsGy_WorkPayType_Model();
 
        public ClsGy_WorkPayTypeBill()
        {
            base.MvarItemKeySub = "";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey = "Gy_WorkPayType";
            base.MvarReportTitle = "工资类型";
            base.BillType = "";
            base.HBillSubType = "";
        }
 
        //新增单据
        public override bool AddBill(ref string sReturn)
        {
            try
            {
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                //主表
                oCn.RunProc("Insert Into Gy_WorkPayType   " +
                "(HNumber,HName,HHelpCode,HRemark,HStopflag,HUseFlag,HShortNumber,HParentID,HLevel,HEndFlag" +
                ") " +
                " values('" + omodel.HNumber + "','" + omodel.HName + "','" + 
                          omodel.HHelpCode + "','" + omodel.HRemark + "','" + Convert.ToString(omodel.HStopflag ? 1 : 0) + "','未使用','" +
                          omodel.HNumber + "',0,0,0" +
                ") ");
                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
 
        //修改单据
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //
                oCn.BeginTran();
                //更新主表
                oCn.RunProc("UpDate Gy_WorkPayType set  " +
                " HNumber='" + omodel.HNumber + "'" +  //固定赋值===============
                ",HName='" + omodel.HName + "'" +
                ",HHelpCode='" + omodel.HHelpCode + "'" +
                ",HRemark='" + omodel.HRemark + "'" +
                ",HStopflag='" + Convert.ToString(omodel.HStopflag ? 1 : 0) + "'" +
 
                " where HItemID=" + lngBillKey.ToString());
                sReturn = "修改单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
 
    }
}