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