工序管理

杨乐

2022-02-07 25849768b45e51a2f5ac0bd4df7bb98b24da9cd7

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
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Model;
 
namespace DAL
{
    public  class ClsOA_EmpMinMessage:DBUtility.ClsXt_BaseBill
    {
        public Model.ClsOA_EmpMinMessage omodel = new Model.ClsOA_EmpMinMessage();
        
 
        public ClsOA_EmpMinMessage()
        {
            base.MvarItemKeySub = "";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey = "OA_EmpMinMessage";
            base.MvarReportTitle="个人微讯";
            base.BillType = "4528";
            base.HBillSubType = "4528";
 
        }
 
        #region 固定代码
 
        ~ClsOA_EmpMinMessage()
        {
            //DetailColl = null;
        }
       
        #endregion   自定义方法
        //修改单据
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //
                oCn.BeginTran();
                //更新主表
                oCn.RunProc("UpDate OA_EmpMinMessage set  " +               
                ",HDate='" + omodel.HDate.ToShortDateString() + "'" +               
                ",HSendMan='" + omodel.HSendMan + "'" +
                ",HReceiveMan='" + omodel.HReceiveMan + "'" +                      
                ",HDescription='" + omodel.HDescription + "'" +
                ",HBillType='" + omodel.HBillType + "'" +               
                ",HBillStatus='" + omodel.HBillStatus.ToString() +
                ",HReadFlag='" + Convert.ToString(omodel.HReadFlag ? 1 : 0) +
                ",HSystemFlag='" + Convert.ToString(omodel.HSystemFlag ? 1 : 0) +
                " where HItemID=" + lngBillKey.ToString());
   
                sReturn = "修改单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
        //新增单据
        public override bool AddBill(ref string sReturn)
        {
            try
            {
                //得到mainid
                //omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                //主表
                oCn.RunProc("Insert Into OA_EmpMinMessage   " +
                "(HDate,HSendMan,HReceiveMan,HDescription" +
                ",HBillType,HBillStatus,HReadFlag,HSystemFlag" +
             
                ") " +
                " values('" + omodel.HDate + "','" + omodel.HSendMan + "','" + omodel.HReceiveMan + "','" + omodel.HDescription + "'" +
                ",'" + omodel.HBillType + "'," + omodel.HBillStatus.ToString() + "," + Convert.ToString(omodel.HReadFlag ? 1 : 0) +","+ Convert.ToString(omodel.HSystemFlag ? 1 : 0) +
                ") ");            
       
                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
        //显示单据
        public override bool ShowBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //查询主表
                DataSet Ds;
                Ds = oCn.RunProcReturn("Select * from OA_EmpMinMessage Where HItemID=" + lngBillKey.ToString(), "OA_EmpMinMessage");
                if (Ds.Tables[0].Rows.Count == 0)
                {
                    sReturn = "单据未找到！";
                    return false;
                }
                //固定赋值===========================================
                omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]);
                omodel.HBillStatus = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBillStatus"]);
                omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]);
                omodel.HDescription = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HDescription"]);
                omodel.HSendMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSendMan"]);
                omodel.HReceiveMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HReceiveMan"]);
                omodel.HReadFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HReadFlag"]);
                omodel.HSystemFlag = DBUtility.ClsPub.isBool( Ds.Tables[0].Rows[0]["HSystemFlag"]);
         
          
                sReturn = "显示单据成功！";
            return true;
          }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }
 
    
 
 
 
        
    }
}