public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
CauseObject_MCE_B_AOG p = new CauseObject_MCE_B_AOG();
p.ID = request["id"].ToString();
DisplayObject_MCE_B_AOG[] listHead = BizLogicObject_MCE_B_AOG.Proxy.Query(p);
JSON_PAGER jsonPager = new JSON_PAGER();
if (listHead == null)
{
throw new Exception("获取列表信息失败.");
}
jsonPager.head = listHead[0];
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "ASSETS_NAME";
CauseObject_MCE_B_AOG_D pd = new CauseObject_MCE_B_AOG_D();
pd.BASE_ID = request["id"].ToString();
DisplayObject_MCE_B_AOG_D[] listDetail = BizLogicObject_MCE_B_AOG_D.Proxy.Query(pd, null, orderBy);
jsonPager.total = listDetail.Length;
jsonPager.rows = listDetail;
jsonMsg.Succeed = 1;
jsonMsg.Message = jsonPager;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
context.Response.Write(strMsg);
context.Response.End();
}
}
private string GetRollCode()
{
string strRollCode = "";
string strCode = DateTime.Now.ToString("yyyyMMdd");
int code = 1;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = false;
orderBy.OrderBy = "CODE";
var cause = new CauseObject_MCE_B_ASSETS_ROLL();
cause.SetCustomCondition(" and MCE_B_ASSETS_ROLL.CODE like '" + strCode + "%'");
var list = BizLogicObject_MCE_B_ASSETS_ROLL.Proxy.Query(cause, null, orderBy);
if (list != null && list.Length > 0)
{
var s_code = list[0].CODE;
var rightCode = s_code.Replace(strCode, "").TrimStart('0');
code = int.Parse(rightCode) + 1;
}
strRollCode = strCode + (code).ToString().PadLeft(3, '0');
return(strRollCode);
}
public static IOrderedQueryable <TEntity> OrderBy <TEntity>(
this IQueryable <TEntity> source,
OrderByParameter orderParameter)
{
var type = typeof(TEntity);
var parameter = Expression.Parameter(type, "p");
if (!ExpressionUtil.TryGetProperty(parameter, orderParameter.Node, out var property))
{
throw new BadRequestException("Invalid property description");
}
var propertyAccess = Expression.MakeMemberAccess(parameter, property.Member);
var orderByExpr = Expression.Lambda(propertyAccess, parameter);
var methodName = orderParameter.SortDirection == ListSortDirection.Ascending ?
Methods.OrderBy :
Methods.OrderByDescending;
var callExpr = Expression.Call(
typeof(Queryable), methodName,
new Type[] { type, property.Type },
source.Expression, Expression.Quote(orderByExpr));
return((IOrderedQueryable <TEntity>)source.Provider.CreateQuery <TEntity>(callExpr));
}
public List <JsonMceTypeTree> getMceTypeTree()
{
if (LocalMode)
{
List <JsonMceTypeTree> nodes = new List <JsonMceTypeTree>();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "CODE";
CauseObject_MCE_D_MCE_TYPE pType = new CauseObject_MCE_D_MCE_TYPE();
pType.SetCustomCondition(" and MCE_D_MCE_TYPE.PARENT_ID is null ");
EntityObject_MCE_D_MCE_TYPE[] types = HelperObject_MCE_D_MCE_TYPE.Query(pType, null, orderBy, transaction);
foreach (EntityObject_MCE_D_MCE_TYPE type in types)
{
JsonMceTypeTree tmp = new JsonMceTypeTree();
tmp.id = type.ID.Trim();
tmp.text = type.NAME;
tmp.state = "open";
tmp.children = new List <JsonMceTypeTree>();
nodes.Add(tmp);
}
int count = 0;
CauseObject_MCE_D_MCE_TYPE pChild = new CauseObject_MCE_D_MCE_TYPE();
foreach (JsonMceTypeTree node in nodes)
{
addTreeNode(node, count, pChild, orderBy, transaction);
}
transaction.Commit();
}
catch (Exception expt)
{
nodes = null;
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(nodes);
}
else
{
using (ServiceManager <ServiceContract_MCE_D_MCE_TYPE> smgr = new ServiceManager <ServiceContract_MCE_D_MCE_TYPE>(ServiceUri))
{
return(smgr.Service.getMceTypeTree());
}
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
string strIDS = "";
if (!string.IsNullOrEmpty(request["ids"]))
{
strIDS = request["ids"].ToString();
}
if (string.IsNullOrEmpty(strIDS))
{
throw new Exception("参数错误.");
}
string[] arrID = strIDS.Split(',');
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "assets_code";
CauseObject_V_MCE_ASSET_OUTSTOCK_BACK p = new CauseObject_V_MCE_ASSET_OUTSTOCK_BACK();
foreach (string strID in arrID)
{
p.SetINValue("BASE_ID", strID);
}
DisplayObject_V_MCE_ASSET_OUTSTOCK_BACK[] list = BizLogicObject_V_MCE_ASSET_OUTSTOCK_BACK.Proxy.Query(p);
jsonMsg.Message = list;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public Uri GetFullUri()
{
Contract.Ensures(Contract.Result <Uri>() != null);
#if !NETFX_CORE
Contract.Ensures(Contract.Result <Uri>().Scheme == Uri.UriSchemeHttp || Contract.Result <Uri>().Scheme == Uri.UriSchemeHttps);
#endif
var parameters = new List <string>();
if (!string.IsNullOrWhiteSpace(FilterParameter))
{
#if !SILVERLIGHT && !NETFX_CORE
parameters.Add(BuildParameter(StringConstants.FilterParameter, HttpUtility.UrlEncode(FilterParameter)));
#else
parameters.Add(BuildParameter(StringConstants.FilterParameter, FilterParameter));
#endif
}
if (!string.IsNullOrWhiteSpace(SelectParameter))
{
parameters.Add(BuildParameter(StringConstants.SelectParameter, SelectParameter));
}
if (!string.IsNullOrWhiteSpace(SkipParameter))
{
parameters.Add(BuildParameter(StringConstants.SkipParameter, SkipParameter));
}
if (!string.IsNullOrWhiteSpace(TakeParameter))
{
parameters.Add(BuildParameter(StringConstants.TopParameter, TakeParameter));
}
if (OrderByParameter.Any())
{
parameters.Add(BuildParameter(StringConstants.OrderByParameter, string.Join(",", OrderByParameter)));
}
if (!string.IsNullOrWhiteSpace(ExpandParameter))
{
parameters.Add(BuildParameter(StringConstants.ExpandParameter, ExpandParameter));
}
var builder = new UriBuilder(_serviceBase);
builder.Query = (string.IsNullOrEmpty(builder.Query) ? string.Empty : builder.Query.Substring(1) + "&") + string.Join("&", parameters);
var resultUri = builder.Uri;
#if !NETFX_CORE
Contract.Assume(_serviceBase.Scheme == Uri.UriSchemeHttp || _serviceBase.Scheme == Uri.UriSchemeHttps);
Contract.Assume(resultUri.Scheme == Uri.UriSchemeHttp || resultUri.Scheme == Uri.UriSchemeHttps);
#endif
return(resultUri);
}
public QueryReciever(
TRequest request,
string route)
{
Parameters = new List <IParameter>();
PaginationQuery = new PaginationQuery(request);
RequestRoute = route;
OrderByParameter =
string.IsNullOrWhiteSpace(request.OrderBy) ||
!request.OrderBy.Contains(":") ?
null : new OrderByParameter(request);
Add <CreatedDateParameter>(request.CreatedDate);
Add <UpdatedDateParameter>(request.UpdatedDate);
}
public Uri GetFullUri()
{
var parameters = new List <string>();
if (!FilterParameter.IsNullOrWhiteSpace())
{
parameters.Add(BuildParameter(StringConstants.FilterParameter, HttpUtility.UrlEncode(FilterParameter)));
}
if (!SelectParameter.IsNullOrWhiteSpace())
{
parameters.Add(BuildParameter(StringConstants.SelectParameter, SelectParameter));
}
if (!SkipParameter.IsNullOrWhiteSpace())
{
parameters.Add(BuildParameter(StringConstants.SkipParameter, SkipParameter));
}
if (!TakeParameter.IsNullOrWhiteSpace())
{
parameters.Add(BuildParameter(StringConstants.TopParameter, TakeParameter));
}
if (OrderByParameter.Any())
{
parameters.Add(BuildParameter(StringConstants.OrderByParameter, OrderByParameter.Join(",")));
}
if (!ExpandParameter.IsNullOrWhiteSpace())
{
parameters.Add(BuildParameter(StringConstants.ExpandParameter, ExpandParameter));
}
var builder = new UriBuilder(m_serviceBase);
builder.Query = (string.IsNullOrEmpty(builder.Query) ? string.Empty : "&") + parameters.Join("&");
var resultUri = builder.Uri;
return(resultUri);
}
//默认排序
public static OrderByParameter GetOrder(string order, string sort)
{
OrderByParameter orders = new OrderByParameter();
if (string.IsNullOrEmpty(order))
{
order = "0";
}
//QUOTED_PRICE_MIN desc,QUOTED_PRICE desc,PRICE
if (string.IsNullOrEmpty(sort))
{
sort = "ID";
}
orders.Asc = order == "1" ? true : false;
orders.OrderBy = sort;
return(orders);
}
public IEnumerable <KeyValuePair <string, string> > Build()
{
var parameters = new List <KeyValuePair <string, string> >();
if (!string.IsNullOrWhiteSpace(FilterParameter))
{
parameters.Add(BuildParameter(StringConstants.FilterParameter, FilterParameter));
}
if (!string.IsNullOrWhiteSpace(SelectParameter))
{
parameters.Add(BuildParameter(StringConstants.SelectParameter, SelectParameter));
}
if (!string.IsNullOrWhiteSpace(SkipParameter))
{
parameters.Add(BuildParameter(StringConstants.SkipParameter, SkipParameter));
}
if (!string.IsNullOrWhiteSpace(TakeParameter))
{
parameters.Add(BuildParameter(StringConstants.TopParameter, TakeParameter));
}
if (OrderByParameter.Any())
{
parameters.Add(BuildParameter(StringConstants.OrderByParameter, string.Join(",", OrderByParameter)));
}
if (!string.IsNullOrWhiteSpace(ExpandParameter))
{
parameters.Add(BuildParameter(StringConstants.ExpandParameter, ExpandParameter));
}
if (IncludeCount)
{
parameters.Add(BuildParameter("$inlinecount", "allpages"));
}
return(parameters);
}
public static IOrderedQueryable <TEntity> OrderBy <TEntity>(
this IQueryable <TEntity> source,
OrderByParameter orderParameter)
{
var type = typeof(TEntity);
var parameter = Expression.Parameter(type, "p");
var property = Expression.Property(parameter, orderParameter.Node);
var propertyAccess = Expression.MakeMemberAccess(parameter, property.Member);
var orderByExpr = Expression.Lambda(propertyAccess, parameter);
var methodName = orderParameter.SortDirection == ListSortDirection.Ascending ?
Method.OrderBy :
Method.OrderByDescending;
var callExpr = Expression.Call(
typeof(Queryable), methodName,
new Type[] { type, property.Type },
source.Expression, Expression.Quote(orderByExpr));
return(source.Provider.CreateQuery <TEntity>(callExpr) as IOrderedQueryable <TEntity>);
}
/// <summary>
/// 构建查询 Uri.Query 部分。
/// </summary>
/// <returns>Uri.Query 部分的字符串。</returns>
public string BuildUri()
{
var parameters = new List <string>();
if (!string.IsNullOrWhiteSpace(FilterParameter))
{
parameters.Add(BuildParameter("$filter", HttpUtility.UrlEncode(FilterParameter)));
}
if (!string.IsNullOrWhiteSpace(SelectParameter))
{
parameters.Add(BuildParameter("$select", SelectParameter));
}
if (!string.IsNullOrWhiteSpace(SkipParameter))
{
parameters.Add(BuildParameter("$skip", SkipParameter));
}
if (!string.IsNullOrWhiteSpace(TakeParameter))
{
parameters.Add(BuildParameter("$top", TakeParameter));
}
if (OrderByParameter.Any())
{
parameters.Add(BuildParameter("$orderby", string.Join(",", OrderByParameter)));
}
if (!string.IsNullOrWhiteSpace(ExpandParameter))
{
parameters.Add(BuildParameter("$expand", ExpandParameter));
}
return(string.Join("&", parameters));
}
public void Apply(OrderByParameter param) => _orderProperty = GetOrderFieldName(param.Value);
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "CODE, NAME";
PagingParamter pager = new PagingParamter();
pager.PageSize = string.IsNullOrEmpty(request["limit"]) ? 10 : int.Parse(request["limit"].ToString());
pager.PageIndex = string.IsNullOrEmpty(request["offset"]) ? 0 : (int.Parse(request["offset"].ToString()) <= 0) ? 0 : int.Parse(request["offset"].ToString()) - 1;
StringBuilder strCondition = new StringBuilder();
strCondition.Append(" and MDM_D_STOCK.STOCK_TYPE_ID = '00320003' ");
List <JsonMtrPurStock> list = new System.Collections.Generic.List <JsonMtrPurStock>();
CauseObject_MDM_D_STOCK cause = new CauseObject_MDM_D_STOCK();
if (!string.IsNullOrEmpty(request["area"]))
{
cause.DEPT_ID = request["area"].ToString().Trim();
}
if (!string.IsNullOrEmpty(request["is_area"]) && request["is_area"].ToString().Trim() == "1")
{
cause.DEPT_ID = BizLogicObject_MTR_D_MTR.Proxy.getAreaByDept(SystemLogic.Proxy.CurrentUser.DEPART_ID.Trim());
}
if (!string.IsNullOrEmpty(request["condition"]))
{
strCondition.Append(string.Format(" and (upper(MDM_D_STOCK.CODE) like upper('%{0}%') or upper(MDM_D_STOCK.NAME) like upper('%{0}%')) ", request["condition"].ToString().Trim()));
}
cause.SetCustomCondition(strCondition.ToString());
DisplayObject_MDM_D_STOCK[] stocks = BizLogicObject_MDM_D_STOCK.Proxy.Query(cause, pager, orderBy);
foreach (DisplayObject_MDM_D_STOCK item in stocks)
{
JsonMtrPurStock tmp = new JsonMtrPurStock();
tmp.id = item.ID.Trim();
tmp.code = item.CODE;
tmp.name = item.NAME;
tmp.dept = item.DEPT_ID.Trim();
tmp.deptName = item.DEPT_ID_NAME;
list.Add(tmp);
}
JSON_PAGER jsonPager = new JSON_PAGER();
jsonPager.total = pager.TotalRecords;
jsonPager.rows = list;
jsonMsg.Succeed = 1;
jsonMsg.Message = jsonPager;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
context.Response.Write(JsonConvert.SerializeObject(jsonMsg));
context.Response.End();
}
}
private void addTreeNode(JsonMceTypeTree node, int count, CauseObject_MCE_D_MCE_TYPE pChild, OrderByParameter orderBy, IDbTransaction transaction)
{
if (count > 5)
{
return;
}
pChild.PARENT_ID = node.id;
EntityObject_MCE_D_MCE_TYPE[] typeChildren = HelperObject_MCE_D_MCE_TYPE.Query(pChild, null, orderBy, transaction);
if (typeChildren == null || typeChildren.Length == 0)
{
node.state = "";
return;
}
foreach (EntityObject_MCE_D_MCE_TYPE typeChild in typeChildren)
{
JsonMceTypeTree tmp = new JsonMceTypeTree();
tmp.id = typeChild.ID.Trim();
tmp.text = typeChild.NAME;
tmp.state = "closed";
tmp.children = new List <JsonMceTypeTree>();
node.children.Add(tmp);
addTreeNode(tmp, count + 1, pChild, orderBy, transaction);
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "CODE";
//PagingParamter pager = new PagingParamter();
//pager.PageSize = int.MaxValue;
//pager.PageIndex = 0;
StringBuilder strCondition = new StringBuilder();
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
CauseObject_MCE_B_ASSETS_AFFIX p = new CauseObject_MCE_B_ASSETS_AFFIX();
p.ASSETS_ID = request["id"];
if (!string.IsNullOrEmpty(request["condition"]))//
{
strCondition.Append(" and (MCE_B_ASSETS_AFFIX.CODE like '%" + request["condition"].ToString().Trim() + "%' or MCE_B_ASSETS_AFFIX.NAME like '%" + request["condition"].ToString().Trim() + "%' or MCE_B_ASSETS_AFFIX.SPEC like '%" + request["condition"].ToString().Trim() + "%' )");
}
if (!string.IsNullOrEmpty(strCondition.ToString()))
{
p.SetCustomCondition(strCondition.ToString());
}
DisplayObject_MCE_B_ASSETS_AFFIX[] list = BizLogicObject_MCE_B_ASSETS_AFFIX.Proxy.Query(p, null, orderBy);
if (list != null && list.Length > 0)
{
foreach (DisplayObject_MCE_B_ASSETS_AFFIX item in list)
{
string strFiles = "";
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = item.ID;
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_AFFIX";
DisplayObject_COM_FILE[] listCOM_FILE = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE);
if (listCOM_FILE != null && listCOM_FILE.Length > 0)
{
foreach (DisplayObject_COM_FILE file in listCOM_FILE)
{
if (!string.IsNullOrEmpty(file.SERVER_NAME))
{
strFiles = strFiles + file.SERVER_NAME + "/" + file.CLIENT_NAME + ",";
}
}
strFiles = strFiles.TrimEnd(',');
}
item.BACKUP1 = strFiles;
item.BACKUP2 = BarCodeHelper.GenerateBarCode(item.CODE);
}
}
//JSON_PAGER jsonPager = new JSON_PAGER();
//jsonPager.total = pager.TotalRecords;
//jsonPager.rows = list;
jsonMsg.Message = list;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "CODE,PERIODS";
PagingParamter pager = new PagingParamter();
pager.PageSize = string.IsNullOrEmpty(request["limit"]) ? 10 : int.Parse(request["limit"].ToString());
pager.PageIndex = string.IsNullOrEmpty(request["offset"]) ? 0 : (int.Parse(request["offset"].ToString()) <= 0) ? 0 : int.Parse(request["offset"].ToString()) - 1;
CauseObject_V_MCE_QUERY_CONTRACT_PAY p = new CauseObject_V_MCE_QUERY_CONTRACT_PAY();
p.H_STATE = 3;
p.CONTRACT_STATE = 1;
if (!string.IsNullOrEmpty(request["status"]))
{
p.STATE = int.Parse(request["status"].ToString());
}
if (!string.IsNullOrEmpty(request["contract_status"]))
{
p.CONTRACT_STATE = int.Parse(request["contract_status"].ToString());
}
if (!string.IsNullOrEmpty(request["dept"]))
{
p.SECOND_PARTY = request["dept"].ToString();
}
if (!string.IsNullOrEmpty(request["code"]))
{
p.CODE = "%" + request["code"].ToString() + "%";
}
if (!string.IsNullOrEmpty(request["name"]))
{
p.NAME = "%" + request["name"].ToString() + "%";
}
if (!string.IsNullOrEmpty(request["beginspan"]))
{
p.PLAN_PAY_DATE = new DateSpan();
p.PLAN_PAY_DATE.End = DateTime.Parse(request["beginspan"].ToString()).AddDays(1);
}
DisplayObject_V_MCE_QUERY_CONTRACT_PAY[] list = BizLogicObject_V_MCE_QUERY_CONTRACT_PAY.Proxy.Query(p, pager, orderBy);
JSON_PAGER jsonPager = new JSON_PAGER();
jsonPager.total = pager.TotalRecords;
jsonPager.rows = list;
jsonMsg.Message = jsonPager;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public static DisplayObject_MCE_B_ASSETS_CHECK_TYPE[] Query(CauseObject_MCE_B_ASSETS_CHECK_TYPE cause, PagingParamter paging, OrderByParameter order, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_CHECK_TYPE.TYPE_ID, MCE_B_ASSETS_CHECK_TYPE.BASE_ID, MCE_B_ASSETS_CHECK_TYPE.ID, MCE_D_MCE_TYPE_TYPE_ID.NAME as TYPE_ID_NAME from MCE_B_ASSETS_CHECK_TYPE left join MCE_D_MCE_TYPE MCE_D_MCE_TYPE_TYPE_ID on MCE_B_ASSETS_CHECK_TYPE.TYPE_ID = MCE_D_MCE_TYPE_TYPE_ID.ID where (1=1)";
string sCauseSql = PrepareCause(cause, out parameters);
sSql += sCauseSql;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
sSql = "select t.* from (" + sSql + ") t,( select t." + cause.Recursion.TargetKeyFieldName + " from " + cause.Recursion.TargetDataObjectName + " t start with t." + cause.Recursion.TargetKeyFieldName + " = '" + cause.Recursion.RecursionFieldValue + "' connect by t." + cause.Recursion.TargetLevelFieldName + " = PRIOR t." + cause.Recursion.TargetKeyFieldName + " ) t1 where t." + cause.Recursion.RecursionFieldName + " = t1." + cause.Recursion.TargetKeyFieldName;
}
#region Push Block
if (paging != null)
{
string countSql = string.Empty;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
else
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
if (paging.TotalRecords == 0)
{
paging.TotalRecords = IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.SqlServer || IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.Db2? (int)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, trans) : (int)(decimal)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, trans);
}
sqlReader = IDALProvider.IDAL.ExecutePagingReader("MCE_B_ASSETS_CHECK_TYPE", paging, order, sSql, parameters, trans);
}
else if (order != null)
{
sSql += order.ToString();
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
}
else
{
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
}
DisplayObject_MCE_B_ASSETS_CHECK_TYPE dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_CHECK_TYPE();
if (!sqlReader.IsDBNull(0))
{
dataObj.TYPE_ID = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.BASE_ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.ID = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.TYPE_ID_NAME = sqlReader.GetString(3);
}
objArray.Add(dataObj);
}
sqlReader.Close();
#endregion
DisplayObject_MCE_B_ASSETS_CHECK_TYPE[] objs = new DisplayObject_MCE_B_ASSETS_CHECK_TYPE[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
CauseObject_MCE_B_ASSETS_CONTRACT p = new CauseObject_MCE_B_ASSETS_CONTRACT();
p.ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_CONTRACT[] listHead = BizLogicObject_MCE_B_ASSETS_CONTRACT.Proxy.Query(p);
JSON_PAGER_Contract jsonPager = new JSON_PAGER_Contract();
if (listHead == null)
{
throw new Exception("获取列表信息失败.");
}
jsonPager.head = listHead[0];
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "ASSETS_CODE";
CauseObject_MCE_B_ASSETS pd = new CauseObject_MCE_B_ASSETS();
pd.SetCustomCondition(" and MCE_B_ASSETS.ID in(select asset_id from MCE_B_ASSETS_CONTRACT_D where base_id='" + request["id"].ToString() + "')");
DisplayObject_MCE_B_ASSETS[] listDetail = BizLogicObject_MCE_B_ASSETS.Proxy.Query(pd, null, orderBy);
jsonPager.total = listDetail.Length;
jsonPager.rows = listDetail;
OrderByParameter orderByPay = new OrderByParameter();
orderByPay.Asc = true;
orderByPay.OrderBy = "PERIODS";
CauseObject_MCE_B_ASSETS_CONTRACT_PAY p_Pay = new CauseObject_MCE_B_ASSETS_CONTRACT_PAY();
p_Pay.BASE_ID = request["id"];
DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[] listPay = BizLogicObject_MCE_B_ASSETS_CONTRACT_PAY.Proxy.Query(p_Pay, null, orderByPay);
jsonPager.payRows = listPay;
OrderByParameter orderByAttach = new OrderByParameter();
orderByAttach.Asc = false;
orderByAttach.OrderBy = "CREATE_TIME";
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = request["id"];
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_CONTRACT";
List <JsonMCEMT_APPLY_MTN_ATTACH> list = new List <JsonMCEMT_APPLY_MTN_ATTACH>();
DisplayObject_COM_FILE[] listAttach = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE, null, orderByAttach);
if (listAttach != null && listAttach.Length > 0)
{
foreach (DisplayObject_COM_FILE item in listAttach)
{
JsonMCEMT_APPLY_MTN_ATTACH attach = new JsonMCEMT_APPLY_MTN_ATTACH();
attach.ID = item.ID;
attach.CLIENT_NAME = item.CLIENT_NAME;
attach.SERVER_NAME = item.SERVER_NAME;
attach.CREATE_USER_ID = item.CREATE_USER_ID;
if (!string.IsNullOrEmpty(attach.CREATE_USER_ID))
{
EntityObject_COM_USER entity = new EntityObject_COM_USER();
entity.ID = attach.CREATE_USER_ID;
entity = BizLogicObject_COM_USER.Proxy.Get(entity);
if (entity != null)
{
attach.CREATE_USER_ID_NAME = entity.NAME;
}
}
attach.CREATE_TIME = item.CREATE_TIME;
list.Add(attach);
}
}
jsonPager.attach = list;
jsonMsg.Succeed = 1;
jsonMsg.Message = jsonPager;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "CODE";
PagingParamter pager = new PagingParamter();
pager.PageSize = string.IsNullOrEmpty(request["limit"]) ? 10 : int.Parse(request["limit"].ToString());
pager.PageIndex = string.IsNullOrEmpty(request["offset"]) ? 0 : (int.Parse(request["offset"].ToString()) <= 0) ? 0 : int.Parse(request["offset"].ToString()) - 1;
CauseObject_MCE_B_ASSETS_METER_TYPE p = new CauseObject_MCE_B_ASSETS_METER_TYPE();
if (!string.IsNullOrEmpty(request["status"]))
{
p.STATE = int.Parse(request["status"].ToString());
}
if (!string.IsNullOrEmpty(request["condition"]))
{
string strCondition = " and (MCE_B_ASSETS_METER_TYPE.code like '%" + request["condition"] + "%' or MCE_B_ASSETS_METER_TYPE.name like '%" + request["condition"] + "%' )";
p.SetCustomCondition(strCondition);
}
else
{
if (!string.IsNullOrEmpty(request["code"]))
{
p.CODE = "%" + request["code"].ToString() + "%";
}
if (!string.IsNullOrEmpty(request["name"]))
{
p.NAME = "%" + request["name"].ToString() + "%";
}
}
DisplayObject_MCE_B_ASSETS_METER_TYPE[] list = BizLogicObject_MCE_B_ASSETS_METER_TYPE.Proxy.Query(p, pager, orderBy);
JSON_PAGER jsonPager = new JSON_PAGER();
jsonPager.total = pager.TotalRecords;
jsonPager.rows = list;
jsonMsg.Message = jsonPager;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public DisplayObject_V_MCE_QUERY_CONTRACT_PAY[] Query(CauseObject_V_MCE_QUERY_CONTRACT_PAY cause, PagingParamter paging, OrderByParameter order)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditQuery(cause);
//平台自动生成代码
return(HelperObject_V_MCE_QUERY_CONTRACT_PAY.Query(cause, paging, order));
}
else
{
using (ServiceManager <ServiceContract_V_MCE_QUERY_CONTRACT_PAY> smgr = new ServiceManager <ServiceContract_V_MCE_QUERY_CONTRACT_PAY>(ServiceUri))
{
return(smgr.Service.Query(cause, paging, order));
}
}
}
public static DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[] Query(CauseObject_MCE_B_ASSETS_CONTRACT_PAY cause, PagingParamter paging, OrderByParameter order, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_CONTRACT_PAY.PERIODS, MCE_B_ASSETS_CONTRACT_PAY.BASE_ID, MCE_B_ASSETS_CONTRACT_PAY.PLAN_PAY_DATE, MCE_B_ASSETS_CONTRACT_PAY.COMMENTS, MCE_B_ASSETS_CONTRACT_PAY.STATE, MCE_B_ASSETS_CONTRACT_PAY.MONEY, MCE_B_ASSETS_CONTRACT_PAY.ID, MCE_B_ASSETS_CONTRACT_PAY.ACTUAL_PAY_DATE, MCE_B_ASSETS_CONTRACT_BASE_ID.NAME as BASE_ID_NAME, (case when MCE_B_ASSETS_CONTRACT_PAY.STATE = 1 then '已付款' when MCE_B_ASSETS_CONTRACT_PAY.STATE = 2 then '未付款' else '' end ) as STATE_NAME from MCE_B_ASSETS_CONTRACT_PAY left join MCE_B_ASSETS_CONTRACT MCE_B_ASSETS_CONTRACT_BASE_ID on MCE_B_ASSETS_CONTRACT_PAY.BASE_ID = MCE_B_ASSETS_CONTRACT_BASE_ID.ID where (1=1)";
string sCauseSql = PrepareCause(cause, out parameters);
sSql += sCauseSql;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
sSql = "select t.* from (" + sSql + ") t,( select t." + cause.Recursion.TargetKeyFieldName + " from " + cause.Recursion.TargetDataObjectName + " t start with t." + cause.Recursion.TargetKeyFieldName + " = '" + cause.Recursion.RecursionFieldValue + "' connect by t." + cause.Recursion.TargetLevelFieldName + " = PRIOR t." + cause.Recursion.TargetKeyFieldName + " ) t1 where t." + cause.Recursion.RecursionFieldName + " = t1." + cause.Recursion.TargetKeyFieldName;
}
#region Push Block
if (paging != null)
{
string countSql = string.Empty;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
else
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
if (paging.TotalRecords == 0)
{
paging.TotalRecords = IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.SqlServer || IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.Db2? (int)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, trans) : (int)(decimal)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, trans);
}
sqlReader = IDALProvider.IDAL.ExecutePagingReader("MCE_B_ASSETS_CONTRACT_PAY", paging, order, sSql, parameters, trans);
}
else if (order != null)
{
sSql += order.ToString();
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
}
else
{
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
}
DisplayObject_MCE_B_ASSETS_CONTRACT_PAY dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_CONTRACT_PAY();
if (!sqlReader.IsDBNull(0))
{
dataObj.PERIODS = sqlReader.GetDecimal(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.BASE_ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.PLAN_PAY_DATE = sqlReader.GetDateTime(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.COMMENTS = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.STATE = sqlReader.GetDecimal(4);
}
if (!sqlReader.IsDBNull(5))
{
dataObj.MONEY = sqlReader.GetDecimal(5);
}
if (!sqlReader.IsDBNull(6))
{
dataObj.ID = sqlReader.GetString(6);
}
if (!sqlReader.IsDBNull(7))
{
dataObj.ACTUAL_PAY_DATE = sqlReader.GetDateTime(7);
}
if (!sqlReader.IsDBNull(8))
{
dataObj.BASE_ID_NAME = sqlReader.GetString(8);
}
if (!sqlReader.IsDBNull(9))
{
dataObj.STATE_NAME = sqlReader.GetString(9);
}
objArray.Add(dataObj);
}
sqlReader.Close();
#endregion
DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[] objs = new DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
string strIDS = "";
if (!string.IsNullOrEmpty(request["ids"]))
{
strIDS = request["ids"].ToString();
}
if (string.IsNullOrEmpty(strIDS))
{
throw new Exception("参数错误.");
}
string[] arrID = strIDS.Split(',');
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "assets_name";
CauseObject_MCE_B_AOG_D p = new CauseObject_MCE_B_AOG_D();
foreach (string strID in arrID)
{
p.SetINValue("BASE_ID", strID);
}
DisplayObject_MCE_B_AOG_D[] list = BizLogicObject_MCE_B_AOG_D.Proxy.Query(p);
if (list != null && list.Length > 0)
{
foreach (DisplayObject_MCE_B_AOG_D item in list)
{
item.USING_ID = "";
item.USING_PERSON = "";
if (!string.IsNullOrEmpty(item.BASE_ID))
{
CauseObject_MCE_B_AOG pHead = new CauseObject_MCE_B_AOG();
pHead.ID = item.BASE_ID;
DisplayObject_MCE_B_AOG[] listHead = BizLogicObject_MCE_B_AOG.Proxy.Query(pHead);
if (listHead != null && listHead.Length > 0)
{
item.USING_ID = listHead[0].USE_DEPT_ID;
item.USING_PERSON = listHead[0].USE_DEPT_ID_NAME;
}
}
}
}
jsonMsg.Message = list;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "CODE";
StringBuilder strCondition = new StringBuilder();
CauseObject_MCE_B_ASSETS_CONTRACT p = new CauseObject_MCE_B_ASSETS_CONTRACT();
p.ASSETS_ID = request["id"];
if (!string.IsNullOrEmpty(request["condition"]))//
{
strCondition.Append(" and (MCE_B_ASSETS_CONTRACT.CODE like '%" + request["condition"].ToString().Trim() + "%' or MDM_D_DEPT_SECOND_PARTY.NAME like '%" + request["condition"].ToString().Trim() + "%' or COM_DEPART_FIRST_PARTY.NAME like '%" + request["condition"].ToString().Trim() + "%' or COM_TYPE_TYPE_ID.NAME like '%" + request["condition"].ToString().Trim() + "%' )");
}
if (!string.IsNullOrEmpty(strCondition.ToString()))
{
p.SetCustomCondition(strCondition.ToString());
}
DisplayObject_MCE_B_ASSETS_CONTRACT[] list = BizLogicObject_MCE_B_ASSETS_CONTRACT.Proxy.Query(p, null, orderBy);
if (list != null && list.Length > 0)
{
foreach (DisplayObject_MCE_B_ASSETS_CONTRACT item in list)
{
string strFiles = "";
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = item.ID;
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_CONTRACT";
DisplayObject_COM_FILE[] listCOM_FILE = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE);
if (listCOM_FILE != null && listCOM_FILE.Length > 0)
{
foreach (DisplayObject_COM_FILE file in listCOM_FILE)
{
if (!string.IsNullOrEmpty(file.SERVER_NAME))
{
strFiles = strFiles + file.SERVER_NAME + "/" + file.CLIENT_NAME + ",";
}
}
strFiles = strFiles.TrimEnd(',');
}
item.BACKUP1 = strFiles;
}
}
jsonMsg.Message = list;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = false;
orderBy.OrderBy = "CODE";
PagingParamter pager = new PagingParamter();
pager.PageSize = string.IsNullOrEmpty(request["limit"]) ? 10 : int.Parse(request["limit"].ToString());
pager.PageIndex = string.IsNullOrEmpty(request["offset"]) ? 0 : (int.Parse(request["offset"].ToString()) <= 0) ? 0 : int.Parse(request["offset"].ToString()) - 1;
CauseObject_MCE_B_ASSETS_BACK p = new CauseObject_MCE_B_ASSETS_BACK();
if (!string.IsNullOrEmpty(request["status"]))
{
p.STATE = int.Parse(request["status"].ToString());
}
if (!string.IsNullOrEmpty(request["returndept"]))
{
p.RETURN_DEPT_ID = request["returndept"].ToString();
}
if (!string.IsNullOrEmpty(request["returnuser"]))
{
p.RETURN_USER_ID = request["returnuser"].ToString();
}
if (!string.IsNullOrEmpty(request["code"]))
{
p.CODE = "%" + request["code"].ToString() + "%";
}
if (!string.IsNullOrEmpty(request["prv"]))
{
var prv_ID = request["prv"];
p.SetCustomCondition(string.Format(" and MCE_B_ASSETS_BACK.ID in (select d.base_id from MCE_B_ASSETS_BACK_D d where d.assets_id in (select ID from mce_b_assets s2 where s2.provider_id='{0}' ))", prv_ID));
}
if (!string.IsNullOrEmpty(request["beginspan"]))
{
p.CREATE_DATE = new DateSpan();
p.CREATE_DATE.Begin = DateTime.Parse(request["beginspan"].ToString());
}
if (!string.IsNullOrEmpty(request["endspan"]))
{
if (p.CREATE_DATE == null)
{
p.CREATE_DATE = new DateSpan();
}
p.CREATE_DATE.End = DateTime.Parse(request["endspan"].ToString());
}
DisplayObject_MCE_B_ASSETS_BACK[] list = BizLogicObject_MCE_B_ASSETS_BACK.Proxy.Query(p, pager, orderBy);
JSON_PAGER jsonPager = new JSON_PAGER();
jsonPager.total = pager.TotalRecords;
jsonPager.rows = list;
jsonMsg.Message = jsonPager;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
CauseObject_MCE_B_ASSETS_WRITE_OFF p = new CauseObject_MCE_B_ASSETS_WRITE_OFF();
p.ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_WRITE_OFF[] listHead = BizLogicObject_MCE_B_ASSETS_WRITE_OFF.Proxy.Query(p);
JSON_PAGER_Write_Off jsonPager = new JSON_PAGER_Write_Off();
if (listHead == null)
{
throw new Exception("获取列表信息失败.");
}
jsonPager.head = listHead[0];
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "ASSETS_CODE";
CauseObject_MCE_B_ASSETS pd = new CauseObject_MCE_B_ASSETS();
pd.SetCustomCondition(" and MCE_B_ASSETS.ID in(select asset_id from MCE_B_ASSETS_WRITE_OFF_D where base_id='" + request["id"].ToString() + "')");
DisplayObject_MCE_B_ASSETS[] listDetail = BizLogicObject_MCE_B_ASSETS.Proxy.Query(pd, null, orderBy);
OrderByParameter orderByAttach = new OrderByParameter();
orderByAttach.Asc = false;
orderByAttach.OrderBy = "CREATE_DATE";
CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH pAttach = new CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
pAttach.BASE_ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] listAttach = BizLogicObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Proxy.Query(pAttach, null, orderByAttach);
jsonPager.total = listDetail.Length;
jsonPager.rows = listDetail;
jsonPager.attach = listAttach;
jsonMsg.Succeed = 1;
jsonMsg.Message = jsonPager;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = false;
orderBy.OrderBy = "CODE";
PagingParamter pager = new PagingParamter();
pager.PageSize = string.IsNullOrEmpty(request["limit"]) ? 10 : int.Parse(request["limit"].ToString());
pager.PageIndex = string.IsNullOrEmpty(request["offset"]) ? 0 : (int.Parse(request["offset"].ToString()) <= 0) ? 0 : int.Parse(request["offset"].ToString()) - 1;
CauseObject_MCE_B_ASSETS_METER p = new CauseObject_MCE_B_ASSETS_METER();
if (!string.IsNullOrEmpty(request["status"]))
{
p.STATE = int.Parse(request["status"].ToString());
}
if (!string.IsNullOrEmpty(request["dept"]))
{
p.USING_DEPT_ID = request["dept"].ToString();
}
if (!string.IsNullOrEmpty(request["asset"]))
{
p.ASSETS_ID = request["asset"].ToString();
}
if (!string.IsNullOrEmpty(request["meter_type"]))
{
p.METER_TYPE = request["meter_type"].ToString();
}
if (!string.IsNullOrEmpty(request["code"]))
{
p.CODE = "%" + request["code"].ToString() + "%";
}
if (!string.IsNullOrEmpty(request["beginspan"]))
{
p.NEXT_IDENTIFICATION = new DateSpan();
p.NEXT_IDENTIFICATION.Begin = DateTime.Parse(request["beginspan"].ToString());
}
if (!string.IsNullOrEmpty(request["endspan"]))
{
if (p.NEXT_IDENTIFICATION == null)
{
p.NEXT_IDENTIFICATION = new DateSpan();
}
p.NEXT_IDENTIFICATION.End = DateTime.Parse(request["endspan"].ToString());
}
DisplayObject_MCE_B_ASSETS_METER[] list = BizLogicObject_MCE_B_ASSETS_METER.Proxy.Query(p, pager, orderBy);
JSON_PAGER jsonPager = new JSON_PAGER();
jsonPager.total = pager.TotalRecords;
jsonPager.rows = list;
jsonMsg.Message = jsonPager;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
CauseObject_MCE_B_ASSETS_MT_EXEC p = new CauseObject_MCE_B_ASSETS_MT_EXEC();
p.ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_MT_EXEC[] listHead = BizLogicObject_MCE_B_ASSETS_MT_EXEC.Proxy.Query(p);
JSON_PAGER_MT_EXEC jsonPager = new JSON_PAGER_MT_EXEC();
if (listHead == null)
{
throw new Exception("获取列表信息失败.");
}
if (listHead[0].STATE <= 1 && listHead[0].ACTUAL_EXEC_DATE < DateTime.Now.AddYears(-100))
{
listHead[0].ACTUAL_EXEC_DATE = DateTime.Now;
}
jsonPager.head = listHead[0];
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "ASSETS_NAME";
CauseObject_MCE_B_ASSETS_MT_EXEC_D pd = new CauseObject_MCE_B_ASSETS_MT_EXEC_D();
pd.BASE_ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_MT_EXEC_D[] listDetail = BizLogicObject_MCE_B_ASSETS_MT_EXEC_D.Proxy.Query(pd, null, orderBy);
OrderByParameter orderByAttach = new OrderByParameter();
orderByAttach.Asc = false;
orderByAttach.OrderBy = "CREATE_TIME";
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = request["id"];
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_MT_EXEC";
List <JsonMCEMT_APPLY_MTN_ATTACH> list = new List <JsonMCEMT_APPLY_MTN_ATTACH>();
DisplayObject_COM_FILE[] listAttach = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE, null, orderByAttach);
if (listAttach != null && listAttach.Length > 0)
{
foreach (DisplayObject_COM_FILE item in listAttach)
{
JsonMCEMT_APPLY_MTN_ATTACH attach = new JsonMCEMT_APPLY_MTN_ATTACH();
attach.ID = item.ID;
attach.CLIENT_NAME = item.CLIENT_NAME;
attach.SERVER_NAME = item.SERVER_NAME;
attach.CREATE_USER_ID = item.CREATE_USER_ID;
if (!string.IsNullOrEmpty(attach.CREATE_USER_ID))
{
EntityObject_COM_USER entity = new EntityObject_COM_USER();
entity.ID = attach.CREATE_USER_ID;
entity = BizLogicObject_COM_USER.Proxy.Get(entity);
if (entity != null)
{
attach.CREATE_USER_ID_NAME = entity.NAME;
}
}
attach.CREATE_TIME = item.CREATE_TIME;
list.Add(attach);
}
}
jsonPager.attach = list;
jsonPager.total = listDetail.Length;
jsonPager.rows = listDetail;
jsonMsg.Succeed = 1;
jsonMsg.Message = jsonPager;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
context.Response.Write(strMsg);
context.Response.End();
}
}
public DisplayObject_MCE_B_ASSETS_OUTSTOCK[] Query(CauseObject_MCE_B_ASSETS_OUTSTOCK cause, PagingParamter paging, OrderByParameter order)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditQuery(cause);
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_OUTSTOCK.Query(cause, paging, order));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_OUTSTOCK> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_OUTSTOCK>(ServiceUri))
{
return(smgr.Service.Query(cause, paging, order));
}
}
}
public static DisplayObject_MCE_B_ASSETS_MT_APPLY_EN[] Query(CauseObject_MCE_B_ASSETS_MT_APPLY_EN cause, PagingParamter paging, OrderByParameter order)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_MT_APPLY_EN.ADVISE, MCE_B_ASSETS_MT_APPLY_EN.BASE_ID, MCE_B_ASSETS_MT_APPLY_EN.RESULT, MCE_B_ASSETS_MT_APPLY_EN.COMMENTS, MCE_B_ASSETS_MT_APPLY_EN.USER_ID, MCE_B_ASSETS_MT_APPLY_EN.COMPLETE_TIME, MCE_B_ASSETS_MT_APPLY_EN.ID, MCE_B_ASSETS_MT_APPLY_EN.HOURS, MCE_B_ASSETS_MT_APPLY_EN.IS_CLOSE, MCE_B_ASSETS_MT_APPLY_BASE_ID.CODE as BASE_ID_NAME, COM_USER_USER_ID.NAME as USER_ID_NAME from MCE_B_ASSETS_MT_APPLY_EN left join MCE_B_ASSETS_MT_APPLY MCE_B_ASSETS_MT_APPLY_BASE_ID on MCE_B_ASSETS_MT_APPLY_EN.BASE_ID = MCE_B_ASSETS_MT_APPLY_BASE_ID.ID left join COM_USER COM_USER_USER_ID on MCE_B_ASSETS_MT_APPLY_EN.USER_ID = COM_USER_USER_ID.ID where (1=1)";
string sCauseSql = PrepareCause(cause, out parameters);
sSql += sCauseSql;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
sSql = "select t.* from (" + sSql + ") t,( select t." + cause.Recursion.TargetKeyFieldName + " from " + cause.Recursion.TargetDataObjectName + " t start with t." + cause.Recursion.TargetKeyFieldName + " = '" + cause.Recursion.RecursionFieldValue + "' connect by t." + cause.Recursion.TargetLevelFieldName + " = PRIOR t." + cause.Recursion.TargetKeyFieldName + " ) t1 where t." + cause.Recursion.RecursionFieldName + " = t1." + cause.Recursion.TargetKeyFieldName;
}
#region Push Block
IDbConnection connection = IDALProvider.IDAL.PopConnection();
if (paging != null)
{
string countSql = string.Empty;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
else
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
if (paging.TotalRecords == 0)
{
paging.TotalRecords = IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.SqlServer ? (int)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, connection) : (int)(decimal)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, connection);
}
sqlReader = IDALProvider.IDAL.ExecutePagingReader("MCE_B_ASSETS_MT_APPLY_EN", paging, order, sSql, parameters, connection);
}
else if (order != null)
{
sSql += order.ToString();
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
}
else
{
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
}
DisplayObject_MCE_B_ASSETS_MT_APPLY_EN dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_MT_APPLY_EN();
if (!sqlReader.IsDBNull(0))
{
dataObj.ADVISE = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.BASE_ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.RESULT = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.COMMENTS = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.USER_ID = sqlReader.GetString(4);
}
if (!sqlReader.IsDBNull(5))
{
dataObj.COMPLETE_TIME = sqlReader.GetDateTime(5);
}
if (!sqlReader.IsDBNull(6))
{
dataObj.ID = sqlReader.GetString(6);
}
if (!sqlReader.IsDBNull(7))
{
dataObj.HOURS = sqlReader.GetDecimal(7);
}
if (!sqlReader.IsDBNull(8))
{
dataObj.IS_CLOSE = sqlReader.GetDecimal(8);
}
if (!sqlReader.IsDBNull(9))
{
dataObj.BASE_ID_NAME = sqlReader.GetString(9);
}
if (!sqlReader.IsDBNull(10))
{
dataObj.USER_ID_NAME = sqlReader.GetString(10);
}
objArray.Add(dataObj);
}
sqlReader.Close();
IDALProvider.IDAL.PushConnection(connection);
#endregion
DisplayObject_MCE_B_ASSETS_MT_APPLY_EN[] objs = new DisplayObject_MCE_B_ASSETS_MT_APPLY_EN[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
