核算方式

王 垚

2021-12-22 ab1bcadb9de70806a06fd51b32d6776f6bdeea2f

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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
 
namespace DAL
{
    //接口类  职员
    public class ClsIF_Employee_View : DBUtility.ClsGy_Base_View
    {
         //
        public List<Model.ClsGy_Employee_Model> oEmpList;
        public Model.ClsGy_Employee_Model omodel = new Model.ClsGy_Employee_Model();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        public ClsIF_Employee_View()
        {
            base.MvarReportTitle = "职员设置";
            base.MvarItemKey = "h_v_IF_Emp";
            base.SQLName = "Select HItemID,HNumber 职员代码,HName 职员 from h_v_IF_Emp where HStopflag=0   ";
            base.SQLOrder = " Order by HItemID  ";
            base.SQLList = "Select * from " + MvarItemKey + " ";
            //下拉SQL
            base.SQLNameForDown = " Select top 30 HItemID,HNumber 职员代码,HName 职员 from h_v_IF_Emp ";
            base.SQLOrderForDown = "  Order by HNumber ";
            base.SQLWhereForDown = "  where HStopflag=0  ";
        }
        //
        public void Dispose()
        {
            GC.SuppressFinalize(this);
        }
        //
         
        //返回项目信息
        public override bool GetInfoByID(Int64 sItemID)
        {
            DataSet DS ;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HItemID='" + sItemID + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count  == 0)
                    return false;
                else
                {
                    return GetInfo(DS);
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
        //根据代码返回项目信息
        public override bool GetInfoByNumber(string sNumber)
        {
            DataSet DS;
            try
            {
                DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HNumber='" + sNumber + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return GetInfo(DS);
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
 
 
        //返回职员根据班组oEmpList
        public bool GetInfoByGroup(long sGroupID)
        {
            oEmpList = new List<Model.ClsGy_Employee_Model>();
            oEmpList.Clear();
            try
            {
                DataSet DS;
                DS = oCn.RunProcReturn("Select * from h_v_IF_Emp Where HStopFlag=0 and HGroupID='" + sGroupID + "' order by HNumber", "Gy_Employee");
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
                    {
                        omodel = new Model.ClsGy_Employee_Model();
                        omodel.HItemID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[i]["HItemID"]);
                        omodel.HNumber = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HNumber"]);
                        omodel.HName = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HName"]);
                        omodel.HEmpRate = DBUtility.ClsPub.isDoule(DS.Tables[0].Rows[i]["HEmpRate"]);  //职员系数
                        omodel.HCTPrjID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[i]["HCTPrjID"]); //核算方案
                        omodel.HWorkTypeID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[i]["HWorkTypeID"]);   //工种
                        omodel.HEmpType = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[i]["HEmpType"]);   //工资类型
                        omodel.HPostID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[i]["HPostID"]);   //岗位
                        //
                        oEmpList.Add(omodel);
                    }
                    DS.Dispose();
                    DS = null;
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
 
        //返回项目信息
        public override bool GetInfo(DataSet DS)
        {
            try
            {
                omodel = new Model.ClsGy_Employee_Model();
                omodel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]);
                omodel.HNumber = DS.Tables[0].Rows[0]["HNumber"].ToString().Trim();
                omodel.HName = DS.Tables[0].Rows[0]["HName"].ToString().Trim();
                omodel.HShortNumber = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HShortNumber"]);
                omodel.HParentID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HParentID"]);
                omodel.HLevel = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HLevel"]);
                omodel.HEndFlag = DBUtility.ClsPub.isBool(DS.Tables[0].Rows[0]["HEndFlag"]);
                omodel.HStopflag = DBUtility.ClsPub.isBool(DS.Tables[0].Rows[0]["HStopflag"]);
                omodel.HBarCode = DS.Tables[0].Rows[0]["HBarCode"].ToString().Trim();
                omodel.HRemark = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
                omodel.HDeptID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HDeptID"]);
                omodel.HGroupID = DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HGroupID"]);
                omodel.HGroupName = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HGroupName"]);
                return true;
 
            }
            catch (Exception e)
            {
                throw (e);
            }
        }
      
    }
}