/// <summary>
/// 用设备信息更新设备
/// </summary>
/// <param name="sb">SBXXB</param>
/// <returns>bool</returns>
public bool Update_sb(SBXXB sb)
{
string sql = "update sbxxb set sblx=@sblx,sbmc=@sbmc,sccj=@sccj,syzt=@syzt,sbms=@sbms,xhtd=@xhtd,gdtd=@gdtd,cktd=@cktd where sbbh=@sbbh";
SqlParameter[] spr =
{
new SqlParameter("@sbbh", sb.SBBH),
new SqlParameter("@sblx", sb.SBLX),
new SqlParameter("@sbmc", sb.SBMC),
new SqlParameter("@sccj", sb.SCCJ),
new SqlParameter("@syzt", sb.SYZT),
new SqlParameter("@xhtd", sb.XHTD),
new SqlParameter("@gdtd", sb.GDTD),
new SqlParameter("@cktd", sb.CKTD),
new SqlParameter("@sbms", sb.SBMS)
};
try
{
if (DBHelperSQL.Execute(sql, spr) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用设备信息保存设备
/// </summary>
/// <param name="sb">SBXXB</param>
/// <returns>bool</returns>
public bool Save_sb(SBXXB sb)
{
string sql = "insert into sbxxb values(@sblx,@sbmc,@sccj,@syzt,@xhtd,@gdtd,@cktd,@sbms)";
SqlParameter[] spr =
{
new SqlParameter("@sblx", sb.SBLX),
new SqlParameter("@sbmc", sb.SBMC),
new SqlParameter("@sccj", sb.SCCJ),
new SqlParameter("@syzt", sb.SYZT),
new SqlParameter("@xhtd", sb.XHTD),
new SqlParameter("@gdtd", sb.GDTD),
new SqlParameter("@cktd", sb.CKTD),
new SqlParameter("@sbms", sb.SBMS)
};
try
{
if (DBHelperSQL.Execute(sql, spr) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public void Init_SB()
{
fqfxy = sbxx.Get_sb_by_bh(mainPanelForm.jcxxxb.FQFXYBH);
if (fqfxy.SBBH == 0)
{
toolStripMenuItemFqy.Enabled = false;
}
btgydj = sbxx.Get_sb_by_bh(mainPanelForm.jcxxxb.BTGYDJBH);
if (btgydj.SBBH == 0)
{
ToolStripMenuItemYdj.Enabled = false;
}
llj = sbxx.Get_sb_by_bh(mainPanelForm.jcxxxb.LLJBH);
if (llj.SBBH == 0)
{
toolStripMenuItemLlj.Enabled = false;
}
}
