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