private string GetInsuranceCode() { string strInsuranceCode = ""; 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_INSURANCE(); cause.SetCustomCondition(" and MCE_B_ASSETS_INSURANCE.CODE like '" + strCode + "%'"); var list = BizLogicObject_MCE_B_ASSETS_INSURANCE.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; } strInsuranceCode = strCode + (code).ToString().PadLeft(3, '0'); return(strInsuranceCode); }
public int DeleteByTrans2(CauseObject_MCE_B_ASSETS_INSURANCE cause, IDbTransaction transaction) { if (LocalMode) { return(HelperObject_MCE_B_ASSETS_INSURANCE.Delete(cause, transaction)); //平台自动生成代码 } else { throw new InvalidConstraintException(); } }
public DisplayObject_MCE_B_ASSETS_INSURANCE[] Query(CauseObject_MCE_B_ASSETS_INSURANCE cause, PagingParamter paging, OrderByParameter order) { if (LocalMode) { SystemLogic.Proxy.AuditQuery(cause); //平台自动生成代码 return(HelperObject_MCE_B_ASSETS_INSURANCE.Query(cause, paging, order)); } else { using (ServiceManager <ServiceContract_MCE_B_ASSETS_INSURANCE> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_INSURANCE>(ServiceUri)) { return(smgr.Service.Query(cause, paging, order)); } } }
public BizLogicMsg Delete(CauseObject_MCE_B_ASSETS_INSURANCE 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_INSURANCE.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_INSURANCE> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_INSURANCE>(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("参数错误."); } OrderByParameter orderBy = new OrderByParameter(); orderBy.Asc = true; orderBy.OrderBy = "CODE"; StringBuilder strCondition = new StringBuilder(); CauseObject_MCE_B_ASSETS_INSURANCE p = new CauseObject_MCE_B_ASSETS_INSURANCE(); p.ASSETS_ID = request["id"]; if (!string.IsNullOrEmpty(request["condition"]))// { strCondition.Append(" and (MCE_B_ASSETS_INSURANCE.CODE like '%" + request["condition"].ToString().Trim() + "%' or MCE_B_ASSETS_INSURANCE.NAME like '%" + request["condition"].ToString().Trim() + "%' or MDM_D_DEPT_INSURANCE_UNIT.NAME like '%" + request["condition"].ToString().Trim() + "%' )"); } if (!string.IsNullOrEmpty(strCondition.ToString())) { p.SetCustomCondition(strCondition.ToString()); } DisplayObject_MCE_B_ASSETS_INSURANCE[] list = BizLogicObject_MCE_B_ASSETS_INSURANCE.Proxy.Query(p, null, orderBy); if (list != null && list.Length > 0) { foreach (DisplayObject_MCE_B_ASSETS_INSURANCE 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_INSURANCE"; 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(); } }