public void GetSubscriptionProperty(HttpContext context, long sid, string propertyName) { var sub = new crm_subscription_dal().GetSubscription(sid); if (sub != null) { context.Response.Write(BaseDAL <Core.crm_account> .GetObjectPropertyValue(sub, propertyName)); } }
/// <summary> /// 撤销订阅审批 /// </summary> /// <param name="user_id"></param> /// <param name="ids"></param> /// <returns></returns> public ERROR_CODE Revoke_Subscriptions(long user_id, string ids, out string re) { re = string.Empty; StringBuilder returnvalue = new StringBuilder(); var user = UserInfoBLL.GetUserInfo(user_id); if (user == null) { // 查询不到用户,用户丢失 return(ERROR_CODE.USER_NOT_FIND); } crm_account_deduction cad = new crm_account_deduction(); crm_subscription cs = new crm_subscription(); //订阅表 crm_subscription_period csp = new crm_subscription_period(); //订阅周期表 crm_subscription_dal cs_dal = new crm_subscription_dal(); crm_subscription_period_dal csp_dal = new crm_subscription_period_dal(); if (!string.IsNullOrEmpty(ids)) { var idList = ids.Split(','); foreach (var id in idList) { var oldcad = cad = GetAccountDed(long.Parse(id)); if (cad.invoice_id != null) { var ci = new ctt_invoice_dal().FindNoDeleteById((long)cad.invoice_id); if (ci.is_voided != 1) { returnvalue.Append(id + "条目已经生成发票(发票ID:" + cad.invoice_id + "),请先作废该发票\n"); } } else { cad.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); cad.delete_user_id = user.id; // 插入日志 var add1_log = new sys_oper_log() { user_cate = "用户", user_id = (int)user.id, name = user.name, phone = user.mobile == null ? "" : user.mobile, oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now), oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ACCOUNT_DEDUCTION, oper_object_id = cad.id,// 操作对象id oper_type_id = (int)OPER_LOG_TYPE.DELETE, oper_description = cad_dal.CompareValue(oldcad, cad), remark = "删除审批并提交" }; // 创建日志 new sys_oper_log_dal().Insert(add1_log); // 插入日志 if (!cad_dal.Update(cad)) { return(ERROR_CODE.ERROR); } else { } } //订阅 if (cad.object_id != null) { var oldcsp = csp = csp_dal.FindSignleBySql <crm_subscription_period>($"select * from crm_subscription_period where id={cad.object_id}"); cs = cs_dal.FindNoDeleteById(csp.subscription_id); csp.approve_and_post_user_id = null; csp.approve_and_post_date = null; csp.period_price = cs.period_price; var add_log = new sys_oper_log() { user_cate = "用户", user_id = (int)user.id, name = user.name, phone = user.mobile == null ? "" : user.mobile, oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now), oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SUBSCRIPTION_PERIOD, //订阅周期 oper_object_id = csp.id, // 操作对象id oper_type_id = (int)OPER_LOG_TYPE.UPDATE, oper_description = cad_dal.CompareValue(oldcsp, csp), remark = "修改订阅周期" }; // 创建日志 new sys_oper_log_dal().Insert(add_log); // 插入日志 if (!csp_dal.Update(csp)) { return(ERROR_CODE.ERROR); } } } } if (!string.IsNullOrEmpty(returnvalue.ToString())) { re = returnvalue.ToString(); return(ERROR_CODE.EXIST); } return(ERROR_CODE.SUCCESS); }