public ActionResult GetList()
{
int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1;
int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 10;
int totalCount;
var actioninfolist = YXB_Kh_listService.LoadPageEntities <int>(pageIndex, pageSize, out totalCount, a => a.DelFlag == delFlag && a.AddUser == LoginUser.ID, a => a.id, false);
var temp = from a in actioninfolist
select new
{
ID = a.id,
KHname = a.KHname,
KHComname = a.KHComname,
KHperson = a.KHperson,
AddTime = a.NewTime,
KHfaren = a.KHfaren,
KHSGAdrss = a.KHSGAdrss,
BeiZhu = a.BeiZhu,
KHphoto = a.KHphoto,
KHzhiwu = a.KHzhiwu,
All_I = a.All_I,
Remark = a.Remark,
NewTime = a.NewTime,
DelFlag = a.DelFlag,
AddUser = a.AddUser
};
return(Json(new { rows = temp, total = totalCount }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddYXB_KH_list()
{
YXB_Kh_list khlist = new YXB_Kh_list();
khlist.KHname = Request["KHname"];
khlist.KHperson = Request["KHperson"];
khlist.KHzhiwu = Request["KHzhiwu"];
khlist.KHphoto = Request["KHphoto"];
khlist.KHfaren = Request["KHfaren"];
khlist.DelFlag = 0;
khlist.NewTime = DateTime.Now;
khlist.AddUser = LoginUser.ID;
khlist.All_I = 0;
var isnull = YXB_Kh_listService.LoadEntities(x => x.KHfaren == khlist.KHfaren).FirstOrDefault();
if (isnull == null)
{
var isdistic = YXB_Kh_listService.LoadEntities(x => x.KHname == khlist.KHname).FirstOrDefault();
if (isdistic == null)
{
YXB_Kh_listService.AddEntity(khlist);
return(Json("OK", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("errer", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("Isdistict", JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index()
{
//用户名列表
ViewBag.user = UserInfoService.LoadEntities(x => x.DelFlag != 1 && x.BuMenID == 1).ToList();
//状态列表
ViewBag.items = T_YSItemsService.LoadEntities(x => x.Items == 1).ToList();
//客户名称 与 项目名称列表
ViewBag.KeHuName = YXB_Kh_listService.LoadEntities(x => x.DelFlag == 0).ToList();
return(View());
}
private string addBaoJiaTOP(T_BaoJiaToP tbop, ref long ThisAddId, bool Bl, ref string msg)
{
string ret;
if (Bl)
{
var editid = Convert.ToInt64(Request["editID"]);
tbop = T_BaoJiaToPService.LoadEntities(x => x.id == editid).FirstOrDefault();
tbop.GhTime = Convert.ToDateTime(Request["GhTime"]);
}
else
{
tbop.DelFlag = delFlag;
tbop.AddTime = MvcApplication.GetT_time();
string Ttime = Request["GhTime"];
var tsplit = Ttime.Split('/');
tbop.GhTime = new DateTime(int.Parse(tsplit[2]), int.Parse(tsplit[1]), int.Parse(tsplit[0]));
}
tbop.Kh_List_id = Request["khidselect"] != null?int.Parse(Request["khidselect"]) : 0;
tbop.DaiBanYunShu = Request["DaiBanYunShu"];
tbop.HeTongQianDing = Request["HeTongQianDing"];
tbop.JieShuanFanShi = Request["JieShuanFanShi"];
tbop.JiShuYaoQiu = Request["JiShuYaoQiu"];
tbop.KHComname = Request["KHComname"];
tbop.HanShuiID = int.Parse(Request["HanShuiID"]);
tbop.PiaoJuID = int.Parse(Request["PiaojiuID"]);
string Addess = Request["Province"].ToString() + "," + Request["City"].ToString() + "," + Request["Village"].ToString();
tbop.Addess = Addess;
try
{
if (Bl)
{
T_BaoJiaToPService.EditEntity(tbop);
ThisAddId = tbop.id;
msg = "修改成功！";
}
else
{
T_BaoJiaToPService.AddEntity(tbop);
var ThisAddId_list = YXB_Kh_listService.LoadEntities(x => x.id == tbop.Kh_List_id).FirstOrDefault();
ThisAddId = ThisAddId_list.T_BaoJiaToP.Max(x => x.id);
msg = "添加成功,请继续添加产品信息！";
}
ret = "ok";
}
catch (Exception ex)
{
ret = ex.ToString();
}
return(ret);
}
//修改客户信息
public ActionResult EditYXB_KH_list(YXB_Kh_list khlist)
{
if (YXB_Kh_listService.EditEntity(khlist))
{
return(Json(new { ret = "ok" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { ret = "err" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetKhList()
{
var aifo = YXB_Kh_listService.LoadEntities(x => x.DelFlag == delFlag && x.AddUser == LoginUser.ID);
var temp = from a in aifo
select new
{
ID = a.id,
KHname = a.KHname,
KHComname = a.KHComname
};
return(Json(new { rows = temp }, JsonRequestBehavior.AllowGet));
}
//软删除客户信息
public ActionResult Del_KH_list()
{
var id = Request["ID"] == null ? 0 : Convert.ToInt64(Request["ID"]);
var dellist = YXB_Kh_listService.LoadEntities(x => x.id == id).FirstOrDefault();
if (dellist == null)
{
return(Json(new { ret = "not" }, JsonRequestBehavior.AllowGet));
}
dellist.DelFlag = 1;
if (YXB_Kh_listService.EditEntity(dellist))
{
return(Json(new { ret = "ok" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { ret = "err" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddYXB_KH_list()
{
YXB_Kh_list khlist = new YXB_Kh_list();
khlist.KHname = Request["KHname"];
khlist.KHperson = Request["KHperson"];
khlist.KHzhiwu = Request["KHzhiwu"];
khlist.KHphoto = Request["KHphoto"];
khlist.KHfaren = Request["KHfaren"];
khlist.KHSGAdrss = Request["KHSGAdrss"];
khlist.BeiZhu = Request["BeiZhu"];
khlist.DelFlag = 0;
khlist.NewTime = DateTime.Now;
khlist.AddUser = LoginUser.ID;
khlist.All_I = 0;
khlist.JieZhiZi = Convert.ToBoolean(Request["sta"]);
//判断客户名称是否重复
var isdistic = YXB_Kh_listService.LoadEntities(x => x.KHname == khlist.KHname && x.AddUser == LoginUser.ID).FirstOrDefault();
if (isdistic != null && khlist.JieZhiZi == false)
{
return(Json("errer", JsonRequestBehavior.AllowGet));
}
else
{
YXB_Kh_listService.AddEntity(khlist);
return(Json("OK", JsonRequestBehavior.AllowGet));
}
#region 判断法人是否重复
//var isnull = YXB_Kh_listService.LoadEntities(x => x.KHfaren == khlist.KHfaren).FirstOrDefault();
//if (isnull == null)
//{
//}
//else
//{
// return Json("Isdistict", JsonRequestBehavior.AllowGet);
//}
#endregion
}
//修改报价信息
public ActionResult EditBJInfo()
{
long id = Convert.ToInt64(Request["BaoJiaID"]);
long CPname = Convert.ToInt64(Request["CPname"]);
long CPxh = Convert.ToInt64(Request["CPxh"]);
int CPShuLiang = Convert.ToInt32(Request["CPShuLiang"]);
long HanShuiID = Convert.ToInt64(Request["HanShuiID"]);
long CPDengJiID = Convert.ToInt64(Request["CPDengJiID"]);
long PiaoJuID = Convert.ToInt64(Request["PiaoJuID"]);
string BeiZhu = Request["BeiZhu"];
DateTime GhTime = Convert.ToDateTime(Request["GhTime"]);
string KHname = Request["KHname"];
string KHperson = Request["KHperson"];
string KHzhiwu = Request["KHzhiwu"];
string KHphoto = Request["KHphoto"];
string KHfaren = Request["KHfaren"];
string JiShuYaoQiu = Request["JiShuYaoQiu"];
string ProvinceIDname = Request["ProvinceIDname"];
string CityIDname = Request["CityIDname"];
string VillageIDname = Request["VillageIDname"];
string DaiBanYunShu = Request["DaiBanYunShu"];
string JieShuanFanShi = Request["JieShuanFanShi"];
string HeTongQianDing = Request["HeTongQianDing"];
var bj = YXB_BaojiaService.LoadEntities(x => x.id == id).FirstOrDefault();
if (bj != null)
{
bj.CPname = CPname;
bj.CPXingHao = CPxh;
bj.CPShuLiang = CPShuLiang;
bj.CPDengJiID = CPDengJiID;
bj.Remark = BeiZhu;
if (YXB_BaojiaService.EditEntity(bj))
{
var bjtop = T_BaoJiaToPService.LoadEntities(x => x.id == bj.BaoJiaTop_id).FirstOrDefault();
if (bjtop != null)
{
bjtop.HanShuiID = HanShuiID;
bjtop.PiaoJuID = PiaoJuID;
bjtop.GhTime = GhTime;
bjtop.JiShuYaoQiu = JiShuYaoQiu;
if (ProvinceIDname != null && ProvinceIDname != "")
{
var str = ProvinceIDname;
if (CityIDname != null && CityIDname != "")
{
str = str + "," + CityIDname;
if (VillageIDname != null && VillageIDname != "")
{
str = str + "," + VillageIDname;
}
}
bjtop.Addess = str;
}
bjtop.DaiBanYunShu = DaiBanYunShu;
bjtop.JieShuanFanShi = JieShuanFanShi;
bjtop.HeTongQianDing = HeTongQianDing;
if (T_BaoJiaToPService.EditEntity(bjtop))
{
var khlist = YXB_Kh_listService.LoadEntities(x => x.id == bjtop.Kh_List_id).FirstOrDefault();
if (khlist != null)
{
khlist.KHname = KHname;
khlist.KHperson = KHperson;
khlist.KHzhiwu = KHzhiwu;
khlist.KHphoto = KHphoto;
khlist.KHfaren = KHfaren;
if (YXB_Kh_listService.EditEntity(khlist))
{
return(Json(new { ret = "yes", msg = "修改成功！" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { ret = "no", msg = "修改失败，发生在第三阶段！" }, JsonRequestBehavior.AllowGet));
}
}
}
else
{
return(Json(new { ret = "no", msg = "修改失败，发生在第二阶段！" }, JsonRequestBehavior.AllowGet));
}
}
}
else
{
return(Json(new { ret = "no", msg = "修改失败，发生在第一阶段！" }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { ret = "no", msg = "修改失败！" }, JsonRequestBehavior.AllowGet));;
}
