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));
}
