public int UpdateZcMain(cZcMain zcMain) { SqlParameter[] prams = { data.MakeInParam("@bh", SqlDbType.VarChar, 50, zcMain.BH), data.MakeInParam("@mc", SqlDbType.VarChar, 50, zcMain.MC), data.MakeInParam("@xh", SqlDbType.VarChar, 50, zcMain.XH), data.MakeInParam("@zclb", SqlDbType.VarChar, 50, zcMain.Zclb), data.MakeInParam("@xxpz", SqlDbType.VarChar, 200, zcMain.Xxpz), data.MakeInParam("@gjbh", SqlDbType.VarChar, 50, zcMain.Gjbh), data.MakeInParam("@sccj", SqlDbType.VarChar, 50, zcMain.Sccj), data.MakeInParam("@ccrq", SqlDbType.DateTime, 8, zcMain.Ccrq), data.MakeInParam("@zjfs", SqlDbType.VarChar, 50, zcMain.Zjfs), data.MakeInParam("@sybm", SqlDbType.VarChar, 50, zcMain.Sybm), data.MakeInParam("@syqk", SqlDbType.VarChar, 50, zcMain.Syqk), data.MakeInParam("@cfdd", SqlDbType.VarChar, 50, zcMain.Cfdd), data.MakeInParam("@bgry", SqlDbType.VarChar, 50, zcMain.Bgry), data.MakeInParam("@rzrq", SqlDbType.DateTime, 8, zcMain.Rzrq), data.MakeInParam("@sl", SqlDbType.Int, 4, zcMain.SL), data.MakeInParam("@dw", SqlDbType.VarChar, 20, zcMain.DW), data.MakeInParam("@dj", SqlDbType.Float, 8, zcMain.DJ), data.MakeInParam("@yz", SqlDbType.Float, 8, zcMain.YZ), data.MakeInParam("@ljzj", SqlDbType.Float, 8, zcMain.Ljzj), data.MakeInParam("@jz", SqlDbType.Float, 8, zcMain.JZ), data.MakeInParam("@jczl", SqlDbType.Float, 8, zcMain.Jczl), data.MakeInParam("@zjff", SqlDbType.VarChar, 20, zcMain.Zjff), data.MakeInParam("@nx", SqlDbType.Int, 4, zcMain.Nx), data.MakeInParam("@login", SqlDbType.DateTime, 20, zcMain.Login), data.MakeInParam("@loginer", SqlDbType.VarChar, 8, zcMain.Loginer), data.MakeInParam("@gxrq", SqlDbType.DateTime, 20, zcMain.Gxrq), data.MakeInParam("@tm", SqlDbType.VarChar, 20, zcMain.Tm), data.MakeInParam("xlh", SqlDbType.VarChar, 20, zcMain.Xlh), data.MakeInParam("Brand", SqlDbType.VarChar, 20, zcMain.Brand), }; return(data.RunProc("Update tb_zcMain Set mc=@mc,xh=@xh," + "zclb=@zclb,xxpz=@xxpz,gbbh=@gjbh,sccj=@sccj,ccrq=@ccrq,zjfs=@zjfs," + "sybm=@sybm,syqk=@syqk,cfdd=@cfdd,bgry=@bgry,rzrq=@rzrq,sl=@sl,dw=@dw," + "dj=@dj,zcyz=@yz,ljzj=@ljzj,zcjz=@jz,jczl=@jczl,zjff=@zjff," + "nx=@nx,djrq=@login,djr=@loginer,gxrq=@gxrq ,tm = @tm,xlh = @xlh,Brand = @brand" + " where bh=@bh", prams)); }
public int InsertZcMain(cZcMain zcMain) { SqlParameter[] prams = { data.MakeInParam("@bh", SqlDbType.VarChar, 50, zcMain.BH), data.MakeInParam("@mc", SqlDbType.VarChar, 50, zcMain.MC), data.MakeInParam("@xh", SqlDbType.VarChar, 50, zcMain.XH), data.MakeInParam("@zclb", SqlDbType.VarChar, 50, zcMain.Zclb), data.MakeInParam("@xxpz", SqlDbType.VarChar, 200, zcMain.Xxpz), data.MakeInParam("@gjbh", SqlDbType.VarChar, 50, zcMain.Gjbh), data.MakeInParam("@sccj", SqlDbType.VarChar, 50, zcMain.Sccj), data.MakeInParam("@ccrq", SqlDbType.DateTime, 8, zcMain.Ccrq), data.MakeInParam("@zjfs", SqlDbType.VarChar, 50, zcMain.Zjfs), data.MakeInParam("@sybm", SqlDbType.VarChar, 50, zcMain.Sybm), data.MakeInParam("@syqk", SqlDbType.VarChar, 50, zcMain.Syqk), data.MakeInParam("@cfdd", SqlDbType.VarChar, 50, zcMain.Cfdd), data.MakeInParam("@bgry", SqlDbType.VarChar, 50, zcMain.Bgry), data.MakeInParam("@rzrq", SqlDbType.DateTime, 8, zcMain.Rzrq), data.MakeInParam("@sl", SqlDbType.Int, 4, zcMain.SL), data.MakeInParam("@dw", SqlDbType.VarChar, 20, zcMain.DW), data.MakeInParam("@dj", SqlDbType.Float, 8, zcMain.DJ), data.MakeInParam("@yz", SqlDbType.Float, 8, zcMain.YZ), data.MakeInParam("@ljzj", SqlDbType.Float, 8, zcMain.Ljzj), data.MakeInParam("@jz", SqlDbType.Float, 8, zcMain.JZ), data.MakeInParam("@jczl", SqlDbType.Float, 8, zcMain.Jczl), data.MakeInParam("@zjff", SqlDbType.VarChar, 20, zcMain.Zjff), data.MakeInParam("@nx", SqlDbType.Int, 4, zcMain.Nx), data.MakeInParam("@login", SqlDbType.DateTime, 20, zcMain.Login), data.MakeInParam("@loginer", SqlDbType.VarChar, 8, zcMain.Loginer), data.MakeInParam("@gxrq", SqlDbType.DateTime, 20, zcMain.Gxrq), data.MakeInParam("@tm", SqlDbType.VarChar, 20, zcMain.Tm), data.MakeInParam("@xlh", SqlDbType.VarChar, 20, zcMain.Xlh), data.MakeInParam("@Brand", SqlDbType.VarChar, 20, zcMain.Brand), }; return(data.RunProc("INSERT INTO tb_zcMain (bh,mc,xh,zclb,xxpz,gbbh,sccj,ccrq," + "zjfs,sybm,syqk,cfdd,bgry,rzrq,sl,dw,dj,zcyz,ljzj,zcjz,jczl,zjff,nx,djrq,djr,gxrq,tm,xlh,Brand)" + "VALUES (@bh,@mc,@xh,@zclb,@xxpz,@gjbh,@sccj,@ccrq" + ",@zjfs,@sybm,@syqk,@cfdd,@bgry,@rzrq," + "@sl,@dw,@dj,@yz,@ljzj,@jz,@jczl,@zjff,@nx,@login,@loginer,@gxrq,@tm,@xlh,@Brand)", prams)); }
/// <summary> /// 清理固定资产(清理到tb_zcClear中) /// </summary> /// <param name="zcMain"></param> /// <returns></returns> public int ClearZcMain(cZcMain zcMain) { SqlParameter[] prams = { data.MakeInParam("@bh", SqlDbType.VarChar, 50, zcMain.BH), data.MakeInParam("@mc", SqlDbType.VarChar, 50, zcMain.MC), data.MakeInParam("@xh", SqlDbType.VarChar, 50, zcMain.XH), data.MakeInParam("@xxpz", SqlDbType.VarChar, 200, zcMain.Xxpz), data.MakeInParam("@syqk", SqlDbType.VarChar, 50, zcMain.Syqk), data.MakeInParam("@sybm", SqlDbType.VarChar, 50, zcMain.Sybm), data.MakeInParam("@bgry", SqlDbType.VarChar, 50, zcMain.Bgry), data.MakeInParam("@cfdd", SqlDbType.VarChar, 50, zcMain.Cfdd), data.MakeInParam("@qlr", SqlDbType.VarChar, 8, zcMain.Qlr), data.MakeInParam("@qlfs", SqlDbType.VarChar, 50, zcMain.Qlfs), data.MakeInParam("@qlrq", SqlDbType.DateTime, 8, zcMain.Qlrq), data.MakeInParam("@pzr", SqlDbType.VarChar, 20, zcMain.Pzr), data.MakeInParam("@memo", SqlDbType.VarChar, 255, zcMain.Memo), }; return(data.RunProc("INSERT INTO tb_zcClear (bh,mc,xh,xxpz,syqk,sybm,bgry,cfdd,qlr,qlfs,qlrq,pzr,memo)" + "VALUES (@bh,@mc,@xh,@xxpz,@syqk,@sybm,@bgry,@cfdd,@qlr,@qlfs,@qlrq,@pzr,@memo)", prams)); }