public static ResultEN Delete(string C_ID) { ResultEN res = new ResultEN(); string sql = "DELETE From Customer Where C_ID='" + C_ID + "'"; res.result = ClassMain.ExecuteQuery(sql); return(res); }
public static ResultEN Delete(int id) { ResultEN res = new ResultEN(); string sql = "DELETE From Employees Where id=" + id; res.result = ClassMain.ExecuteQuery(sql); return(res); }
public static ResultEN Delete_Equipment_SET_detail(int?[] SET_ID) { ResultEN res = new ResultEN(); string condition = ""; if (SET_ID != null) { if (condition == "") { condition = condition + "WHERE\n "; } else { condition = condition + " AND "; } condition = condition + "SET_ID in ("; string str_id = ""; foreach (var id in SET_ID) { if (!string.IsNullOrEmpty(str_id)) { str_id += ","; } str_id = str_id + id; } condition = condition + " " + str_id + " ) \n"; } string sql = "DELETE From Equipment_SET_detail " + condition; res.result = ClassMain.ExecuteQuery(sql); return(res); }