Exemplo n.º 1
0
        //处理未评价信息
        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 {; }
            }
        }
Exemplo n.º 2
0
 public FrmQryBar()
 {
     InitializeComponent();
     lvwColumnSorter = new ListViewSorter();
     this.listData.ListViewItemSorter = lvwColumnSorter;
     FConst.SetColor(this);
 }
Exemplo n.º 3
0
        //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 {; }
            }
        }
Exemplo n.º 4
0
        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 {; }
            }
        }
Exemplo n.º 5
0
        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 {; }
            }
        }
Exemplo n.º 6
0
        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);
        }
Exemplo n.º 7
0
        /// <summary>
        /// 发送取票信息
        /// </summary>
        public void sendTicketInfo2Tax()
        {
            status = 2;

            //0:uuid, 1:busiNo, 2:ticketNo, 3:timestamp, 4:IDCard, 5:IDName, 6:sfzjlxDm
            String[] detail = sendinfo.Split(new string[] { "|" }, StringSplitOptions.None);

            String strUrl    = string.Format("http://{0}/services/pdjhjWebService_updateQhhm?wsdl", SessionInfo.strUrl);
            String method    = "updateQhhmNew";
            String uuid      = detail[0];
            String busiNo    = detail[1];
            String ticketNo  = detail[2];
            long   timestamp = GetTimeStamp();
            String IDCard    = detail[4];
            String IDName    = detail[5];
            String sfzjlxDm  = IDCard.Length > 0 ? "201" : "";

            FConst.WriteLog(String.Format("传入参数:大厅id=[{0}] 业务编码=[{1}] 取号号码=[{2}] 时戳=[{3}] 身份证=[{4}] 姓名=[{5}] 身份证类型=[{6}]",
                                          uuid, busiNo, ticketNo, timestamp, IDCard, IDName, sfzjlxDm));

            try
            {
                FConst.WriteLog(String.Format("开始调用接口[{0}]{1}", method, strUrl));
                if (SessionInfo.nSystemType == 1)
                {
                    WebServiceProxy wsdl = new WebServiceProxy(strUrl, "pdjh");
                    FConst.WriteLog(String.Format("开始调用接口[{0}]{1},初始化完成", method, strUrl));
                    String result = wsdl.ExecuteQuery(method, new object[] { uuid, busiNo, ticketNo, timestamp, IDCard, IDName, sfzjlxDm }).ToString();

                    FConst.WriteLog(String.Format("调用方法{0}返回值:[{1}]", method, result));
                    String resultValue = JObject.Parse(result)["result"].ToString();
                    if (resultValue.Equals("1"))
                    {
                        status = 1;
                    }
                    FConst.WriteLog(String.Format("调用方法{0}结果状态:[{1}]", method, resultValue.Equals("1") ? "调用成功" : "调用失败"));
                }
                else
                {
                    FConst.WriteLog(String.Format("系统处于脱机方式,无法调用接口[SystemType={0}]", SessionInfo.nSystemType));
                }
            }
            catch (Exception ex)
            {
                FConst.WriteLog(String.Format("调用方法{0}时发生异常:{1}", method, ex.ToString()));
            }
        }
Exemplo n.º 8
0
 //刷新菜单权限
 public static void RefreshOpRight(ToolStrip ts)
 {
     string strTrCode;
     foreach (ToolStripItem item in ts.Items)
     {
         if (item.Tag == null)
             item.Enabled = false;
         else if (item.Tag.ToString() == "1")
             item.Enabled = true;
         else
         {
             strTrCode = item.Tag.ToString();
             if (FConst.CheckRight(strTrCode))
                 item.Enabled = true;
             else
                 item.Enabled = false;
         }
     }
 }
Exemplo n.º 9
0
        /// <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 {; }
            }
        }
Exemplo n.º 10
0
        //修改网络状态
        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 {; }
            }
        }
Exemplo n.º 11
0
        public string getHallBusiInfo()
        {
            string hallBusiInfo = "";

            //string strSql = string.Format("Select BusiNo,BusiName,WaitNum,checkUser,BusiType,MenuType,IsHouseBusi,MetaBusiNo,AMGetNum,PMGetNum From tblBusi Where MenuType in (0,1) and Status=1 order by MenuType,SortID");
            //DBUtils dbUtils = new DBUtils();
            //DataTable dt = dbUtils.SelectSqlDB(strSql);
            //if (dt != null && dt.Rows.Count > 0)
            //{
            //    string uuid = dt.Rows[0]["QueueID"].ToString().Trim();
            //}

            JObject jsonBusiData = new JObject();
            JArray  jsonBusi     = new JArray();
            int     busiCount    = 0;

            DataTable     dt  = new DataTable();
            SqlConnection con = null;

            try
            {
                con = new SqlConnection(SessionInfo.strConn);
                con.Open();
                SqlCommand cmd = new SqlCommand("procGetBusiInfoEx", con);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter sqlda = new SqlDataAdapter(cmd);
                sqlda.Fill(dt);
                if (dt != null && dt.Rows.Count > 0)
                {
                    busiCount = dt.Rows.Count;
                    for (int idx = 0; idx < busiCount; idx++)
                    {
                        JObject jsonItem = new JObject();
                        jsonItem.Add("busino", dt.Rows[idx]["BusiNo"].ToString().Trim());
                        jsonItem.Add("businame", dt.Rows[idx]["BusiName"].ToString().Trim());

                        jsonBusi.Add(jsonItem);
                    }
                }
            }
            catch (Exception se)
            {
                FConst.WriteLog("获取业务列表信息procGetBusiInfoEx:" + se.Message);
                busiCount = 0;
                jsonBusi.Clear();
            }
            finally
            {
                try
                {
                    if (con != null)
                    {
                        con.Close();
                    }
                }
                catch {; }
                try
                {
                    if (dt != null)
                    {
                        dt.Clear();
                        dt.Dispose();
                    }
                }
                catch {; }
            }
            jsonBusiData.Add("rows", busiCount);
            jsonBusiData.Add("busi", jsonBusi);
            hallBusiInfo = JsonConvert.SerializeObject(jsonBusiData);

            return(hallBusiInfo);
        }
Exemplo n.º 12
0
        /// <summary>
        /// 生成上传实名信息及照片的xml报文(航信)
        /// </summary>
        /// <param name="paramIn"></param>
        public string getRealNamePhotoPacket(string paramIn)
        {
            string xmlPacket = null;

            // @ParamIn = @UUID+'|'+@BusiNo+'|'+@TicketNo+'|'+@timestamp+'|'
            string[] tmp = paramIn.Split('|');

            string    transDate = DateTime.Now.ToString("yyyyMMdd");
            string    busiNo    = tmp[1].Trim();
            string    ticketNo  = tmp[2].Trim();
            string    strSql    = string.Format("select f.FlowID,f.TransDate,f.BusiNo,f.TicketNo,f.PID,f.UserName,f.FormNo,form.DisplayName,f.EmpNo, rn.QueueID, rn.UserPhoto from tblFlow as f, tblForm as form, tblRealName as rn where f.status=1 and f.TransDate='{0}' and f.BusiNo='{1}' and f.TicketNo='{2}' and f.FormNo=form.FormNo and f.PID=rn.PID", transDate, busiNo, ticketNo);
            DBUtils   dbUtils   = new DBUtils();
            DataTable dt        = dbUtils.SelectSqlDB(strSql);

            if (dt != null && dt.Rows.Count > 0)
            {
                string uuid        = dt.Rows[0]["QueueID"].ToString().Trim();
                string FormNo      = dt.Rows[0]["FormNo"].ToString().Trim();
                string DisplayName = dt.Rows[0]["DisplayName"].ToString().Trim();
                string EmpNo       = dt.Rows[0]["EmpNo"].ToString().Trim();
                string PID         = dt.Rows[0]["PID"].ToString().Trim();
                string UserName    = dt.Rows[0]["UserName"].ToString().Trim();
                byte[] UserPhoto   = (byte[])dt.Rows[0]["UserPhoto"];

                XmlDocument    xmlDoc  = new XmlDocument();
                XmlDeclaration xmlDecl = xmlDoc.CreateXmlDeclaration("1.0", "GB2312", null);
                xmlDoc.AppendChild(xmlDecl);

                XmlElement serviceElement = xmlDoc.CreateElement("", "service", "");
                serviceElement.SetAttribute("xmlns", "http://www.chinatax.gov.cn/spec/");
                serviceElement.SetAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance");

                XmlElement headElement = xmlDoc.CreateElement("", "head", "");
                XmlElement element     = xmlDoc.CreateElement("", "tran_id", "");
                element.InnerText = "CQ.QT.DZSWJ.HXRLSB.PDJH";
                headElement.AppendChild(element);

                element           = xmlDoc.CreateElement("", "channel_id", ""); //channel_id从配置文件读取
                element.InnerText = SessionInfo.channel_id_hx;
                headElement.AppendChild(element);

                string strBusinessDate = DateTime.Now.ToString("yyyyMMdd");
                string strBusinessTime = DateTime.Now.ToString("HHmmss");
                string sequenceID      = string.Format("{0}{1}{2}{3}{4}", uuid, SessionInfo.strIpAddr, SessionInfo.strMac, strBusinessDate, strBusinessTime);
                element           = xmlDoc.CreateElement("", "tran_seq", "");
                element.InnerText = FConst.GetMD5(sequenceID);
                headElement.AppendChild(element);

                element           = xmlDoc.CreateElement("", "tran_date", "");
                element.InnerText = strBusinessDate;
                headElement.AppendChild(element);

                element           = xmlDoc.CreateElement("", "tran_time", "");
                element.InnerText = strBusinessTime;
                headElement.AppendChild(element);

                serviceElement.AppendChild(headElement);

                XmlElement expandElement = xmlDoc.CreateElement("", "expand", "");
                serviceElement.AppendChild(expandElement);

                XmlElement bodyElement = xmlDoc.CreateElement("", "body", "");

                XmlDocument rootDoc     = new XmlDocument();
                XmlElement  rootElement = rootDoc.CreateElement("", "root", "");
                element           = rootDoc.CreateElement("", "pdbh", "");
                element.InnerText = ticketNo;
                rootElement.AppendChild(element);

                element           = rootDoc.CreateElement("", "dtbh", "");
                element.InnerText = uuid;
                rootElement.AppendChild(element);

                element           = rootDoc.CreateElement("", "zxbh", "");
                element.InnerText = FormNo;
                rootElement.AppendChild(element);

                element           = rootDoc.CreateElement("", "dzxbh", "");
                element.InnerText = DisplayName;
                rootElement.AppendChild(element);

                element           = rootDoc.CreateElement("", "jhjbh", "");
                element.InnerText = uuid;
                rootElement.AppendChild(element);

                element           = rootDoc.CreateElement("", "sfzhm", "");
                element.InnerText = PID;
                rootElement.AppendChild(element);

                element           = rootDoc.CreateElement("", "sfzxm", "");
                element.InnerText = UserName;
                rootElement.AppendChild(element);

                element           = rootDoc.CreateElement("", "sfztx", "");
                element.InnerText = Base64Util.Base64Encode(UserPhoto);
                rootElement.AppendChild(element);
                rootDoc.AppendChild(rootElement);

                bodyElement.AppendChild(xmlDoc.CreateCDataSection(rootDoc.InnerXml));
                serviceElement.AppendChild(bodyElement);

                xmlDoc.AppendChild(serviceElement);
                xmlPacket = xmlDoc.InnerXml;
            }
            if (dt != null)
            {
                dt.Clear();
                dt.Dispose();
            }
            dbUtils.CloseSqlDB();

            return(xmlPacket);
        }