public CommandResult RecoverAccountset(int AccountsetID)
{
CommandResult result = new CommandResult();
try
{
//调用存储过程，恢复临时表中的数据到实际表中
DataRow dr = DataProvider.LoadTable(
"usp_RecoverAccountset",
new SqlParameter("@accountsetid", AccountsetID),
new SqlParameter("@opuser", login.User.UserName)).Rows[0];
result.Result = Convert.ToBoolean(dr[0]);
result.Message = dr[1].ToString();
}
catch (Exception e)
{
result.Result = false;
result.Message = e.Message;
}
//if (result.Message.Contains("PK_"))
//{
// result.Message = "系统中已存在该文件的数据,无需恢复!";
//}
return(result);
}
int ValidateAccountsetDataIsDel(int AccountsetID)
{
try
{
return((int)DataProvider.LoadTable("usp_validateAccountSetDataIsDel", new SqlParameter("@accountsetid", AccountsetID)).Rows[0][0]);
}
catch { return(0); }
}
bool DelTempTableData(int accountSetID)
{
try
{
int resultID = (int)DataProvider.LoadTable("usp_DelTempTableData", new SqlParameter("@accountsetid", accountSetID)).Rows[0][0];
return(resultID == 0 ? false : true);
}
catch { }
return(false);
}
bool DelAccountSetData(int AccountSetID)
{
int result = 0;
try
{
DataTable dt = DataProvider.LoadTable("usp_DelAccountSetData", new SqlParameter("@accountsetid", AccountSetID));
result = Convert.ToInt32(dt.Rows[0][0]);
}
catch
{
return(false);
}
return(result == 0 ? false : true);
}
public CommandResult DelAccountSet(int AccountSetID)
{
CommandResult result = new CommandResult();
try
{
DataTable dt = DataProvider.LoadTable("usp_DelAccountSet", new SqlParameter("@AccountSetID", AccountSetID));
result.IntResult = Convert.ToInt32(dt.Rows[0][0]);
result.Message = dt.Rows[0][1].ToString();
}
catch (Exception e)
{
result.IntResult = 0;
result.Message = e.Message;
}
return(result);
}
