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