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