public crm_subscription GetParam()
{
var id = subscription == null ? 0 : subscription.id;
subscription = AssembleModel <crm_subscription>();
//subscription.status_id = isActive.Checked ? 1 : 0;/
if (!isAdd)
{
subscription.id = id;
}
return(subscription);
}
/// <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);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
#region 拉框配数据源
period_type_id.DataTextField = "show";
period_type_id.DataValueField = "val";
period_type_id.DataSource = dic.FirstOrDefault(_ => _.Key == "period_type").Value;
period_type_id.DataBind();
period_type_id.Items.Insert(0, new ListItem()
{
Value = "0", Text = " ", Selected = true
});
#endregion
var iProduct_id = Request.QueryString["insProId"];
if (!string.IsNullOrEmpty(iProduct_id))
{
iProduct = new crm_installed_product_dal().GetInstalledProduct(long.Parse(iProduct_id));
}
var id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
subscription = new crm_subscription_dal().GetSubscription(long.Parse(id));
iProduct = new crm_installed_product_dal().GetInstalledProduct(subscription.installed_product_id);
period_type_id.SelectedValue = subscription.period_type_id.ToString();
// period_type_id.Enabled = false;
isAdd = false;
subPeriodList = new crm_subscription_period_dal().GetSubPeriodByWhere($" and subscription_id = {subscription.id}");
}
if (iProduct == null)
{
Response.End();
}
if (!IsPostBack)
{
if (subscription != null)
{
if (subscription.status_id != 1)
{
status_id.SelectedValue = subscription.status_id.ToString();
}
else
{
status_id.SelectedValue = "1";
}
}
else
{
status_id.SelectedValue = "1";
}
}
}
catch (Exception)
{
Response.End();
}
}