📄 operation.cs
字号:
data.MakeInParam("@cfdd", SqlDbType.VarChar, 50, cfdd),
};
return (data.RunProc("INSERT INTO tb_BaseCfdd (cfdd) VALUES (@cfdd)", prams));
}
public int InsertBaseBgry(string bgry)
{
SqlParameter[] prams = {
data.MakeInParam("@bgry", SqlDbType.VarChar, 50, bgry),
};
return (data.RunProc("INSERT INTO tb_BaseBgry (bgry) VALUES (@bgry)", prams));
}
public int InsertBaseJldw(string jldw)
{
SqlParameter[] prams = {
data.MakeInParam("@jldw", SqlDbType.VarChar, 50, jldw),
};
return (data.RunProc("INSERT INTO tb_BaseJldw (jldw) VALUES (@jldw)", prams));
}
public int InsertBaseQlfs(string qlfs)
{
SqlParameter[] prams = {
data.MakeInParam("@qlfs", SqlDbType.VarChar, 50, qlfs),
};
return (data.RunProc("INSERT INTO tb_BaseQlfs (qlfs) VALUES (@qlfs)", prams));
}
#endregion
#region 固定资产编号设置
/// <summary>
/// 查询是否存在默认固定资产编号
/// </summary>
/// <returns></returns>
public DataSet GetDataSetBaseDefaultNO()
{
return data.RunProcReturn("select * from tb_BaseDefaultNO", "tb_BaseDefaultNO");
}
/// <summary>
/// 创建默认固定资产编号
/// </summary>
/// <param name="firstNO"></param>
/// <param name="defaultNo"></param>
/// <returns></returns>
public int InsertBaseDefaultNO(string firstNO, int defaultNo)
{
SqlParameter[] prams = {
data.MakeInParam("@firstNO", SqlDbType.VarChar, 50, firstNO),
data.MakeInParam("@defaultNO", SqlDbType.Int, 4, defaultNo),
};
return (data.RunProc("INSERT INTO tb_BaseDefaultNO (firstNO,defaultNO) VALUES (@firstNO,@defaultNO)", prams));
}
/// <summary>
/// 修改默认固定资产编号
/// </summary>
/// <param name="firstNO"></param>
/// <param name="defaultNo"></param>
/// <returns></returns>
public int UpdateBaseDefaultNO(string firstNO, int defaultNo)
{
SqlParameter[] prams = {
data.MakeInParam("@firstNO", SqlDbType.VarChar, 50, firstNO),
data.MakeInParam("@defaultNO", SqlDbType.Int, 4, defaultNo),
};
return (data.RunProc("Update tb_BaseDefaultNO Set firstNO=@firstNO,defaultNO=@defaultNO where id=1", prams));
}
#endregion
#region 固定资产管理
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),
};
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)" +
"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)", prams));
}
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),
};
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 where bh=@bh", prams));
}
/// <summary>
/// 删除固定资产
/// </summary>
/// <param name="BH"></param>
/// <returns></returns>
public int DeleteZcMain(string BH)
{
return data.RunProc("delete from tb_zcMain where bh='" + BH + "'");
}
/// <summary>
/// 获取指定的固定资产
/// </summary>
/// <param name="BH"></param>
/// <returns></returns>
public DataSet GetDataSetZC(string BH)
{
return data.RunProcReturn("select * from tb_zcMain where bh='" + BH + "'","tb_zcMain");
}
/// <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));
}
#endregion
#region 主窗体－－固定资产查询
public DataSet GetDataSetBaseZcMain_mc(string mc)
{
return data.RunProcReturn("select * from tb_zcMain where mc='" + mc + "'", "tb_BaseZcmc");
}
public DataSet GetDataSetBaseZcMain_zclb(string zclb)
{
return data.RunProcReturn("select * from tb_zcMain where zclb='" + zclb + "'", "tb_BaseZcmc");
}
public DataSet GetDataSetBaseZcMain_zjfs(string zjfs)
{
return data.RunProcReturn("select * from tb_zcMain where zjfs='" + zjfs + "'", "tb_BaseZcmc");
}
public DataSet GetDataSetBaseZcMain_sybm(string sybm)
{
return data.RunProcReturn("select * from tb_zcMain where sybm='" + sybm + "'", "tb_BaseZcmc");
}
public DataSet GetDataSetBaseZcMain_syqk(string syqk)
{
return data.RunProcReturn("select * from tb_zcMain where syqk='" + syqk + "'", "tb_BaseZcmc");
}
public DataSet GetDataSetBaseZcMain_cfdd(string cfdd)
{
return data.RunProcReturn("select * from tb_zcMain where cfdd='" + cfdd + "'", "tb_BaseZcmc");
}
public DataSet GetDataSetBaseZcMain_bgry(string bgry)
{
return data.RunProcReturn("select * from tb_zcMain where bgry='" + bgry + "'", "tb_BaseZcmc");
}
#endregion
#region 固定资产清理查询
/// <summary>
/// 获得所有固定资产
/// </summary>
/// <returns></returns>
public DataSet GetDataSetzcClear()
{
return data.RunProcReturn("select bh as 资产编号,mc as 资产名称,xh as 资产型号, xxpz as 详细配置,syqk as 使用情况,sybm as 使用部门,bgry as 保管人员,cfdd as 存放地点,qlr as 清理人,qlfs as 清理方式,qlrq as 清理日期,pzr as 批准人,memo as 备注 from tb_zcClear","tb_zcClear");
}
/// <summary>
/// 查询固定资产（清理）
/// </summary>
/// <param name="findType"></param>
/// <param name="content"></param>
/// <returns></returns>
public DataSet GetDataSetzcClear(string findType,string content)
{
return data.RunProcReturn("select bh as 资产编号,mc as 资产名称,xh as 资产型号, xxpz as 详细配置,syqk as 使用情况,sybm as 使用部门,bgry as 保管人员,cfdd as 存放地点,qlr as 清理人,qlfs as 清理方式,qlrq as 清理日期,pzr as 批准人,memo as 备注 from tb_zcClear where " + findType + " like '%" + content + "%'", "tb_zcClear");
}
/// <summary>
/// 根据编号删除删除固定资产
/// </summary>
/// <param name="BH"></param>
/// <returns></returns>
public int DeletezcClear(string BH)
{
return data.RunProc("delete from tb_zcClear where bh='" + BH + "'");
}
#endregion
#region 资产折旧
/// <summary>
/// 获得资产部分信息
/// </summary>
/// <returns></returns>
public DataSet GetDataSetZcMainSum()
{
return data.RunProcReturn("select bh as 资产编号,mc as 资产名称,xh as 资产型号,zjff as 折旧方法,rzrq as 入账日期, sl*dj as 资产原值, zcjz 资产净值,jczl as 净残值率,nx as 使用年限,Convert(float(8),null) as 本月折旧,null as 累计折旧 from tb_zcMain", "tab");
}
#endregion
#region 操作员管理
/// <summary>
/// 添加管理员
/// </summary>
/// <param name="userName"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public int InsertUser(string userName,string pwd)
{
SqlParameter[] prams = {
data.MakeInParam("@userName",SqlDbType.VarChar,50,userName),
data.MakeInParam("@userPwd",SqlDbType.VarChar,50,pwd),
};
return data.RunProc("insert into tb_User (username,userpwd) values(@userName,@userPwd)", prams);
}
/// <summary>
/// 修改管理员
/// </summary>
/// <param name="id"></param>
/// <param name="userName"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public int UpdateUser(string id,string userName, string pwd)
{
SqlParameter[] prams = {
data.MakeInParam("@userName",SqlDbType.VarChar,50,userName),
data.MakeInParam("@userPwd",SqlDbType.VarChar,50,pwd),
};
return data.RunProc("update tb_User set userName=@userName,userPwd=@userPwd where id=" + id + "", prams);
}
/// <summary>
/// 删除管理员
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteUser(string id)
{
return data.RunProc("delete from tb_user where id=" + id + "");
}
/// <summary>
/// 获得所有管理员信息
/// </summary>
/// <returns></returns>
public DataSet GetDataSetUser()
{
return data.RunProcReturn("select ID as 用户ID,username as 用户名称,userpwd as 用户密码 from tb_user", "tb_user");
}
/// <summary>
/// 根据指定的ＩＤ获得管理员信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataSet GetDataSetUser(string id)
{
return data.RunProcReturn("select * from tb_user where id='" + id + "'", "tb_user");
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -