运行存贮过程<3>

调用示例

<1>调用createResult()

public int createJkd(OdbcConnection cn,OdbcTransaction tran)
  {

   int intRet;
   OdbcParameter[] parameters = {
            new OdbcParameter("id",OdbcType.Char,20),
            new OdbcParameter("bmid",OdbcType.Char,20),
            new OdbcParameter("bmmc",OdbcType.Char,40),
            new OdbcParameter("ygid",OdbcType.Char,10),
            new OdbcParameter("ygxm",OdbcType.Char,20),
            new OdbcParameter("jkrq",OdbcType.DateTime),
            new OdbcParameter("jkyy",OdbcType.VarChar,255),
            new OdbcParameter("sqje",OdbcType.Double),
            new OdbcParameter("pzje",OdbcType.Double),
            new OdbcParameter("lcid",OdbcType.Char,4),
            new OdbcParameter("zdrq",OdbcType.DateTime),
            new OdbcParameter("hxje",OdbcType.Double),
            new OdbcParameter("xgbz",OdbcType.VarChar,1),
            new OdbcParameter("pz",OdbcType.VarChar,1),
            new OdbcParameter("ztbh",OdbcType.VarChar,10),
            new OdbcParameter("bz",OdbcType.VarChar,255),
            new OdbcParameter("bgbh",OdbcType.VarChar,20),
            new OdbcParameter("zt",OdbcType.VarChar,255)
          };
   parameters[0].Value = id;
   parameters[1].Value = bmid;
   parameters[2].Value = bmmc;
   parameters[3].Value = ygid;
   parameters[4].Value = ygxm;
   parameters[5].Value = jkrq;
   parameters[6].Value = jkyy;
   parameters[7].Value = sqje;
   parameters[8].Value = pzje;
   parameters[9].Value = lcid;
   parameters[10].Value = zdrq;
   parameters[11].Value = hxje;
   parameters[12].Value = xgbz;
   parameters[13].Value = pz;
   parameters[14].Value = ztbh;
   parameters[15].Value = bz;
   parameters[16].Value = bgbh;
   parameters[17].Value = zt;
   
   intRet = this.createResult("{?=CALL spCreateJkd(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}",parameters,cn,tran);
   return intRet;
  }

 

附数据库中的过程

   CREATE PROCEDURE voucher01.spCreateJkd
@id char(20),
@bmid char(20),
@bmmc char(40),
@ygid char(10),
@ygxm char(20),
@jkrq datetime,
@jkyy varchar(255),
@sqje decimal(14,2),
@pzje decimal(14,2),
@lcid char(4),
@zdrq datetime,
@hxje decimal,
@xgbz varchar(1),
@pz varchar(1),
@ztbh varchar(10),
@bz varchar(255),
@bgbh varchar(20),
@zt varchar(255)
AS
    BEGIN
      insert into FY_JKD(ID,BMID,BMMC,YGID,YGXM,JKRQ,JKYY,SQJE,PZJE,LCID,ZDRQ,HXJE,XGBZ,PZ,ZTBH,BZ,BGBH,ZT,HSBM)
values(@id,@bmid,@bmmc,@ygid,@ygxm,@jkrq,@jkyy,@sqje,@pzje,@lcid,@zdrq,@hxje,@xgbz,@pz,@ztbh,@bz,@bgbh,@zt,@bmid)

      if @@ERROR>0
       return -1
     else
       return 0

    END

 

<2>

调用

 public DataSet getJkd(string strLx,string strYgid,string strLcid)
  {
            Djkd moudle = new Djkd();
   return moudle.GetJkd(strLx,strYgid,strLcid);
  }

附

   CREATE PROCEDURE voucher01.spGetJkd
@lx char(1),
@ygid char(10),
@lcid char(4)
AS
    BEGIN
      select FY_JKD.ID, FY_JKD.BMID, FY_JKD.BMMC, FY_JKD.YGID, FY_JKD.YGXM, FY_JKD.JKRQ, FY_JKD.JKYY, FY_JKD.SQJE, FY_JKD.PZJE, FY_JKD.LCID, FY_JKD.ZDRQ, FY_JKD.HXJE, FY_JKD.XGBZ, FY_JKD.PZ, FY_JKD.ZTBH, FY_JKD.BZ, FY_JKD.BGBH, FY_JKD.ZT, FY_JKD.SHJE01, FY_JKD.SHJE02, FY_JKD.SHJE03, FY_JKD.SHJE04, FY_JKD.SHJE05, FY_JKD.SHJE06, FY_JKD.SHJE07, FY_JKD.SHJE08, FY_JKD.SHJE09, FY_JKD.SHJE10, FY_JKD.PZH, FY_JKD.QXSH from FY_JKD where YGID = @ygid and XGBZ = @lx and LCID=@lcid order by ID

    END