/// <summary>
/// 更新一条数据
/// </summary>
public static bool Check(UserPayBankAppInfo model)
{
try
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@SureTime", SqlDbType.DateTime),
new SqlParameter("@SureUser", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = (int)model.status;
parameters[2].Value = model.SureTime;
parameters[3].Value = model.SureUser;
rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_userspaybankapp_Check", parameters);
if (rowsAffected > 0)
{
Factory.ClearCache(model.userid);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Check(usersIdImageInfo model)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
//new SqlParameter("@userId", SqlDbType.Int,4),
//new SqlParameter("@image_on", SqlDbType.Image,16),
//new SqlParameter("@image_down", SqlDbType.Image,16),
//new SqlParameter("@ptype", SqlDbType.NVarChar,20),
//new SqlParameter("@filesize", SqlDbType.Int,4),
//new SqlParameter("@ptype1", SqlDbType.NVarChar,20),
//new SqlParameter("@filesize1", SqlDbType.Int,4),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@why", SqlDbType.NVarChar, 150),
new SqlParameter("@admin", SqlDbType.Int, 4),
new SqlParameter("@checktime", SqlDbType.DateTime),
//new SqlParameter("@addtime", SqlDbType.DateTime)
};
parameters[0].Value = model.id;
//parameters[1].Value = model.userId;
//parameters[2].Value = model.image_on;
//parameters[3].Value = model.image_down;
//parameters[4].Value = model.ptype;
//parameters[5].Value = model.filesize;
//parameters[6].Value = model.ptype1;
//parameters[7].Value = model.filesize1;
parameters[1].Value = (int)model.status;
parameters[2].Value = model.why;
parameters[3].Value = model.admin;
parameters[4].Value = model.checktime;
bool success = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_usersIdImage_update", parameters) > 0;
if (success && model.status == IdImageStatus.审核成功)
{
Factory.ClearCache(model.userId.Value);
}
return(success);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(false);
}
}
