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