利用sqlhelper.cs　的反回参数

最新推荐文章于 2018-07-25 17:10:33 发布

SimbaDan

最新推荐文章于 2018-07-25 17:10:33 发布

阅读量930

点赞数

文章标签： exception string access

本文链接：https://blog.csdn.net/SimbaDan/article/details/1507815

版权

public static void GetRoundInfobyChapterID_Round(
int chapterid,
int round,
out string proofreadername,
out string proofreaderalias,
out DateTime roundtime)
{

SqlParameter[] arParams = new SqlParameter[5];
arParams[0] = new SqlParameter("@chapterid", chapterid);
arParams[1] = new SqlParameter("@round",round);

arParams[2] = new SqlParameter("@proofreadername", SqlDbType.NVarChar,100);
arParams[2].Direction=ParameterDirection.Output;

arParams[3] = new SqlParameter("@proofreaderalias", SqlDbType.NVarChar,100);
arParams[3].Direction=ParameterDirection.Output;

arParams[4] = new SqlParameter("@roundtime", SqlDbType.DateTime,8);
arParams[4].Direction=ParameterDirection.Output;

try
{
SqlHelper.ExecuteNonQuery(_con,CommandType.StoredProcedure,
"GetRoundInfobyChapterID_Round",
arParams);
proofreadername=arParams[2].Value.ToString();
proofreaderalias=arParams[3].Value.ToString();
if (arParams[4].Value!=DBNull.Value)
roundtime=(DateTime)arParams[4].Value;
else
roundtime=new DateTime(2000,1,1);

}
catch (Exception ex)
{
throw new Exception("DB Access Error.",ex);
}
}