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);
}
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);
}
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);
}