/// <summary>
/// 获取手机联系人
/// </summary>
/// <param name="phoneAddressInfo">手机联系人实体</param>
/// <param name="pageInfo">分页实体</param>
/// <returns></returns>
public IList <PhoneAddressInfo> GetPhoneAddress(PhoneAddressInfo phoneAddressInfo, PageInfo pageInfo)
{
using (DataContextDB DB = new DataContextDB())
{
IQueryable <PhoneAddressInfo> phoneAddressInfos =
(
from item in DB.GetTable <PhoneAddressInfo>()
orderby item.ID descending
select item
);
if (phoneAddressInfo != null && phoneAddressInfo.ID != 0)
{
phoneAddressInfos = phoneAddressInfos.Where <PhoneAddressInfo>(m => m.ID == phoneAddressInfo.ID);
}
if (phoneAddressInfo != null && phoneAddressInfo.UserID != 0)
{
phoneAddressInfos = phoneAddressInfos.Where <PhoneAddressInfo>(m => m.UserID == phoneAddressInfo.UserID);
}
if (pageInfo != null)
{
pageInfo.TotalRecord = phoneAddressInfos.Count();
return(phoneAddressInfos.Skip(pageInfo.PageSize * (pageInfo.PageIndex - 1)).Take(pageInfo.PageSize).ToList <PhoneAddressInfo>());
}
else
{
return(phoneAddressInfos.ToList <PhoneAddressInfo>());
}
}
}
public ActionResult PhoneAddress(int?id)
{
PhoneAddressInfo phoneAddressInfo = null;
if (id != null && id.Value != 0)
{
phoneAddressInfo = Start.DatabaseProvider.Instance().GetPhoneAddressByID(id.Value);
}
if (phoneAddressInfo == null)
{
phoneAddressInfo = new PhoneAddressInfo();
}
return(View(phoneAddressInfo));
}
public ActionResult PhoneAddressList(int userID = 0, int pageIndex = 1)
{
PageInfo pageInfo = new PageInfo {
PageIndex = pageIndex
};
PhoneAddressInfo phoneAddressInfo = new PhoneAddressInfo {
UserID = userID
};
IList <PhoneAddressInfo> phoneAddressInfos = Start.DatabaseProvider.Instance().GetPhoneAddress(phoneAddressInfo, pageInfo);
PagedList <PhoneAddressInfo> pagedList = new PagedList <PhoneAddressInfo>(phoneAddressInfos, pageInfo.PageIndex, pageInfo.PageSize, pageInfo.TotalRecord);
ViewBag.PhoneAddressInfo = phoneAddressInfo;
return(View(pagedList));
}
/// <summary>
/// 修改手机联系人
/// </summary>
/// <param name="phoneAddressInfo">手机联系人实体</param>
public int UpdatePhoneAddress(PhoneAddressInfo phoneAddressInfo)
{
using (DataContextDB DB = new DataContextDB())
{
try
{
DB.GetTable <PhoneAddressInfo>().Attach(phoneAddressInfo, true);
DB.SubmitChanges();
return(1);
}
catch (Exception e)
{
string error = e.Message;
return(-1);
}
}
}
/// <summary>
/// 添加手机联系人
/// </summary>
/// <param name="phoneAddressInfo">手机联系人实体</param>
public int InsertPhoneAddress(PhoneAddressInfo phoneAddressInfo)
{
using (DataContextDB DB = new DataContextDB())
{
try
{
DB.GetTable <PhoneAddressInfo>().InsertOnSubmit(phoneAddressInfo);
DB.SubmitChanges();
return(1);
}
catch (Exception e)
{
string error = e.Message;
return(-1);
}
}
}
public ActionResult PhoneAddress(PhoneAddressInfo phoneAddressInfo)
{
if (phoneAddressInfo == null)
{
return(Json(new FeedbackInfo {
Success = -1, Message = "获取实体出错"
}));
}
if (phoneAddressInfo.UserID == 0)
{
return(Json(new FeedbackInfo {
Success = -1, Message = "请输入用户编号"
}));
}
if (string.IsNullOrWhiteSpace(phoneAddressInfo.Name))
{
return(Json(new FeedbackInfo {
Success = -1, Message = "请输入联系人名"
}));
}
if (string.IsNullOrWhiteSpace(phoneAddressInfo.Phone))
{
return(Json(new FeedbackInfo {
Success = -1, Message = "请输入联系人手机"
}));
}
//新建
int result = 0;
if (phoneAddressInfo.ID == 0)
{
result = Start.DatabaseProvider.Instance().InsertPhoneAddress(phoneAddressInfo);
if (result == 1)
{
return(Json(new FeedbackInfo {
Success = 1, Message = "添加成功"
}));
}
else
{
return(Json(new FeedbackInfo {
Success = -1, Message = "添加失败"
}));
}
}
else //编辑
{
result = Start.DatabaseProvider.Instance().UpdatePhoneAddress(phoneAddressInfo);
if (result == 1)
{
return(Json(new FeedbackInfo {
Success = 1, Message = "修改成功"
}));
}
else
{
return(Json(new FeedbackInfo {
Success = -1, Message = "修改失败"
}));
}
}
}
