//处理未评价信息
public static void ModifyAppraise()
{
SqlConnection con = null;
try
{
con = new SqlConnection(SessionInfo.strConn);
con.Open();
SqlCommand cmd = new SqlCommand("spAppriseNull", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
catch (Exception se)
{
FConst.WriteErrLog("ModifyAppraise:" + se.Message);
//try
//{
// if (con != null)
// con.Close();
//}
//catch { ;}
//con = null;
}
finally
{
try
{
if (con != null)
{
con.Close();
}
}
catch {; }
}
}
//private static SqlConnection con = null;
//public static void Connect()
//{
// con = new SqlConnection(SessionInfo.strConn);
// con.Open();
//}
public static void GetSendInfo(out int nTaxFlowID, out string strTrCode, out string strParams)
{
nTaxFlowID = 0;
strTrCode = "";
strParams = "";
SqlConnection con = null;
try
{
con = new SqlConnection(SessionInfo.strConn);
con.Open();
SqlCommand cmd = new SqlCommand("spTaxGetInfo", con);
cmd.CommandType = CommandType.StoredProcedure;
//@TaxFlowID int output,
//@TrCode varchar(4) output,
//@ParamsIn varchar(128) output
cmd.Parameters.Add("@TaxFlowID", SqlDbType.Int);
cmd.Parameters["@TaxFlowID"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@TrCode", SqlDbType.VarChar, 4);
cmd.Parameters["@TrCode"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ParamsIn", SqlDbType.VarChar, 512);
cmd.Parameters["@ParamsIn"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
nTaxFlowID = Convert.ToInt32(cmd.Parameters["@TaxFlowID"].Value);
strTrCode = cmd.Parameters["@TrCode"].Value.ToString();
strParams = cmd.Parameters["@ParamsIn"].Value.ToString();
}
catch (Exception se)
{
FConst.WriteErrLog("GetSendInfo:" + se.Message);
//try
//{
// if (con != null)
// con.Close();
//}
//catch { ;}
//con = null;
}
finally
{
try
{
if (con != null)
{
con.Close();
}
}
catch {; }
}
}
private void updateStatus()
{
SqlConnection con = null;
try
{
//@Id int,
//@Status int,
//@RecvInfo varchar(1024),
//@RetCode int output,
//@RetText varchar(120) output
con = new SqlConnection(SessionInfo.strConn);
con.Open();
SqlCommand cmd = new SqlCommand("procAuthRemoteUpdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int);
cmd.Parameters["@Id"].Value = id;
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Value = status;
cmd.Parameters.Add("@RecvInfo", SqlDbType.VarChar, 1024);
cmd.Parameters["@RecvInfo"].Value = recvinfo;
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();
RetCode = Convert.ToInt32(cmd.Parameters["@RetCode"].Value);
RetText = cmd.Parameters["@RetText"].Value.ToString();
}
catch (Exception se)
{
FConst.WriteErrLog("updateStatus:" + se.Message);
}
finally
{
try
{
if (con != null)
{
con.Close();
}
}
catch {; }
}
}
public static void WriteRcvInfo(int nTaxFlowID, string strParamsOut, int nBusiStatus, string strBusiParams)
{
SqlConnection con = null;
try
{
con = new SqlConnection(SessionInfo.strConn);
con.Open();
SqlCommand cmd = new SqlCommand("spTaxSetInfo", con);
cmd.CommandType = CommandType.StoredProcedure;
//@TaxFlowID int ,
//@ParamsOut varchar(2048),
//@BusiStatus int,
//@BusiParams varchar(2048)
cmd.Parameters.Add("@TaxFlowID", SqlDbType.Int);
cmd.Parameters["@TaxFlowID"].Value = nTaxFlowID;
cmd.Parameters.Add("@ParamsOut", SqlDbType.VarChar, 2048);
cmd.Parameters["@ParamsOut"].Value = strParamsOut;
cmd.Parameters.Add("@BusiStatus", SqlDbType.Int);
cmd.Parameters["@BusiStatus"].Value = nBusiStatus;
cmd.Parameters.Add("@BusiParams", SqlDbType.VarChar, 2048);
cmd.Parameters["@BusiParams"].Value = strBusiParams;
cmd.ExecuteNonQuery();
}
catch (Exception se)
{
FConst.WriteErrLog("WriteRcvInfo:" + se.Message);
//try
//{
// if (con != null)
// con.Close();
//}
//catch { ;}
//con = null;
}
finally
{
try
{
if (con != null)
{
con.Close();
}
}
catch {; }
}
}
public static DataTable getAuthRemoteRecord()
{
DataTable dt = new DataTable();
dt.Columns.Add("id", typeof(int));
dt.Columns.Add("calltype", typeof(int));
dt.Columns.Add("sendinfo", typeof(string));
SqlConnection con = null;
SqlDataReader sdr = null;
try
{
con = new SqlConnection(SessionInfo.strConn);
con.Open();
SqlCommand cmd = new SqlCommand(string.Format("SELECT id,calltype,sendinfo from tblAuthRemote where status=0 and rq='{0}'", DateTime.Now.ToString("yyyy-MM-dd")), con);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
int id = Convert.ToInt32(sdr[0].ToString() + "");
int calltype = Convert.ToInt32(sdr[1].ToString() + "");
string sendinfo = sdr[2].ToString() + "";
dt.Rows.Add(id, calltype, sendinfo);
}
}
catch (Exception se)
{
FConst.WriteErrLog("getAuthRemoteRecord:" + se.Message);
}
finally
{
try
{
if (sdr != null)
{
sdr.Close();
}
}
catch {; }
try
{
if (con != null)
{
con.Close();
}
}
catch {; }
}
return(dt);
}
/// <summary>
/// 获取系统时间，每日启动1次即可
/// </summary>
/// <returns></returns>
public static int getSystemTime()
{
int nTaxFlowID = 0;
SqlConnection con = null;
try
{
con = new SqlConnection(SessionInfo.strConn);
con.Open();
SqlCommand cmd = new SqlCommand("spTaxGetSystemTime", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TaxFlowID", SqlDbType.Int);
cmd.Parameters["@TaxFlowID"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
nTaxFlowID = Convert.ToInt32(cmd.Parameters["@TaxFlowID"].Value);
return(nTaxFlowID);
}
catch (Exception se)
{
FConst.WriteErrLog("getSystemTime:" + se.Message);
//try
//{
// if (con != null)
// con.Close();
//}
//catch { ;}
//con = null;
return(nTaxFlowID);
}
finally
{
try
{
if (con != null)
{
con.Close();
}
}
catch {; }
}
}
//修改网络状态
public static void ModifySystemType()
{
SqlConnection con = null;
try
{
con = new SqlConnection(SessionInfo.strConn);
con.Open();
SqlCommand cmd = new SqlCommand("spModifySystemType", con);
cmd.CommandType = CommandType.StoredProcedure;
//@Status int
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Value = SessionInfo.nSystemType;
cmd.ExecuteNonQuery();
}
catch (Exception se)
{
FConst.WriteErrLog("ModifySystemType:" + se.Message);
//try
//{
// if (con != null)
// con.Close();
//}
//catch { ;}
//con = null;
}
finally
{
try
{
if (con != null)
{
con.Close();
}
}
catch {; }
}
}
