public int DeleteByTrans2(CauseObject_MCE_B_ASSETS_MT_APPLY cause, IDbTransaction transaction)
{
if (LocalMode)
{
return(HelperObject_MCE_B_ASSETS_MT_APPLY.Delete(cause, transaction));
//平台自动生成代码
}
else
{
throw new InvalidConstraintException();
}
}
public DisplayObject_MCE_B_ASSETS_MT_APPLY[] Query(CauseObject_MCE_B_ASSETS_MT_APPLY cause, PagingParamter paging, OrderByParameter order)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditQuery(cause);
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_MT_APPLY.Query(cause, paging, order));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Query(cause, paging, order));
}
}
}
public BizLogicMsg Delete(CauseObject_MCE_B_ASSETS_MT_APPLY cause)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
int amount = HelperObject_MCE_B_ASSETS_MT_APPLY.Delete(cause, transaction);
//平台自动生成代码
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Delete(cause));
}
}
}
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_MT_APPLY p = new CauseObject_MCE_B_ASSETS_MT_APPLY();
p.ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_MT_APPLY[] listHead = BizLogicObject_MCE_B_ASSETS_MT_APPLY.Proxy.Query(p);
JSON_PAGER_APPLY_MTN_ATTACH jsonPager = new JSON_PAGER_APPLY_MTN_ATTACH();
if (listHead == null)
{
throw new Exception("获取列表信息失败.");
}
jsonPager.head = listHead[0];
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_APPLY";
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;
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
StringBuilder strCondition = new StringBuilder();
CauseObject_MCE_B_ASSETS_MT_APPLY p = new CauseObject_MCE_B_ASSETS_MT_APPLY();
p.ASSETS_ID = request["id"];
if (!string.IsNullOrEmpty(request["condition"]))//
{
strCondition.Append(" and (MCE_B_ASSETS_MT_APPLY.CODE like '%" + request["condition"].ToString().Trim() + "%' )");
}
if (!string.IsNullOrEmpty(strCondition.ToString()))
{
p.SetCustomCondition(strCondition.ToString());
}
DisplayObject_MCE_B_ASSETS_MT_APPLY[] list = BizLogicObject_MCE_B_ASSETS_MT_APPLY.Proxy.Query(p);
if (list != null && list.Length > 0)
{
foreach (DisplayObject_MCE_B_ASSETS_MT_APPLY item in list)
{
string strMtn_User = "";
CauseObject_MCE_B_ASSETS_MT_APPLY_EN pMCE_B_ASSETS_MT_APPLY_EN = new CauseObject_MCE_B_ASSETS_MT_APPLY_EN();
pMCE_B_ASSETS_MT_APPLY_EN.BASE_ID = item.ID;
DisplayObject_MCE_B_ASSETS_MT_APPLY_EN[] listMCE_B_ASSETS_MT_APPLY_EN = BizLogicObject_MCE_B_ASSETS_MT_APPLY_EN.Proxy.Query(pMCE_B_ASSETS_MT_APPLY_EN);
if (listMCE_B_ASSETS_MT_APPLY_EN != null && listMCE_B_ASSETS_MT_APPLY_EN.Length > 0)
{
strMtn_User = listMCE_B_ASSETS_MT_APPLY_EN[0].USER_ID_NAME;
}
item.COMMENTS = strMtn_User;
}
}
else
{
list = new DisplayObject_MCE_B_ASSETS_MT_APPLY[1];
DisplayObject_MCE_B_ASSETS_MT_APPLY item = new DisplayObject_MCE_B_ASSETS_MT_APPLY();
list[0] = item;
}
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 = 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_MT_APPLY p = new CauseObject_MCE_B_ASSETS_MT_APPLY();
if (!string.IsNullOrEmpty(request["status"]))
{
p.STATE = int.Parse(request["status"].ToString());
}
if (!string.IsNullOrEmpty(request["dept"]))
{
p.APPLY_DEPT_ID = request["dept"].ToString();
}
if (!string.IsNullOrEmpty(request["asset"]))
{
p.ASSETS_ID = request["asset"].ToString();
}
if (!string.IsNullOrEmpty(request["mtn_type_id"]))
{
p.MTN_TYPE_ID = request["mtn_type_id"].ToString();
}
if (!string.IsNullOrEmpty(request["code"]))
{
p.CODE = "%" + request["code"].ToString() + "%";
}
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_MT_APPLY[] list = BizLogicObject_MCE_B_ASSETS_MT_APPLY.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();
}
}
