/// <summary>
///数据
///wuyf 20150908
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Create(long?id)
{
SuppliersModel model = new SuppliersModel();
ViewBag.thArea = _thAreaService.GetTHAreaByParentID(ACultureHelper.GetLanguageID, 0).Data;
if (id.HasValue)
{
SalesSuppliersModel smodel = new SalesSuppliersModel();
smodel.SupplierId = id.Value;
smodel.PagedIndex = 0;
smodel.PagedSize = 100;
smodel.Lang = ACultureHelper.GetLanguageID;
//查询列表
List <SuppliersModel> List = this._suppliersService.GetSuppliers(smodel).Data;
if (List != null && List.Count > 0)
{
model = List[0];
ViewBag.shiArea = _thAreaService.GetTHAreaByParentID(ACultureHelper.GetLanguageID, model.ShengTHAreaID).Data;
ViewBag.xianArea = SelectCommon.GetTHArea_lang(_thAreaService.GetTHAreaByParentID(ACultureHelper.GetLanguageID, model.ShiTHAreaID).Data as List <HKTHMall.Domain.Models.THArea_lang>);//_thAreaService.GetTHAreaByParentID(CultureHelper.GetLanguageID, model.ShiTHAreaID).Data;
//这里是用于修改通过密码验证使用的（修改是不修改密码的）
model.PassWord = "******";
}
}
else
{
ViewBag.xianArea = SelectCommon.GetTHArea_lang(null);
}
return(PartialView(model));
}
public ActionResult Create(SuppliersModel model)
{
ViewBag.thArea = _thAreaService.GetTHAreaByParentID(ACultureHelper.GetLanguageID, 0).Data;
ViewBag.xianArea = SelectCommon.GetTHArea_lang(null);
if (ModelState.IsValid)
{
ResultModel resultModel = new ResultModel();
if (model.SupplierId > 0)
{
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
var result = _suppliersService.UpdateSuppliers(model).IsValid;
resultModel.Messages = new List <string> {
result == true ? " success!" : " failed!"
};
var opera = string.Empty;
opera = string.Format("修改供应商管理:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages);
LogPackage.InserAC_OperateLog(opera, "修改供应商管理");
}
else
{
SalesSuppliersModel smodel = new SalesSuppliersModel();
smodel.Mobile = model.Mobile;
smodel.PagedIndex = 0;
smodel.PagedSize = 2;
var bl = Mobile(smodel);
if (bl)
{
model.PassWord = FormsAuthentication.HashPasswordForStoringInConfigFile(model.PassWord.Trim(), "MD5");
model.SupplierId = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
model.CreateBy = UserInfo.CurrentUserName;
model.CreateDT = DateTime.Now;
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
var result = _suppliersService.AddSuppliers(model).IsValid;
resultModel.Messages = new List <string> {
result == true ? " success!" : " failed!"
};
var opera = string.Empty;
opera = string.Format("添加供应商管理:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages);
LogPackage.InserAC_OperateLog(opera, "添加供应商管理");
}
else
{
resultModel.IsValid = false;
resultModel.Messages = new List <string> {
" Mobile phone number already exists!"
};
}
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
return(PartialView(model));
}
/// <summary>
/// 验证手机号码是否存在
/// wuyf 20150925
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Mobile(SalesSuppliersModel model)
{
bool bl = true;
List <SuppliersModel> List = this._suppliersService.GetSuppliers(model).Data;
if (List != null && List.Count > 0)
{
bl = false;
}
return(bl);
}
public JsonResult List(SalesSuppliersModel model)
{
//SearchAC_OperateLogModel logmodel = new SearchAC_OperateLogModel();
model.PagedIndex = model.PagedIndex == 0 ? 0 : model.PagedIndex;
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
model.Lang = ACultureHelper.GetLanguageID;
//加一天是为查询最后一天的数据
//系统操作日志
var result = this._suppliersService.GetSuppliers(model);
List <SuppliersModel> ds = result.Data;
var data = new
{
rows = ds,
total = result.Data.TotalCount
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取供应商列表（wuyf）
/// </summary>
/// <param name="parentId">父Id</param>
/// <returns>供应商列表</returns>
public ResultModel GetSuppliers(SalesSuppliersModel model)
{
var tb = _database.Db.Suppliers;
var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); //
if (model.SupplierId > 0)
{
//ID
where = new SimpleExpression(where, tb.SupplierId == model.SupplierId, SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.LinkMan) && model.LinkMan.Trim() != "")
{
//联系人
where = new SimpleExpression(where,
tb.LinkMan.Like("%" + model.LinkMan.Trim() + "%"), SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.SupplierName) && model.SupplierName.Trim() != "")
{
//供应商名称
where = new SimpleExpression(where,
tb.SupplierName.Like("%" + model.SupplierName.Trim() + "%"), SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.Telephone) && model.Telephone.Trim() != "")
{
//电话
where = new SimpleExpression(where,
tb.Telephone.Like("%" + model.Telephone.Trim() + "%"), SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.Mobile) && model.Mobile.Trim() != "")
{
//手机
where = new SimpleExpression(where,
tb.Mobile.Like("%" + model.Mobile.Trim() + "%"), SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.UserName) && model.UserName.Trim() != "")
{
//用户名
where = new SimpleExpression(where,
tb.UserName == model.UserName.Trim(), SimpleExpressionType.And);
}
dynamic one, pc;
dynamic two;
var query = tb
.Query()
.LeftJoin(_database.Db.THArea.As("t1"), out one).On(one.THAreaID == tb.THAreaID)
.LeftJoin(_database.Db.THArea.As("t2"), out two).On(two.THAreaID == one.ParentID)
.LeftJoin(_database.Db.THArea_lang.As("t3"), out pc).On(pc.THAreaID == tb.THAreaID && pc.LanguageID == model.Lang)
//.LeftJoin(_database.Db.THArea, out pc)
//.On(_database.Db.THArea.THAreaID == tb.THAreaID)
.Select(
tb.SupplierId,
tb.SupplierName,
tb.THAreaID,
tb.Address,
tb.LinkMan,
tb.Telephone,
tb.Mobile,
tb.Remark,
tb.CreateBy,
tb.CreateDT,
tb.UpdateBy,
tb.UpdateDT,
tb.UserName,
tb.PassWord,
pc.AreaName,
one.ParentID.As("ShiTHAreaID"),
two.ParentID.As("ShengTHAreaID")
)
.Where(where)
.OrderByCreateDTDescending();
var result = new ResultModel
{
Data = new SimpleDataPagedList <SuppliersModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
