public static ResultInfoModel InvalidStandVerification(long id, UserLoginInfo loginUser)
{
var returnvalue = new ResultInfoModel()
{
IsSuccess = false
};
var upParam = new InvalidParam()
{
Id = id,
JobNum = loginUser.JobNum,
Name = loginUser.UserName,
InvalidTime = DateTime.Now
};
try
{
var result = _verificationDal.Invalid(upParam);
returnvalue.IsSuccess = result;
}
catch (Exception ex)
{
returnvalue.IsSuccess = false;
returnvalue.Message = ex.Message;
}
return(returnvalue);
}
public bool Invalid(InvalidParam param)
{
if (param.Id == 0)
{
return false;
}
var upsql = new StringBuilder();
var sqlparam = new List<SqlParameter>();
upsql.Append(string.Format("UPDATE {0} SET ", tableName));
upsql.Append(" [PVIsValid] = @PVIsValid ,");
upsql.Append(" [PVOperateUserNo] = @PVOperateUserNo ,");
upsql.Append(" [PVOperateUserName] = @PVOperateUserName ,");
upsql.Append(" [PVOperateTime] = @PVOperateTime ");
upsql.Append(" WHERE Id = @Id ");
var value = 0;
sqlparam.Add(new SqlParameter("@PVIsValid", value));
sqlparam.Add(new SqlParameter("@PVOperateUserNo", param.JobNum));
sqlparam.Add(new SqlParameter("@PVOperateUserName", param.Name));
sqlparam.Add(new SqlParameter("@PVOperateTime", param.InvalidTime));
sqlparam.Add(new SqlParameter("@Id", param.Id));
return ExecteNonQuery(CommandType.Text, upsql.ToString(), null, sqlparam) > 0;
}
