/// <summary>
/// 保存期刊订阅
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult SaveIssueSubscribe(IssueSubscribeEntity model)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post <ExecResult, IssueSubscribeEntity>(GetAPIUrl(APIConstant.ISSUESUBSCRIBE_SAVE), model);
return(result);
}
/// <summary>
/// 获取期刊订阅实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IssueSubscribeEntity GetIssueSubscribeModel(IssueSubscribeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IssueSubscribeEntity model = clientHelper.Post <IssueSubscribeEntity, IssueSubscribeQuery>(GetAPIUrl(APIConstant.ISSUESUBSCRIBE_GETMODEL), query);
return(model);
}
public IssueSubscribeEntity GetIssueSubscribeModel(IssueSubscribeQuery query)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve <IIssueService>();
IssueSubscribeEntity model = service.GetIssueSubscribe(query.subscribeID);
return(model);
}
public ActionResult SaveIssueSubscribe(IssueSubscribeEntity model)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve <IIssueFacadeService>();
model.JournalID = CurAuthor.JournalID;
ExecResult result = service.SaveIssueSubscribe(model);
return(Json(new { result = result.result, msg = result.msg }));
}
private IssueSubscribeEntity GetIssueSubscribeModel(Int64 subscribeID)
{
IssueSubscribeEntity model = null;
if (subscribeID > 0)
{
IssueSubscribeQuery query = new IssueSubscribeQuery();
query.JournalID = CurAuthor.JournalID;
query.subscribeID = subscribeID;
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve <IIssueFacadeService>();
model = service.GetIssueSubscribeModel(query);
}
if (model == null)
{
model = new IssueSubscribeEntity();
}
return(model);
}
public ActionResult AddSubscriptionInfo(IssueSubscribeEntity issueSubscribeEntity)
{
ExecResult execResult = new ExecResult();
try
{
if (issueSubscribeEntity != null)
{
issueSubscribeEntity.JournalID = JournalID;
IIssueFacadeService issueService = ServiceContainer.Instance.Container.Resolve <IIssueFacadeService>();
execResult = issueService.SaveIssueSubscribe(issueSubscribeEntity);
}
}
catch (Exception ex)
{
execResult.result = EnumJsonResult.error.ToString();
execResult.msg = "在线订阅出现异常：" + ex.Message;
WKT.Log.LogProvider.Instance.Error("在线订阅出现异常：" + ex.Message);
}
return(Content(JsonConvert.SerializeObject(execResult)));
}
public ActionResult AddSubscriptionInfo(IssueSubscribeEntity issueSubscribeEntity)
{
ExecResult execResult = new ExecResult();
try
{
if (issueSubscribeEntity != null)
{
issueSubscribeEntity.JournalID = JournalID;
IIssueFacadeService issueService = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
execResult = issueService.SaveIssueSubscribe(issueSubscribeEntity);
}
}
catch (Exception ex)
{
execResult.result = EnumJsonResult.error.ToString();
execResult.msg = "在线订阅出现异常：" + ex.Message;
WKT.Log.LogProvider.Instance.Error("在线订阅出现异常：" + ex.Message);
}
return Content(JsonConvert.SerializeObject(execResult));
}
/// <summary>
/// 保存期刊订阅
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult SaveIssueSubscribe(IssueSubscribeEntity model)
{
ExecResult execResult = new ExecResult();
bool result = false;
model.Subscriber = model.Subscriber.TextFilter();
model.Mobile = model.Mobile.TextFilter();
model.Tel = model.Tel.TextFilter();
model.Fax = model.Fax.TextFilter();
model.Email = model.Email.TextFilter();
model.Address = model.Address.TextFilter();
model.ZipCode = model.ZipCode.TextFilter();
model.ContactUser = model.ContactUser.TextFilter();
model.SubscribeInfo = model.SubscribeInfo.TextFilter();
model.InvoiceHead = model.InvoiceHead.TextFilter();
model.Note = model.Note.TextFilter();
if (model.SubscribeID == 0)
{
result = AddIssueSubscribe(model);
}
else
{
result = UpdateIssueSubscribe(model);
}
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "保存期刊订阅成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "保存期刊订阅失败！";
}
return(execResult);
}
/// <summary>
/// 编辑期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool UpdateIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" SubscribeID=@SubscribeID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" Subscriber=@Subscriber");
sqlCommandText.Append(", Mobile=@Mobile");
sqlCommandText.Append(", Tel=@Tel");
sqlCommandText.Append(", Fax=@Fax");
sqlCommandText.Append(", Email=@Email");
sqlCommandText.Append(", Address=@Address");
sqlCommandText.Append(", ZipCode=@ZipCode");
sqlCommandText.Append(", ContactUser=@ContactUser");
sqlCommandText.Append(", SubscribeInfo=@SubscribeInfo");
sqlCommandText.Append(", IsInvoice=@IsInvoice");
sqlCommandText.Append(", InvoiceHead=@InvoiceHead");
sqlCommandText.Append(", Note=@Note");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.IssueSubscribe SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@SubscribeID", DbType.Int64, issueSubscribeEntity.SubscribeID);
db.AddInParameter(cmd, "@Subscriber", DbType.AnsiString, issueSubscribeEntity.Subscriber);
db.AddInParameter(cmd, "@Mobile", DbType.AnsiString, issueSubscribeEntity.Mobile);
db.AddInParameter(cmd, "@Tel", DbType.AnsiString, issueSubscribeEntity.Tel);
db.AddInParameter(cmd, "@Fax", DbType.AnsiString, issueSubscribeEntity.Fax);
db.AddInParameter(cmd, "@Email", DbType.AnsiString, issueSubscribeEntity.Email);
db.AddInParameter(cmd, "@Address", DbType.AnsiString, issueSubscribeEntity.Address);
db.AddInParameter(cmd, "@ZipCode", DbType.AnsiString, issueSubscribeEntity.ZipCode);
db.AddInParameter(cmd, "@ContactUser", DbType.AnsiString, issueSubscribeEntity.ContactUser);
db.AddInParameter(cmd, "@SubscribeInfo", DbType.AnsiString, issueSubscribeEntity.SubscribeInfo);
db.AddInParameter(cmd, "@IsInvoice", DbType.Boolean, issueSubscribeEntity.IsInvoice);
db.AddInParameter(cmd, "@InvoiceHead", DbType.AnsiString, issueSubscribeEntity.InvoiceHead);
db.AddInParameter(cmd, "@Note", DbType.AnsiString, issueSubscribeEntity.Note);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return flag;
}
/// <summary>
/// 新增期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool AddIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @JournalID");
sqlCommandText.Append(", @Subscriber");
sqlCommandText.Append(", @Mobile");
sqlCommandText.Append(", @Tel");
sqlCommandText.Append(", @Fax");
sqlCommandText.Append(", @Email");
sqlCommandText.Append(", @Address");
sqlCommandText.Append(", @ZipCode");
sqlCommandText.Append(", @ContactUser");
sqlCommandText.Append(", @SubscribeInfo");
sqlCommandText.Append(", @IsInvoice");
sqlCommandText.Append(", @InvoiceHead");
sqlCommandText.Append(", @Note");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.IssueSubscribe ({0},SubscribeDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, issueSubscribeEntity.JournalID);
db.AddInParameter(cmd, "@Subscriber", DbType.AnsiString, issueSubscribeEntity.Subscriber.TextFilter());
db.AddInParameter(cmd, "@Mobile", DbType.AnsiString, issueSubscribeEntity.Mobile);
db.AddInParameter(cmd, "@Tel", DbType.AnsiString, issueSubscribeEntity.Tel.TextFilter());
db.AddInParameter(cmd, "@Fax", DbType.AnsiString, issueSubscribeEntity.Fax.TextFilter());
db.AddInParameter(cmd, "@Email", DbType.AnsiString, issueSubscribeEntity.Email.TextFilter());
db.AddInParameter(cmd, "@Address", DbType.AnsiString, issueSubscribeEntity.Address.TextFilter());
db.AddInParameter(cmd, "@ZipCode", DbType.AnsiString, issueSubscribeEntity.ZipCode.TextFilter());
db.AddInParameter(cmd, "@ContactUser", DbType.AnsiString, issueSubscribeEntity.ContactUser.TextFilter());
db.AddInParameter(cmd, "@SubscribeInfo", DbType.AnsiString, issueSubscribeEntity.SubscribeInfo.TextFilter());
db.AddInParameter(cmd, "@IsInvoice", DbType.Boolean, issueSubscribeEntity.IsInvoice);
db.AddInParameter(cmd, "@InvoiceHead", DbType.AnsiString, issueSubscribeEntity.InvoiceHead.TextFilter());
db.AddInParameter(cmd, "@Note", DbType.AnsiString, issueSubscribeEntity.Note.TextFilter());
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return flag;
}
/// <summary>
/// 新增期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool AddIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
return IssueDataAccess.Instance.AddIssueSubscribe(issueSubscribeEntity);
}
/// <summary>
/// 编辑期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool UpdateIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
return IssueDataAccess.Instance.UpdateIssueSubscribe(issueSubscribeEntity);
}
private IssueSubscribeEntity GetIssueSubscribeModel(Int64 subscribeID)
{
IssueSubscribeEntity model = null;
if (subscribeID > 0)
{
IssueSubscribeQuery query = new IssueSubscribeQuery();
query.JournalID = CurAuthor.JournalID;
query.subscribeID = subscribeID;
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
model = service.GetIssueSubscribeModel(query);
}
if (model == null)
model = new IssueSubscribeEntity();
return model;
}
public ActionResult SaveIssueSubscribe(IssueSubscribeEntity model)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
model.JournalID = CurAuthor.JournalID;
ExecResult result = service.SaveIssueSubscribe(model);
return Json(new { result = result.result, msg = result.msg });
}
/// <summary>
/// 保存期刊订阅
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult SaveIssueSubscribe(IssueSubscribeEntity model)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, IssueSubscribeEntity>(GetAPIUrl(APIConstant.ISSUESUBSCRIBE_SAVE), model);
return result;
}
/// <summary>
/// 新增期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool AddIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
return(IssueDataAccess.Instance.AddIssueSubscribe(issueSubscribeEntity));
}
/// <summary>
/// 组装期刊订阅数据
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private IssueSubscribeEntity MakeIssueSubscribe(IDataReader dr)
{
IssueSubscribeEntity issueSubscribeEntity = new IssueSubscribeEntity();
issueSubscribeEntity.SubscribeID = (Int64)dr["SubscribeID"];
issueSubscribeEntity.JournalID = (Int64)dr["JournalID"];
issueSubscribeEntity.Subscriber = (String)dr["Subscriber"];
issueSubscribeEntity.Mobile = (String)dr["Mobile"];
issueSubscribeEntity.Tel = (String)dr["Tel"];
issueSubscribeEntity.Fax = (String)dr["Fax"];
issueSubscribeEntity.Email = (String)dr["Email"];
issueSubscribeEntity.Address = (String)dr["Address"];
issueSubscribeEntity.ZipCode = (String)dr["ZipCode"];
issueSubscribeEntity.ContactUser = (String)dr["ContactUser"];
issueSubscribeEntity.SubscribeInfo = (String)dr["SubscribeInfo"];
issueSubscribeEntity.IsInvoice = (Boolean)dr["IsInvoice"];
issueSubscribeEntity.InvoiceHead = (String)dr["InvoiceHead"];
issueSubscribeEntity.Note = (String)dr["Note"];
issueSubscribeEntity.SubscribeDate = (DateTime)dr["SubscribeDate"];
return issueSubscribeEntity;
}
/// <summary>
/// 编辑期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool UpdateIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
return(IssueDataAccess.Instance.UpdateIssueSubscribe(issueSubscribeEntity));
}
/// <summary>
/// 新增期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool AddIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
return IssueBusProvider.AddIssueSubscribe(issueSubscribeEntity);
}
/// <summary>
/// 保存期刊订阅
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult SaveIssueSubscribe(IssueSubscribeEntity model)
{
ExecResult execResult = new ExecResult();
bool result = false;
model.Subscriber = model.Subscriber.TextFilter();
model.Mobile = model.Mobile.TextFilter();
model.Tel = model.Tel.TextFilter();
model.Fax = model.Fax.TextFilter();
model.Email = model.Email.TextFilter();
model.Address = model.Address.TextFilter();
model.ZipCode = model.ZipCode.TextFilter();
model.ContactUser = model.ContactUser.TextFilter();
model.SubscribeInfo = model.SubscribeInfo.TextFilter();
model.InvoiceHead = model.InvoiceHead.TextFilter();
model.Note = model.Note.TextFilter();
if (model.SubscribeID == 0)
result = AddIssueSubscribe(model);
else
result = UpdateIssueSubscribe(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "保存期刊订阅成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "保存期刊订阅失败！";
}
return execResult;
}
/// <summary>
/// 编辑期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool UpdateIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
return IssueBusProvider.UpdateIssueSubscribe(issueSubscribeEntity);
}
public ExecResult SaveIssueSubscribe(IssueSubscribeEntity model)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
return service.SaveIssueSubscribe(model);
}
/// <summary>
/// 新增期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool AddIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
return(IssueBusProvider.AddIssueSubscribe(issueSubscribeEntity));
}
public ExecResult SaveIssueSubscribe(IssueSubscribeEntity model)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve <IIssueService>();
return(service.SaveIssueSubscribe(model));
}
/// <summary>
/// 编辑期刊订阅
/// </summary>
/// <param name="issueSubscribeEntity"></param>
/// <returns></returns>
public bool UpdateIssueSubscribe(IssueSubscribeEntity issueSubscribeEntity)
{
return(IssueBusProvider.UpdateIssueSubscribe(issueSubscribeEntity));
}
