public Lbfgsxmt CreateLbfgsxmt(Lbfgsxmt info) { try { Management.BeginTransaction(); Management.CreateLbfgsxmt(info); Management.Commit(); } catch { Management.Rollback(); throw; } return info; }
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; }