站长信息
jeffery.xu
jeffery.xu

软件工程师

欢迎访问我的个人笔记网站!我是一名热爱技术的开发者,专注于Web开发和技术分享。

811495111@qq.com
18521510875
筛选

个人笔记

新框架接口记录1-NHS企微展示
新框架

基本逻辑:NHS问卷完成后先查询是否和医药代表有关系,没有的话返回url链接

public dynamic QueryRelationExist(WebParameterContext webContext)
{
    var response = new ServerContext<dynamic>() { ResponseMessage = new ResponseMessage() { Success = true } };
    ActionReturnResponseMessage = () =>
    {
        try
        {
            var Datas = GetStoreCodeUserCodeByID(webContext);
            if (Datas == null)
            {
                return response;
            }
            string url = SystemConfig.GetValue("SanXiaFriendRelationQuery"); //"https://nhssanxia-test.nestlechinese.com/member-mini/apis/representative/exists";
            var friendresult = false;
            foreach (var Data in ((IEnumerable<dynamic>)Datas).ToList())
            {
                dynamic data = DynamicExtension.EmptyDynamic;
                data.userCode = Data.userCode;
                data.unionid = webContext.RequestBody.unionid;
                var content = HttpTools.SIMHttpPostSign(url, JSON.ToJSON(data), "查询医务业务代表好友关系");
                var result = JSON.ToDynamic(content);
                if (result.code == 20000)
                {
                    if (result.data == 1)
                    {
                        friendresult = true;
                        break;
                    }
                }
            }
            if (friendresult)
            {
                return response;
            }
            else
            {
                string QRurl = SystemConfig.GetValue("SanXiaQRCodeRepresent"); //"https://nhssanxia-test.nestlechinese.com/member-mini/apis/representative/qrcode";

                var returnValue = new List<dynamic>();
                foreach (var Data in ((IEnumerable<dynamic>)Datas).ToList())
                {
                    dynamic data = DynamicExtension.EmptyDynamic;
                    data.userCode = Data.userCode;
                    data.storeCode = Data.storeCode;
                    var content = HttpTools.SIMHttpPostSign(QRurl, JSON.ToJSON(data), "医务/业务代表企微渠道码");
                    var result = JSON.ToDynamic(content);
                    if (result.code == 20000)
                    {
                        returnValue.Add(result.data);

                    }

                }
                response.ResponseMessage.ErrorCode = 200;
                response.ResponseMessage.ErrorMessage = "获取成功";
                response.Status = returnValue;
                return response;
            }
        }
        catch (Exception ex)
        {
            return new ServerContext<dynamic>()
            {
                ResponseMessage = new ResponseMessage()
                {
                    Success = false,
                    ErrorCode = 500,
                    ErrorMessage = ex.Message
                }
            };
        }
    };
    return webContext;
}
用String_Split替代In
新框架
CommandContent name="CT_GetOffOrderReturnData" commandType="Text"  operateType="Write" cacheEnabled="true">
<CommandText>
<![CDATA[
    
select a.ID,b.ID as ProductID,b.ProductName,b.ProductCode,b.ProductKG,b.ProductUnit,a.TankCode,c.Order_ID,c.FK_SystemUser_ID,c.CreateTime,d.ChineseName as UserName 
from (select * from TBProductTankCode inner join STRING_SPLIT(@codes, ',') t on TankCode = t.value where [status]=1 and IsDelete=0 and IsValid=1) a 
left join TBProduct b on a.FK_TBProduct_ID=b.ID 
left join TBProductOrder c on a.FK_TBProductOrder_ID=c.ID 
left join SystemUser d on c.FK_SystemUser_ID=d.ID
where c.FK_TBStore_ID=@FK_StoreID
 
      ]]>
 
</CommandText>
</CommandContent>