/// <summary> /// 暂停业务8010 8010|操作员编号|窗口号| /// </summary> /// <param name="pIn"></param> /// <param name="pOut"></param> public static void PauseBusi(cParamInfo pIn, out cParamInfo pOut) { pOut = new cParamInfo(); SqlConnection con = new SqlConnection(SessionInfo.strConn); SqlTransaction tran = null; try { con.Open(); tran = con.BeginTransaction(); SqlCommand cmd = new SqlCommand("spPauseBusi", con, tran); cmd.CommandType = CommandType.StoredProcedure; //@EmpNo varchar(20), --操作员 //@FormNo varchar(10), --登录窗口 //@ParamInfo varchar(256), //@OutInfo varchar(256) output, //@RetCode int output, //@RetText varchar(120) output cmd.Parameters.Add("@EmpNo", SqlDbType.VarChar, 20); cmd.Parameters["@EmpNo"].Value = pIn.strEmpNo; cmd.Parameters.Add("@FormNo", SqlDbType.VarChar, 10); cmd.Parameters["@FormNo"].Value = pIn.strFormNo; cmd.Parameters.Add("@ParamInfo", SqlDbType.VarChar, 256); cmd.Parameters["@ParamInfo"].Value = pIn.strParamInfo; cmd.Parameters.Add("@OutInfo", SqlDbType.VarChar, 256); cmd.Parameters["@OutInfo"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@RetCode", SqlDbType.Int); cmd.Parameters["@RetCode"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@RetText", SqlDbType.VarChar, 120); cmd.Parameters["@RetText"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); pOut.nRetCode = Convert.ToInt32(cmd.Parameters["@RetCode"].Value); pOut.strRetText = cmd.Parameters["@RetText"].Value.ToString(); if (pOut.nRetCode == 0) { tran.Commit(); } else { tran.Rollback(); } } catch (Exception se) { pOut.nRetCode = 99; pOut.strRetText = "系统忙,请稍后再试:" + se.Message; try { if (tran != null) { tran.Rollback(); } } catch {; } } finally { try { if (con != null) { con.Close(); } } catch {; } } }
/// <summary> /// 登录8001 操作员|密码|呼叫器地址| /// </summary> /// <param name="pIn"></param> /// <param name="pOut"></param> public static void Logon(cParamInfo pIn, out cParamInfo pOut) { pOut = new cParamInfo(); bool bRet = false; string strResult = ""; SqlConnection con = new SqlConnection(SessionInfo.strConn); SqlTransaction tran = null; try { con.Open(); tran = con.BeginTransaction(); SqlCommand cmd = new SqlCommand("spLogin", con, tran); cmd.CommandType = CommandType.StoredProcedure; // @EmpNo varchar(20), --操作员 // @CallerAddr varchar(32), --呼叫器地址 // @EmpPwd varchar(32), --密码 // @EmpName varchar(60) output, --姓名 // @EmpLevel varchar(20) output, --星级 // @LastLoginTime varchar(30) output, --上次登录时间 // @FormNo varchar(10) output, --登录窗口 // @FormName varchar(60) output, --窗口名称 // @TaxFlowID int output,--接口ID // @RetCode int output, // @RetText varchar(120) output cmd.Parameters.Add("@EmpNo", SqlDbType.VarChar, 20); cmd.Parameters["@EmpNo"].Value = pIn.strEmpNo; cmd.Parameters.Add("@CallerAddr", SqlDbType.VarChar, 32); cmd.Parameters["@CallerAddr"].Value = pIn.strCallerAddr; cmd.Parameters.Add("@EmpPwd", SqlDbType.VarChar, 32); cmd.Parameters["@EmpPwd"].Value = pIn.strEmpPwd; cmd.Parameters.Add("@EmpName", SqlDbType.VarChar, 60); cmd.Parameters["@EmpName"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@EmpLevel", SqlDbType.VarChar, 20); cmd.Parameters["@EmpLevel"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@LastLoginTime", SqlDbType.VarChar, 30); cmd.Parameters["@LastLoginTime"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@FormNo", SqlDbType.VarChar, 10); cmd.Parameters["@FormNo"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@FormName", SqlDbType.VarChar, 60); cmd.Parameters["@FormName"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@TaxFlowID", SqlDbType.Int); cmd.Parameters["@TaxFlowID"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@RetCode", SqlDbType.Int); cmd.Parameters["@RetCode"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@RetText", SqlDbType.VarChar, 120); cmd.Parameters["@RetText"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); pOut.nRetCode = Convert.ToInt32(cmd.Parameters["@RetCode"].Value); pOut.strRetText = cmd.Parameters["@RetText"].Value.ToString(); if (pOut.nRetCode == 0) { pOut.strEmpName = cmd.Parameters["@EmpName"].Value.ToString(); pOut.strEmpLevel = cmd.Parameters["@EmpLevel"].Value.ToString(); pOut.strFormNo = cmd.Parameters["@FormNo"].Value.ToString(); pOut.strFormName = cmd.Parameters["@FormName"].Value.ToString(); pOut.nTaxFlowID = Convert.ToInt32(cmd.Parameters["@TaxFlowID"].Value); } if (pOut.nRetCode == 0) { tran.Commit(); } else { tran.Rollback(); } if (pOut.nRetCode != 0) { return; } //开始处理远程接口 if (SessionInfo.nSystemType == 1) { int nBusiStatus = 0; bRet = FunTax.getJosonResult(pOut.nTaxFlowID, out nBusiStatus, out strResult); if (!bRet) { pOut.nRetCode = SessionInfo.CALL_ERR_CODE; pOut.strRetText = SessionInfo.CALL_ERR_MSG; } //解析jason字符串 } } catch (Exception se) { pOut.nRetCode = 99; pOut.strRetText = "系统忙,请稍后再试:" + se.Message; try { if (tran != null) { tran.Rollback(); } } catch {; } } finally { try { if (con != null) { con.Close(); } } catch {; } } }