コード例 #1
0
 public Lbfgsxmt CreateLbfgsxmt(Lbfgsxmt info)
 {
     try
     {
         Management.BeginTransaction();
         Management.CreateLbfgsxmt(info);
         Management.Commit();
     }
     catch
     {
         Management.Rollback();
         throw;
     }
     return info;
 }
コード例 #2
0
        public Lbfgsxmt CreateLbfgsxmt(Lbfgsxmt info)
        {
            try
            {
                string sqlCommand = @"INSERT INTO ""LB_FGS_XMT"" (""XMTID"",""XMT"",""FGSID"",""FGS"",""XMTLX"",""WLLGLY"",""WLLGLYLXDH"",""KGRQ"",""JGRQ"",""JZMJ"",""ZHAOJIA"",""MGGRS"",""GJGGRS"",""TGGRS"",""NFGGRS"",""JZGGRS"",""QTGGRS"",""INSTANCEID"",""FAINSTANCEID"",""STATUS"",""CREATETIME"",""ISDELETE"",""FLOWID"",""DEPARTID"",""ORGANIZEID"",""DIYU"",""XMLX"",""ISUSE"") VALUES (:Xmtid,:Xmt,:Fgsid,:Fgs,:Xmtlx,:Wllgly,:Wllglylxdh,:Kgrq,:Jgrq,:Jzmj,:Zhaojia,:Mggrs,:Gjggrs,:Tggrs,:Nfggrs,:Jzggrs,:Qtggrs,:Instanceid,:Fainstanceid,:Status,:Createtime,:Isdelete,:Flowid,:Departid,:Organizeid,:Diyu,:Xmlx,:Isuse)";
                this.Database.AddInParameter(":Xmtid", info.Xmtid);//DBType:NUMBER
                this.Database.AddInParameter(":Xmt", info.Xmt);//DBType:VARCHAR2
                this.Database.AddInParameter(":Fgsid", info.Fgsid);//DBType:NUMBER
                this.Database.AddInParameter(":Fgs", info.Fgs);//DBType:VARCHAR2
                this.Database.AddInParameter(":Xmtlx", info.Xmtlx);//DBType:VARCHAR2
                this.Database.AddInParameter(":Wllgly", info.Wllgly);//DBType:VARCHAR2
                this.Database.AddInParameter(":Wllglylxdh", info.Wllglylxdh);//DBType:VARCHAR2
                this.Database.AddInParameter(":Kgrq", info.Kgrq);//DBType:DATE
                this.Database.AddInParameter(":Jgrq", info.Jgrq);//DBType:DATE
                this.Database.AddInParameter(":Jzmj", info.Jzmj);//DBType:NUMBER
                this.Database.AddInParameter(":Zhaojia", info.Zhaojia);//DBType:NUMBER
                this.Database.AddInParameter(":Mggrs", info.Mggrs);//DBType:NUMBER
                this.Database.AddInParameter(":Gjggrs", info.Gjggrs);//DBType:NUMBER
                this.Database.AddInParameter(":Tggrs", info.Tggrs);//DBType:NUMBER
                this.Database.AddInParameter(":Nfggrs", info.Nfggrs);//DBType:NUMBER
                this.Database.AddInParameter(":Jzggrs", info.Jzggrs);//DBType:NUMBER
                this.Database.AddInParameter(":Qtggrs", info.Qtggrs);//DBType:NUMBER
                this.Database.AddInParameter(":Instanceid", info.Instanceid);//DBType:NUMBER
                this.Database.AddInParameter(":Fainstanceid", info.Fainstanceid);//DBType:NUMBER
                this.Database.AddInParameter(":Status", info.Status);//DBType:NUMBER
                this.Database.AddInParameter(":Createtime", info.Createtime);//DBType:DATE
                this.Database.AddInParameter(":Isdelete", info.Isdelete);//DBType:NUMBER
                this.Database.AddInParameter(":Flowid", info.Flowid);//DBType:NUMBER
                this.Database.AddInParameter(":Departid", info.Departid);//DBType:NUMBER
                this.Database.AddInParameter(":Organizeid", info.Organizeid);//DBType:NUMBER
                this.Database.AddInParameter(":Diyu", info.Diyu);//DBType:VARCHAR2
                this.Database.AddInParameter(":Xmlx", info.Xmlx);//DBType:VARCHAR2
                this.Database.AddInParameter(":Isuse", info.Isuse);//DBType:NUMBER
                this.Database.ExecuteNonQuery(sqlCommand);

            }
            finally
            {
                this.Database.ClearParameter();
            }
            return info;
        }