public ActionResult GetList(ContactWayQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList<ContactWayEntity> list = service.GetContactWayList(query);
return Json(new { list });
}
public ExecResult Del(ContactWayQuery query)
{
ExecResult execResult = new ExecResult();
IContactWayService service = ServiceContainer.Instance.Container.Resolve<IContactWayService>();
Int64[] ContactIDs = query.ContactIDs;
if (ContactIDs == null)
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "没有删除任何数据！";
return execResult;
}
string msg = string.Empty;
bool result = service.BatchDeleteContactWay(ContactIDs);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "删除联系人成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "删除联系人失败！";
}
return execResult;
}
public ActionResult Delete(Int64[] ContactIDs)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
ContactWayQuery query = new ContactWayQuery();
query.JournalID = CurAuthor.JournalID;
query.ContactIDs = ContactIDs;
ExecResult result = service.DelContactWay(query);
return Json(new { result = result.result, msg = result.msg });
}
public ActionResult GetPageList(ContactWayQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.CurrentPage = Convert.ToInt32(Request.Params["page"]);
query.PageSize = Convert.ToInt32(Request.Params["pagesize"]);
Pager<ContactWayEntity> pager = service.GetContactWayPageList(query);
return Json(new { Rows = pager.ItemList, Total = pager.TotalRecords });
}
private ContactWayEntity GetModel(Int64 ContactID)
{
ContactWayEntity model = null;
if (ContactID > 0)
{
ContactWayQuery query = new ContactWayQuery();
query.JournalID = CurAuthor.JournalID;
query.ContactID = ContactID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
model = service.GetContactWayModel(query);
}
if (model == null)
model = new ContactWayEntity();
return model;
}
public Pager<ContactWayEntity> GetPageList(ContactWayQuery query)
{
IContactWayService service = ServiceContainer.Instance.Container.Resolve<IContactWayService>();
Pager<ContactWayEntity> pager = service.GetContactWayPageList(query);
return pager;
}
public ContactWayEntity GetModel(ContactWayQuery query)
{
IContactWayService service = ServiceContainer.Instance.Container.Resolve<IContactWayService>();
ContactWayEntity model = service.GetContactWay(query.ContactID);
return model;
}
public IList<ContactWayEntity> GetList(ContactWayQuery query)
{
IContactWayService service = ServiceContainer.Instance.Container.Resolve<IContactWayService>();
IList<ContactWayEntity> list = service.GetContactWayList(query);
return list;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="contactWayQuery">ContactWayQuery查询实体对象</param>
/// <returns>Pager<ContactWayEntity></returns>
public Pager<ContactWayEntity> GetContactWayPageList(ContactWayQuery contactWayQuery)
{
return ContactWayBusProvider.GetContactWayPageList(contactWayQuery);
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string ContactWayQueryToSQLWhere(ContactWayQuery query)
{
StringBuilder strFilter = new StringBuilder();
strFilter.Append(" 1=1");
if (query.JournalID > 0)
strFilter.AppendFormat(" and JournalID={0}", query.JournalID);
if(query.ChannelID>0)
strFilter.AppendFormat(" and ChannelID={0}", query.ChannelID);
return strFilter.ToString();
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string ContactWayQueryToSQLOrder(ContactWayQuery query)
{
return " ContactID DESC";
}
/// <summary>
/// 删除联系人
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult DelContactWay(ContactWayQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, ContactWayQuery>(GetAPIUrl(APIConstant.ContactWay_DEL), query);
return result;
}
/// <summary>
/// 获取联系人分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<ContactWayEntity> GetContactWayPageList(ContactWayQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager<ContactWayEntity> pager = clientHelper.Post<Pager<ContactWayEntity>, ContactWayQuery>(GetAPIUrl(APIConstant.ContactWay_GETPAGELIST), query);
return pager;
}
/// <summary>
/// 获取联系人实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ContactWayEntity GetContactWayModel(ContactWayQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ContactWayEntity model = clientHelper.Post<ContactWayEntity, ContactWayQuery>(GetAPIUrl(APIConstant.ContactWay_GETMODEL), query);
return model;
}
/// <summary>
/// 获取联系人数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<ContactWayEntity> GetContactWayList(ContactWayQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IList<ContactWayEntity> list = clientHelper.Post<IList<ContactWayEntity>, ContactWayQuery>(GetAPIUrl(APIConstant.ContactWay_GETLIST), query);
return list;
}
public List<ContactWayEntity> GetContactWayList(ContactWayQuery query)
{
string strSql = "SELECT ContactID,JournalID,ChannelID,Company,LinkMan,Address,ZipCode,Tel,Fax,AddDate FROM dbo.ContactWay with(nolock) ORDER BY ContactID desc";
string whereSQL = ContactWayQueryToSQLWhere(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
return db.GetList<ContactWayEntity>(strSql, MakeContactWayList);
}
public Pager<ContactWayEntity> GetContactWayPageList(ContactWayQuery query)
{
string strSql = "SELECT ContactID,JournalID,ChannelID,Company,LinkMan,Address,ZipCode,Tel,Fax,AddDate,ROW_NUMBER() OVER(ORDER BY ContactID DESC) AS ROW_ID FROM dbo.ContactWay with(nolock)",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.ContactWay with(nolock)";
string whereSQL = ContactWayQueryToSQLWhere(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return db.GetPageList<ContactWayEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeContactWayList);
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="contactWayQuery">ContactWayQuery查询实体对象</param>
/// <returns>List<ContactWayEntity></returns>
public List<ContactWayEntity> GetContactWayList(ContactWayQuery contactWayQuery)
{
return ContactWayDataAccess.Instance.GetContactWayList(contactWayQuery);
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="contactWayQuery">ContactWayQuery查询实体对象</param>
/// <returns>List<ContactWayEntity></returns>
public List<ContactWayEntity> GetContactWayList(ContactWayQuery contactWayQuery)
{
return ContactWayBusProvider.GetContactWayList(contactWayQuery);
}
