{
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);
}