예제 #1
1
        private static void ApplyFyCzInterService(DataRow drRow)
        {
            AutoPlanEntity _autohotelplanEntity = new AutoPlanEntity();
            _autohotelplanEntity.AutoHotelPlanDBEntity = new List<AutoHotelPlanDBEntity>();
            AutoHotelPlanDBEntity appcontentDBEntity = new AutoHotelPlanDBEntity();
            _autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity);

            string AgentID = ConfigurationManager.AppSettings["AgentID"].ToString();
            string Money = ConfigurationManager.AppSettings["FYMON"].ToString();

            appcontentDBEntity.AgentId = AgentID;
            appcontentDBEntity.Money = Money;
            appcontentDBEntity.OrderId = drRow["RESVID"].ToString().Trim();
            appcontentDBEntity.MobileNum = drRow["MOBILE"].ToString().Trim();
            appcontentDBEntity.UNIT_ID = drRow["UNIT_ID"].ToString().Trim();
            appcontentDBEntity.ORDER_STATUS = drRow["ORDER_STATUS"].ToString().Trim();
            appcontentDBEntity.NAME = drRow["NAME"].ToString().Trim();
            appcontentDBEntity.ARRD = drRow["ARRD"].ToString().Trim();
            appcontentDBEntity.DEPD = drRow["DEPD"].ToString().Trim();
            appcontentDBEntity.CHANNEL = drRow["CHANNEL"].ToString().Trim();
            appcontentDBEntity.PLATFORM_CODE = drRow["PLATFORM_CODE"].ToString().Trim();
            appcontentDBEntity.GUEST_ID = drRow["GUEST_TD"].ToString().Trim(); ;

            _autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity);
            AutoHotelPlanSA.ApplyFYCZInterface(_autohotelplanEntity);
        }
예제 #2
0
        public static int InsertYFOrderList(AutoHotelPlanDBEntity dbParm, Hashtable hsResult, string MsgRes)
        {
            string SendResult = hsResult.ContainsKey("result") ?  hsResult["result"].ToString() : "";
            string Pro = hsResult.ContainsKey("pro") ?  hsResult["pro"].ToString() : "";
            string Yys = hsResult.ContainsKey("yys") ?  hsResult["yys"].ToString() : "";
            string Code = hsResult.ContainsKey("code") ?  hsResult["code"].ToString() : "";
            string Price = hsResult.ContainsKey("price") ? hsResult["price"].ToString() : "";

            //订单号、预订人、入住门店、订单状态、预订人手机号、预订入住时间、预订离店时间、充值话费金额、充值状态、充值时间、运营商、入主渠道、平台
            string SqlString = XmlSqlAnalyze.GotSqlTextFromXml("AutoPlan", "InsertYFOrderList");
            MySqlParameter[] cmdParms ={
                                    new MySqlParameter("RESVID", MySqlDbType.VarChar),
                                    new MySqlParameter("NAME", MySqlDbType.VarChar),
                                    new MySqlParameter("MOBILE", MySqlDbType.VarChar),
                                    new MySqlParameter("UNIT_ID", MySqlDbType.VarChar),
                                    new MySqlParameter("ORDER_STATUS", MySqlDbType.VarChar),
                                    new MySqlParameter("ARRD", MySqlDbType.VarChar),
                                    new MySqlParameter("DEPD", MySqlDbType.VarChar),
                                    new MySqlParameter("CHANNEL", MySqlDbType.VarChar),
                                    new MySqlParameter("PLATFORM_CODE", MySqlDbType.VarChar),
                                    new MySqlParameter("SRESULT", MySqlDbType.VarChar),
                                    new MySqlParameter("PRO", MySqlDbType.VarChar),
                                    new MySqlParameter("YYS", MySqlDbType.VarChar),
                                    new MySqlParameter("CODE", MySqlDbType.VarChar),
                                    new MySqlParameter("PRICE", MySqlDbType.VarChar),
                                    new MySqlParameter("MONEY", MySqlDbType.VarChar),
                                    new MySqlParameter("GUEST_ID", MySqlDbType.VarChar),
                                    new MySqlParameter("MSGRES", MySqlDbType.VarChar)
                                };

            cmdParms[0].Value = dbParm.OrderId;
            cmdParms[1].Value = dbParm.NAME;
            cmdParms[2].Value = dbParm.MobileNum;
            cmdParms[3].Value = dbParm.UNIT_ID;
            cmdParms[4].Value = dbParm.ORDER_STATUS;
            cmdParms[5].Value = dbParm.ARRD;
            cmdParms[6].Value = dbParm.DEPD;
            cmdParms[7].Value = dbParm.CHANNEL;
            cmdParms[8].Value = dbParm.PLATFORM_CODE;
            cmdParms[9].Value =SendResult;
            cmdParms[10].Value = Pro;
            cmdParms[11].Value = Yys;
            cmdParms[12].Value = Code;
            cmdParms[13].Value = Price;
            cmdParms[14].Value = dbParm.Money;
            cmdParms[15].Value = dbParm.GUEST_ID;
            cmdParms[16].Value = MsgRes;
            return DbHelperMySQL.ExecuteSql(SqlString, cmdParms);
        }
예제 #3
0
        private static void ApplyFyCxInterService(DataRow drRow)
        {
            AutoPlanEntity _autohotelplanEntity = new AutoPlanEntity();
            _autohotelplanEntity.AutoHotelPlanDBEntity = new List<AutoHotelPlanDBEntity>();
            AutoHotelPlanDBEntity appcontentDBEntity = new AutoHotelPlanDBEntity();
            _autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity);

            string AgentID = ConfigurationManager.AppSettings["AgentID"].ToString();

            appcontentDBEntity.AgentId = AgentID;
            appcontentDBEntity.OrderId = drRow["RESVID"].ToString().Trim();
            appcontentDBEntity.MobileNum = drRow["MOBILE"].ToString().Trim();

            _autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity);
            AutoHotelPlanSA.ApplyFYCXInterface(_autohotelplanEntity);
        }