📄 operation.cs
字号:
}
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 Equipment No
public DataSet GetDataSetBaseDefaultNO()
{
return data.RunProcReturn("select * from tb_BaseDefaultNO", "tb_BaseDefaultNO");
}
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));
}
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 assets management
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));
}
public int DeleteZcMain(string BH)
{
return data.RunProc("delete from tb_zcMain where bh='" + BH + "'");
}
public DataSet GetDataSetZC(string BH)
{
return data.RunProcReturn("select * from tb_zcMain where bh='" + BH + "'","tb_zcMain");
}
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 Main form--assets query
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 assets clean query
public DataSet GetDataSetzcClear()
{
return data.RunProcReturn("select bh as Equipment No,mc as Equipment Name,xh as Equipment Model, xxpz as Detail,syqk as State,sybm as Department,bgry as Custodian,cfdd as Place,qlr as Cleaner,qlfs as Clean methods,qlrq as Clean date,pzr as Approver,memo as Remark from tb_zcClear", "tb_zcClear");
}
public DataSet GetDataSetzcClear(string findType,string content)
{
return data.RunProcReturn("select bh as Equipment No,mc as Equipment Name,xh as Equipment Model, xxpz as Detail,syqk as State,sybm as Department,bgry as Custodian,cfdd as Place,qlr as Cleaner,qlfs as Clean methods,qlrq as Clean date,pzr as Approver,memo as Remark from tb_zcClear where " + findType + " like '%" + content + "%'", "tb_zcClear");
}
public int DeletezcClear(string BH)
{
return data.RunProc("delete from tb_zcClear where bh='" + BH + "'");
}
#endregion
#region amortization
public DataSet GetDataSetZcMainSum()
{
return data.RunProcReturn("select bh as Equipment No,mc as Equipment Name,xh as Equipment Model,zjff as Amortization Method ,rzrq as Posting Date, sl*dj as Assets Value, zcjz Equipment Actual Value,jczl as Net Residuals Rate,nx as Tenure Of Use,Convert(float(8),null) as Amortization This Month,null as Accumulated Amortization from tb_zcMain", "tab");
}
#endregion
#region Operator management
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);
}
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);
}
public int DeleteUser(string id)
{
return data.RunProc("delete from tb_user where id=" + id + "");
}
public DataSet GetDataSetUser()
{
return data.RunProcReturn("select ID as User ID,username as User Name,userpwd as User Password from tb_user", "tb_user");
}
public DataSet GetDataSetUser(string id)
{
return data.RunProcReturn("select * from tb_user where id='" + id + "'", "tb_user");
}
#endregion
#region system login
public DataSet LoginSystem(string userName,string pwd)
{
return data.RunProcReturn("select * from tb_user where userName='" + userName + "'and userpwd='" + pwd + "'","tb_user");
}
#endregion
#region Date Back up and recover--system set up
public void BackUp(string bakUpName,bool format)
{
if(format)
data.RunProc("BACKUP DATABASE db_EquipmentMS TO DISK ='" + bakUpName + "' with format");
else
data.RunProc("BACKUP DATABASE db_EquipmentMS TO DISK ='" + bakUpName + "' with noformat");
}
public void ReStore(string reStoreName,int bakFile)
{
data.RunProc("use master RESTORE DATABASE db_EquipmentMS from disk='" + reStoreName + "'WITH file = " + bakFile + "");
}
public DataSet GetBakUp(string strPath)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -