/// <summary>
///
//你好！请选择以下经销商为你推荐的顾问\n\n凯迪拉克上海旗舰店：\n【1001】选择米提\n【1002】选择莉莉\n【1003】选择提拉\n上海宝马旗舰店：\n【2001】选择天能\n【2002】选择欧拉\n【2003】选择埃克拉斯\n\n请您先输入顾问编号，该顾问就能为你提供服务!
/// </summary>
/// <returns></returns>
public static string GetMessage()
{
BL_Advisers a = new BL_Advisers();
DealerEmplList DE = a.GetDealerEmplList();
if (DE == null || DE.Dealer == null || DE.Empl == null)
{
return("没有联系到适合您的顾问,请跟具体经销商联系");
}
string senCon = "请选择以下经销商为你推荐的顾问\n如果你在2分钟内没有做出选择，我们会自动断开顾问选择连接\n\n";
for (int i = 0; i < DE.Dealer.Count; i++)
{
senCon += DE.Dealer[i].AD_Name_CN.Trim() + "\n";
for (int n = 0; n < DE.Empl.Count; n++)
{
if (DE.Dealer[i].AD_Code == DE.Empl[n].DE_AD_OM_Code)
{
senCon += "【" + DE.Empl[n].DE_Code + "】" + DE.Empl[n].AU_Name.Trim() + " \n";
}
}
}
senCon += "\n请您先输入顾问编号，该顾问就能为你提供服务!";
return(senCon);
}
public DealerEmplList GetDealerEmplList()
{
string sql = @"SELECT * FROM CT_AUTO_DEALERS INNER JOIN( SELECT DE_AD_OM_CODE FROM CT_DEALER_EMPL DE
INNER JOIN CT_EMPL_TYPE ON DE_TYPE=PET_CODE
INNER JOIN CT_AUTO_DEALERS ON AD_CODE=DE_AD_OM_CODE
INNER JOIN CT_Wechat_Member ON MB_AU_Code=DE.DE_AU_Code
INNER JOIN CT_All_Users AU ON AU.AU_Code=DE.DE_AU_Code AND AU.AU_UG_Code=26
WHERE PET_CODE=2 AND DE_UTYPE=1
GROUP BY DE_AD_OM_CODE) A ON AD_CODE=A.DE_AD_OM_CODE;
SELECT DE_UType,DE_AD_OM_Code,DE_Code,AU1.AU_Name FROM CT_DEALER_EMPL DE
INNER JOIN CT_EMPL_TYPE ON DE_TYPE=PET_CODE
INNER JOIN CT_AUTO_DEALERS ON AD_CODE=DE_AD_OM_CODE
INNER JOIN CT_ALL_USERS AU1 ON AU1.AU_CODE=DE_AU_CODE
INNER JOIN CT_Wechat_Member ON MB_AU_Code=DE.DE_AU_Code
INNER JOIN CT_All_Users AU ON AU.AU_Code=DE.DE_AU_Code AND AU.AU_UG_Code=26
WHERE PET_CODE=2 AND DE_UTYPE=1
ORDER BY DE_UTYPE ,DE_AD_OM_CODE ,DE_CODE;";
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, sql);
DealerEmplList o = new DealerEmplList();
o.Dealer = DataHelper.ConvertToList <CT_Auto_Dealers>(ds);
o.Empl = DataHelper.ConvertToList <CT_Dealer_Empl>(ds, 1);
return(o);
}
