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