存储过程调用传参（传入传出）

最新推荐文章于 2024-04-30 05:11:44 发布

shadowSun88

最新推荐文章于 2024-04-30 05:11:44 发布

阅读量3.5k

点赞数

分类专栏： C# 文章标签：存储过程参数传入传出

本文链接：https://blog.csdn.net/colorseason/article/details/10183767

版权

C# 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

public void CalSubBalance(string strNetID, DateTime dtMeasDate, string man)
{
try
{
Database database = DatabaseFactory.CreateDatabase("MEFASIS_DB");
DbCommand storedProcCommand = database.GetStoredProcCommand("sp_erp_dailyelecbalance");
database.AddInParameter(storedProcCommand, "v_netid", DbType.String, strNetID);
database.AddInParameter(storedProcCommand, "v_date", DbType.DateTime, dtMeasDate);
database.AddInParameter(storedProcCommand, "v_man", DbType.String, man);
database.ExecuteNonQuery(storedProcCommand);
}
catch (Exception)
{
}

}

public DataSet GetPeriodData(DateTime vDate, string vman, int itype, string seltype)
{
Database database = DatabaseFactory.CreateDatabase("MEFASIS_DB");
DbCommand storedProcCommand = database.GetStoredProcCommand("pk_erp_perioddata.sp_erp_perioddata");
database.AddInParameter(storedProcCommand, "vdate", DbType.Date, vDate);
database.AddInParameter(storedProcCommand, "vtype", DbType.Int32, itype);
database.AddInParameter(storedProcCommand, "vseltype", DbType.String, seltype);
database.AddInParameter(storedProcCommand, "vman", DbType.String, vman);
OracleParameter parameter = new OracleParameter("cur_result", OracleType.Cursor);
parameter.Direction = ParameterDirection.Output;
storedProcCommand.Parameters.Add(parameter);
return database.ExecuteDataSet(storedProcCommand);
}