/// <summary> /// 删除主题测试单元关联表 /// </summary> /// <param name="unitid">测试单元ID数组,如果传入NULL则删除全部关联</param> /// <param name="themeid">主题ID</param> /// <returns></returns> public static bool DelGuanLianUnit(string[] unitid, string themeid) { string sql = "delete from testunittheme where 1 = 1 "; if (themeid != null) { sql += "and themeid='" + themeid + "'"; } string unitstr = ""; if (unitid == null) { unitstr = "0"; } else { for (int i = 0; i < unitid.Length; i++) { unitstr = "'" + unitid[i] + "'," + unitstr; } unitstr = unitstr.Substring(0, unitstr.Length - 1); sql += " and unitid in (" + unitstr + ") "; } try { SqlDBUtil.ExecuteNonQuery(sql); return(true); } catch (Exception) { throw new Exception("删除id数据出现异常"); return(false); } }
public static bool DeleteTheme(string themeid) { string sql = "delete from testtheme where id='" + themeid + "' or parentid ='" + themeid + "'"; try { SqlDBUtil.ExecuteNonQuery(sql); return(true); } catch (Exception) { throw new Exception("删除出现异常"); return(false); } }
static public bool DelUICheckViewByNO(string checkno) { string sql = "delete from UICheckView where checkno='" + checkno + "'"; try { SqlDBUtil.ExecuteNonQuery(sql); return(true); } catch (Exception) { throw new Exception("删除出现异常"); return(false); } }
static public bool DelUICheckViewByImageno(string checkno, string imageno) { string sql = "delete from UICheckView where checkno='" + checkno + "' and imageno='" + imageno + "'"; try { SqlDBUtil.ExecuteNonQuery(sql); return(true); } catch (Exception e) { throw new Exception("删除出现异常" + e.ToString()); return(false); } }
static public bool UpdateState(string state, string checkedtime, string checkername, string checkerid, string id) { bool isSuccess = false; string sql = "update uicheckinfo set state='" + state + "',checkedtime='" + checkedtime + "',checkername='" + checkername + "',checkerid=" + checkerid + " where id=" + id; try { SqlDBUtil.ExecuteNonQuery(sql); isSuccess = true; } catch (Exception) { isSuccess = false; } return(isSuccess); }
static public bool UpdateState(string state, string id) { bool isSuccess = false; string sql = "update testunit set state='" + state + "' where id=" + id; try { SqlDBUtil.ExecuteNonQuery(sql); isSuccess = true; } catch (Exception) { isSuccess = false; } return(isSuccess); }
public static bool updateForPub(string id, string pubpath) { string time = System.DateTime.Now.ToLocalTime().ToString(); string sql = "update packageinfo set pubpath = '" + pubpath + "',publishtime ='" + time + "',state ='已发布' where id=" + id; try { int i = SqlDBUtil.ExecuteNonQuery(sql); if (i != 0) { return(true); } else { return(false); } } catch (Exception) { return(false); } }