static void Main(string[] args) { MyRead myWrite = new MyRead(Console.ReadLine); string str = myWrite(); Console.WriteLine(str); Console.ReadKey(); }
public MyRead GetMyRead(string UserID) { SqlParameter[] sp = new SqlParameter[5]; sp[0] = new SqlParameter("@UserID", SqlDbType.VarChar); sp[0].Value = UserID; sp[1] = new SqlParameter("@fPPT", SqlDbType.Int); sp[1].Direction = ParameterDirection.Output; sp[2] = new SqlParameter("@fSet", SqlDbType.Int); sp[2].Direction = ParameterDirection.Output; sp[3] = new SqlParameter("@fSetM", SqlDbType.Int); sp[3].Direction = ParameterDirection.Output; sp[4] = new SqlParameter("@fGameM", SqlDbType.Int); sp[4].Direction = ParameterDirection.Output; SqlDataReader sqldr = SqlHelper.ExecuteReader("myRead", CommandType.StoredProcedure, sp); try { MyRead myRead = new MyRead() { UserID = UserID, fPPT = int.Parse(sp[1].Value.ToString()), fSet = int.Parse(sp[2].Value.ToString()), fSetM = int.Parse(sp[3].Value.ToString()), fGameM = int.Parse(sp[4].Value.ToString()), }; return(myRead); } catch (Exception ex) { throw ex; } finally { sqldr.Close(); sqldr.Dispose(); } }