public bool ModifyTable()
{
try
{
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
DebugErrorHelper.WriteErrorLog(ex.Message);
DebugErrorHelper.WriteErrorLog(ex.StackTrace);
return(false);
}
return(false);
}
public Dictionary <string, string> ModifyRelationTable()
{
Dictionary <string, string> dict = new Dictionary <string, string>();
try
{
cmd.ExecuteNonQuery();
dict.Add("isRemove", "1");
}
catch (Exception ex)
{
DebugErrorHelper.WriteErrorLog(ex.Message);
DebugErrorHelper.WriteErrorLog(ex.StackTrace);
dict.Add("isRemove", "0");
}
return(dict);
}
public DataTable GetDataTableBySP()
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
da.Fill(dt);
return(dt);
}
catch (Exception ex)
{
string error = ex.Message;
DebugErrorHelper.WriteErrorLog(error);
DebugErrorHelper.WriteErrorLog(ex.StackTrace);
}
return(null);
}
public DataTable GetDataTableWithParam()
{
DataTable dt = new DataTable();
SqlDataReader dr;
try
{
dr = cmd.ExecuteReader();
dt.Load(dr);
dr.Close();
return(dt);
}
catch (Exception ex)
{
string error = ex.Message;
DebugErrorHelper.WriteErrorLog(error);
DebugErrorHelper.WriteErrorLog(ex.StackTrace);
}
return(null);
}