public CollectionInvokeResult <ServiceStation_Light> GetMerchantsAuthorized(string openId) { CollectionInvokeResult <ServiceStation_Light> result = new CollectionInvokeResult <ServiceStation_Light> { Success = true }; try { result.rows = BuilderFactory.DefaultBulder().List <ServiceStation_Light>("ServiceStation_Light_ListForServeManAuthorized", new { OpenId = openId }.ToStringObjectDictionary()); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> GetDispatchedServiceReceive(string workOrderId) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("GetDispatchedServiceReceive", new { WorkOrderId = Guid.Parse(workOrderId) }); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <Tree> List() { CollectionInvokeResult <Tree> result = new CollectionInvokeResult <Tree> { Success = true }; try { result.rows = BuilderFactory.DefaultBulder().List <Tree>(); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <MerchantServeManMappingOldMan> List() { CollectionInvokeResult <MerchantServeManMappingOldMan> result = new CollectionInvokeResult <MerchantServeManMappingOldMan> { Success = true }; try { result.rows = BuilderFactory.DefaultBulder().List <MerchantServeManMappingOldMan>(); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <RoadBaseInfo> List() { CollectionInvokeResult <RoadBaseInfo> result = new CollectionInvokeResult <RoadBaseInfo> { Success = true }; try { result.rows = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <RoadBaseInfo>(); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <OldMan> getOneOldMan(string strParms) { JObject _jObject = JObject.Parse(strParms); var openid = _jObject["openid"].ToString(); //用户 var IDNo = _jObject["IDNo"].ToString(); var OldIDNo = _jObject["OldIDNo"].ToString(); //老人 var OldName = _jObject["OldName"].ToString(); //查询老人与用户是否已经绑定 CollectionInvokeResult <NormalAccountFollow> resultFollow = new CollectionInvokeResult <NormalAccountFollow> { Success = true }; var dictionaryFollow = new StringObjectDictionary().MixInJson("{'OpenId':'" + openid + "','IDNo':'" + IDNo + "','FollowToIDNo':'" + OldIDNo + "','FollowToName':'" + OldName + "'}"); resultFollow.rows = BuilderFactory.DefaultBulder().List <NormalAccountFollow>(dictionaryFollow); CollectionInvokeResult <OldMan> result = new CollectionInvokeResult <OldMan> { Success = true }; if (resultFollow.rows.Count > 0) //如果绑定 直接返回 { result.ErrorCode = -1000; return(result); } //查询老人信息是否正确 正确绑定 var dictionary = new StringObjectDictionary().MixInJson("{'IDNo':'" + OldIDNo + "','Name':'" + OldName + "'}"); result.rows = BuilderFactory.DefaultBulder().List <OldMan>(dictionary); foreach (OldMan oldman in result.rows) { if (!string.IsNullOrEmpty(oldman.IDNo) && !string.IsNullOrEmpty(oldman.Name)) { if (!insertNormalAccountFollow(openid, IDNo, OldIDNo, OldName))//绑定老人 { result.Success = false; } return(result); } } return(result); }
public CollectionInvokeResult <StringObjectDictionary> ListByFamilyMember(string strParms) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { var dictionary = new StringObjectDictionary().MixInJson(strParms); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("OldManFamilyMember_Info_List2", dictionary.ToStringObjectDictionary(false)); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> LoadAgencyServicesCountForBigScreen(string serveStationId) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { StringObjectDictionary filters = new { ServeStationId = serveStationId }.ToStringObjectDictionary(); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("GetAgencyServeCountForBigScreen", filters); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <NormalAccount> isAuth(string strParms) { JObject _jObject = JObject.Parse(strParms); var code = _jObject["code"].ToString(); var state = _jObject["state"].ToString(); string openid = getOpenId(code); //第一时间得到 openid // Util.WriteTxt("isAuth openid," + openid); CollectionInvokeResult <NormalAccount> result = new CollectionInvokeResult <NormalAccount> { Success = true }; var dictionary = new StringObjectDictionary().MixInJson("{'OpenId':'" + openid + "'}"); result.rows = BuilderFactory.DefaultBulder().List <NormalAccount>(dictionary); result.ErrorMessage = openid; return(result); }
public CollectionInvokeResult <FamilyMember> ListForComboGrid() { CollectionInvokeResult <FamilyMember> result = new CollectionInvokeResult <FamilyMember> { Success = true }; try { var param = GetRequesParams(); result.rows = BuilderFactory.DefaultBulder().List <FamilyMember>(param); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <Area> Query(string strParms) { CollectionInvokeResult <Area> result = new CollectionInvokeResult <Area> { Success = true }; try { var dictionary = new StringObjectDictionary().MixInJson(strParms); result.rows = BuilderFactory.DefaultBulder().List <Area>(dictionary); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <CallService4M> GetEmergencyInner(string pageFrom, string pageTo) { CollectionInvokeResult <CallService4M> result = new CollectionInvokeResult <CallService4M> { Success = true }; try { StringObjectDictionary filters = new { FamilyMemberId = GetHttpHeader("FamilyMemberId"), PageFrom = pageFrom, PageTo = pageTo }.ToStringObjectDictionary(); result.rows = BuilderFactory.DefaultBulder().List <CallService4M>("CallServiceListByEmergency", filters); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> QueuedSendSms(SmsSend smsSend) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { StringObjectDictionary filters = new { Status = smsSend.Status, OrderByClause = " BatchNum,CheckInTime desc" }.ToStringObjectDictionary(); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("SmsSend_List2", filters); } catch (Exception e) { result.Success = false; result.ErrorMessage = e.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> GetFlowNameItem() { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { string sql = "select distinct FlowName as ItemId,FlowName as ItemCode,FlowCName as ItemName from Pub_FlowDefine where Status=1 order by FlowName asc"; result.rows = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlForQuery(sql); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> QueryServeManConfigInfo(string strParms) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { var dictionary = new StringObjectDictionary().MixInJson(strParms); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("GetServiceManConfigInfo", dictionary); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <ServiceStation> ServiceStationQuery(string strParms) { CollectionInvokeResult <ServiceStation> result = new CollectionInvokeResult <ServiceStation> { Success = true }; try { var dictionary = new StringObjectDictionary().MixInJson(strParms); result.rows = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <ServiceStation>("ServiceStation_CMSList", dictionary); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <ServiceTrackLog4M> GetServiceLogInner(string callServiceId) { CollectionInvokeResult <ServiceTrackLog4M> result = new CollectionInvokeResult <ServiceTrackLog4M> { Success = true }; try { StringObjectDictionary filters = new { CallServiceId = Guid.Parse(callServiceId) }.ToStringObjectDictionary(); result.rows = BuilderFactory.DefaultBulder().List <ServiceTrackLog4M>("TrackLogListByService", filters); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> QueryReportList(string strParms) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { var dictionary = new StringObjectDictionary().MixInJson(strParms); result.rows = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ListStringObjectDictionary("QueryEvaluatedReport_List", dictionary); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> GetWorkOrderFinishedInner() { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { Guid stationId = Guid.Parse(GetHttpHeader("StationId")); StringObjectDictionary filters = new { StationId = stationId }.ToStringObjectDictionary(); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("GetWorkOrderFinished", filters); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> GetReminderItems(string sourceTable, string sourceColumn) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { Guid stationId = Guid.Parse(GetHttpHeader("StationId")); StringObjectDictionary filters = new { SourceTable = sourceTable, SourceColumn = sourceColumn, ObjectType = "Merchant", ObjectKey = stationId }.ToStringObjectDictionary(); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("ReminderList_By_Merchant", filters); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> SelfListForBinding() { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { StringObjectDictionary filters = new StringObjectDictionary(); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("EPay_Package_SelfList", filters); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <SyncOut_ServiceWorkOrder_120701> GetSyncOutWorkOrders() { CollectionInvokeResult <SyncOut_ServiceWorkOrder_120701> result = new CollectionInvokeResult <SyncOut_ServiceWorkOrder_120701> { Success = true }; try { result.rows = BuilderFactory.DefaultBulder().ListByPage <SyncOut_ServiceWorkOrder_120701>(new { SyncFlag = 0 }.ToStringObjectDictionary(), new ListPager { OrderByClause = "CheckInTime asc", PageNo = 1, PageSize = 10 }); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <string> OutputSQL(string strDictionaryId) { CollectionInvokeResult <string> result = new CollectionInvokeResult <string> { Success = true }; try { string[] dictionaryIds = strDictionaryId.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); string tableName = dictionaryIds[0]; string tableNameItem = dictionaryIds[1]; string tableNameItemExtend = dictionaryIds[2]; string dictionaryIdAlls = dictionaryIds[3]; string dictionaryIdAll = ""; string dictionaryIdAllItemExtend = ""; if (dictionaryIds.Length > 3) { //for (int i = 3; i < dictionaryIds.Length; i++) //{ // dictionaryIds[i] = "'" + dictionaryIds[i] + "'"; // dictionaryIdAlls += dictionaryIds[i] + ","; //} dictionaryIdAll = "where Status='1' and DictionaryId in (" + dictionaryIdAlls + ")"; dictionaryIdAllItemExtend = "where DictionaryId in (" + dictionaryIdAlls + ")"; } else { dictionaryIdAll = ""; dictionaryIdAllItemExtend = ""; } List <string> _rows = new List <string>(); _rows.AddRange(BuilderFactory.DefaultBulder().ExecuteSPForQuery <StringObjectDictionary>("SP_Tol_UspOutputDataEx", new { TableName = tableName, WhereClause = dictionaryIdAll }).Select(item => item["targetscript"].ToString()).ToList()); _rows.AddRange(BuilderFactory.DefaultBulder().ExecuteSPForQuery <StringObjectDictionary>("SP_Tol_UspOutputDataEx", new { TableName = tableNameItem, WhereClause = dictionaryIdAll }).Select(item => item["targetscript"].ToString()).ToList()); _rows.AddRange(BuilderFactory.DefaultBulder().ExecuteSPForQuery <StringObjectDictionary>("SP_Tol_UspOutputDataEx", new { TableName = tableNameItemExtend, WhereClause = dictionaryIdAllItemExtend }).Select(item => item["targetscript"].ToString()).ToList()); result.rows = _rows; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> RoomEmptyBedList(Room room) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { StringObjectDictionary filters = new StringObjectDictionary(); filters = room.ToStringObjectDictionary(false); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("GetRoomEmptyBeds", filters); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <DatabaseConnect> GetConnectId(string strCityCode) { CollectionInvokeResult <DatabaseConnect> result = new CollectionInvokeResult <DatabaseConnect> { Success = true }; try { StringObjectDictionary dictionary = new StringObjectDictionary(); dictionary["WhereClause"] = "ConnectId like '%" + strCityCode + "'"; result.rows = BuilderFactory.DefaultBulder().List <DatabaseConnect>(dictionary); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <DeployAccessPoint> GetDeployAccessPoint() { CollectionInvokeResult <DeployAccessPoint> result = new CollectionInvokeResult <DeployAccessPoint> { Success = true }; try { result.rows = BuilderFactory.DefaultBulder(GlobalManager.getConnectString()).ListStringObjectDictionary("DeployAccessPoint_CTE_ListAncestor", null).Select(item => new DeployAccessPoint { AccessPoint = TypeConverter.ChangeString(item["AccessPoint"]), Levels = Convert.ToInt32(item["Levels"]), OrderNo = Convert.ToInt32(item["OrderNo"]), ItemName = TypeConverter.ChangeString(item["ItemName"]) }).ToList(); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> GetOldManInfoForSelfServiceMachine() { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary> { Success = true }; try { StringObjectDictionary filters = new StringObjectDictionary(); filters["StationCode"] = GetHttpHeader("PACode"); result.rows = BuilderFactory.DefaultBulder().ListStringObjectDictionary("GetOldManInfoForStationByStationCode", filters); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <ArticleColumn> HomeColumns(ArticleColumn param) { CollectionInvokeResult <ArticleColumn> result = new CollectionInvokeResult <ArticleColumn> { Success = true }; try { IList <ArticleColumn> columns = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).List <ArticleColumn>("Cms_Index_LoadMoreColumns", param.ToStringObjectDictionary(false)); result.rows = columns; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <StringObjectDictionary> GetWorkItem(string strStationId) { CollectionInvokeResult <StringObjectDictionary> result = new CollectionInvokeResult <StringObjectDictionary>() { Success = true }; try { string sql = "select * from Sys_DictionaryItem where DictionaryId='13001' " + "and ItemId not in (select WorkItem from Pam_AssessmentItem where StationId='" + strStationId + "' and Status=1)"; result.rows = BuilderFactory.DefaultBulder().ExecuteNativeSqlForQuery(sql);; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public CollectionInvokeResult <DictionaryItem> getOldManServiceItems(string strParms) { JObject _jObject = JObject.Parse(strParms); var ItemCode = _jObject["ItemCode"].ToString();//用户 CollectionInvokeResult <DictionaryItem> result = new CollectionInvokeResult <DictionaryItem> { Success = true }; try { var dictionary = new { DictionaryId = "11013", WhereClause = "ItemCode like '" + ItemCode + "%'" }.ToStringObjectDictionary(); result.rows = BuilderFactory.DefaultBulder().List <DictionaryItem>(dictionary); } catch (Exception ex) { Util.WriteTxt("查询老人服务项目:" + ex.ToString()); } return(result); }