public override void SetServiceStream(string path, string BILL_CODE, string userID, string userCompany, string userDepart, string userDate, string serverPK, int operation, out string NewServerPK, DB_OPT dbo)
{
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("path", OracleType.VarChar, 100), new OracleParameter("BILL_CODE", OracleType.VarChar, 100), new OracleParameter("userID", OracleType.VarChar, 100), new OracleParameter("userCompany", OracleType.VarChar, 100), new OracleParameter("userDepart", OracleType.VarChar, 100), new OracleParameter("userDate", OracleType.DateTime), new OracleParameter("serverPK", OracleType.VarChar, 0xff), new OracleParameter("operation", OracleType.Int32, 4), new OracleParameter("NewServerPK", OracleType.VarChar, 100), new OracleParameter("XserverPK", OracleType.VarChar, 100) };
parameters[0].Value = path;
parameters[1].Value = BILL_CODE;
parameters[2].Value = userID;
parameters[3].Value = userCompany;
parameters[4].Value = userDepart;
parameters[5].Value = userDate;
parameters[6].Value = serverPK;
parameters[7].Value = operation;
parameters[8].Direction = ParameterDirection.Output;
parameters[9].Direction = ParameterDirection.Output;
dbo.SqlProcPar("gov_tc_proc_serviceStream", parameters);
NewServerPK = parameters[8].Value.ToString();
}
public override void GetServiceStream(string path, string userID, string MainServerPK, out string ShowButtonID, out string ButtonShowTxt, out string BoHui_ZhuiHui, out string IsSava_objID, DB_OPT dbo)
{
ButtonShowTxt = "";
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("path", OracleType.VarChar, 100), new OracleParameter("userID", OracleType.VarChar, 100), new OracleParameter("MainServerPK", OracleType.VarChar, 100), new OracleParameter("ShowButtonID", OracleType.VarChar, 100), new OracleParameter("BoHui_ZhuiHui", OracleType.VarChar, 100), new OracleParameter("XserverPK", OracleType.VarChar, 0xff), new OracleParameter("IsSava_objID", OracleType.VarChar, 0xff) };
parameters[0].Value = path;
parameters[1].Value = userID;
parameters[2].Value = MainServerPK;
parameters[3].Direction = ParameterDirection.Output;
parameters[4].Direction = ParameterDirection.Output;
parameters[5].Direction = ParameterDirection.Output;
parameters[6].Direction = ParameterDirection.Output;
dbo.SqlProcPar("pd_tc_Proc_StreamIsShowButton", parameters);
ShowButtonID = parameters[3].Value.ToString();
BoHui_ZhuiHui = parameters[4].Value.ToString();
ButtonShowTxt = parameters[5].Value.ToString();
IsSava_objID = parameters[6].Value.ToString();
}
public override void GetUpDownStream(string path, string serverPK, int operation, out string NewServerPK, DB_OPT dbo)
{
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("path", OracleType.VarChar, 100), new OracleParameter("serverPK", OracleType.VarChar, 100), new OracleParameter("ad_Index", OracleType.Int32, 4), new OracleParameter("NewServerPK", OracleType.VarChar, 100), new OracleParameter("BH_Show", OracleType.Int32, 4) };
parameters[0].Value = path;
parameters[1].Value = serverPK;
parameters[2].Value = operation;
parameters[3].Direction = ParameterDirection.Output;
parameters[4].Direction = ParameterDirection.Output;
dbo.SqlProcPar("GetserviceStream", parameters);
NewServerPK = parameters[3].Value.ToString();
}
public override void GetServiceCode(string objID, string path, string userID, out int IsShow, out string showtxt, DB_OPT dbo)
{
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("objID", OracleType.VarChar, 100), new OracleParameter("path", OracleType.VarChar, 100), new OracleParameter("userID", OracleType.VarChar, 100), new OracleParameter("OutpowerCode", OracleType.Int32, 4), new OracleParameter("showtxt", OracleType.VarChar, 100) };
parameters[0].Value = objID;
parameters[1].Value = path;
parameters[2].Value = userID;
parameters[3].Direction = ParameterDirection.Output;
parameters[4].Direction = ParameterDirection.Output;
dbo.SqlProcPar("pd_tc_Proc_IsShowButtonList", parameters);
IsShow = int.Parse(parameters[3].Value.ToString());
showtxt = parameters[4].Value.ToString();
}