/// <summary>
/// 下拉框 (经销存类型)
/// </summary>
/// <returns></returns>
public ActionResult ChaXunSeleLeiXing()
{
string dateTimeNow = DateTime.Now.ToString("yyyy-MM-dd");
DateTime d = Convert.ToDateTime(dateTimeNow);
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
//然后又使用 List<SelectXiaLa>来进行查询
List <SelectXiaLa> listNoticeTypeS = (from tbWaerHouse in myModels.B_WareHouseList
join tbHeTong in myModels.B_OrderFormPactList on tbWaerHouse.OrderFormPactID equals tbHeTong.OrderFormPactID//合同
join tbAdjLeiXing in myModels.S_AdjustAccountsFashionList on tbHeTong.AdjustAccountsFashionID equals tbAdjLeiXing.AdjustAccountsFashionID
where tbWaerHouse.ExamineNot == true && tbWaerHouse.Status == true && tbWaerHouse.CrushRedNot == false && tbWaerHouse.ExamineTime == d
select new SelectXiaLa
{
id = tbAdjLeiXing.AdjustAccountsFashionID,
text = tbAdjLeiXing.AdjustAccountsFashion
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
//最后拼接起来返回 listNoticeTypeS
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 绑定商标
/// </summary>
/// <returns></returns>
public ActionResult BangGoodBiao()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
List <SelectXiaLa> listNoticeTypeS = (from tb in myModels.B_GoodsChopList
select new SelectXiaLa
{
id = tb.GoodsChopID,
text = tb.GoodsChopName
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 下拉框（配送部门）一
/// </summary>
/// <returns></returns>
public ActionResult PeiSong()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
List <SelectXiaLa> listNoticeTypeS = (from tb in myModels.S_SpouseBRanchList
where tb.SpouseBRanchID == 1 || tb.SpouseBRanchID == 2
select new SelectXiaLa
{
id = tb.SpouseBRanchID,
text = tb.SpouseBRanchName
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 下拉框（盘点部门）二
/// </summary>
/// <returns></returns>
public ActionResult BuMen(int DrugTypeID)
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
List <SelectXiaLa> listNoticeTypeS = (from tb in myModels.B_PanlList
where tb.F_DrugTypeID == DrugTypeID
select new SelectXiaLa
{
id = tb.DrugTypeID,
text = tb.DrugType
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 进仓单类型
/// </summary>
/// <returns></returns>
public ActionResult QuarctJin()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
//然后又使用 List<SelectXiaLa>来进行查询
List <SelectXiaLa> listNoticeTypeS = (from tb in myModels.S_QuFenLeiXingList
select new SelectXiaLa
{
id = tb.QuFenLeiXingID,
text = tb.QuFenLeiXingMC
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
//最后拼接起来返回 listNoticeTypeS
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 下拉（库存地点）
/// </summary>
/// <returns></returns>
public ActionResult KuCunDiDian()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
//然后又使用 List<SelectXiaLa>来进行查询
List <SelectXiaLa> listNoticeTypeS = (from tb in MyModels.S_StockPlaceList
select new SelectXiaLa
{
id = tb.StockPlaceID,
text = tb.StockPlaceName
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
//最后拼接起来返回 listNoticeTypeS
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 下拉（退货原因）
/// </summary>
/// <returns></returns>
public ActionResult TuiHuoYuanYin()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
//然后又使用 List<SelectXiaLa>来进行查询
List <SelectXiaLa> listNoticeTypeS = (from tb in MyModels.S_ReturnofList
select new SelectXiaLa
{
id = tb.ReturnofID,
text = tb.Returnof
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
//最后拼接起来返回 listNoticeTypeS
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 下拉框 (买卖场)
/// </summary>
/// <returns></returns>
public ActionResult ChaXunSeleSuppout()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
List <SelectXiaLa> listNoticeTypeS = (from tbWaerHouse in myModels.S_MaiChangList
select new SelectXiaLa
{
id = tbWaerHouse.MaiChangID,
text = tbWaerHouse.MaiChangMC
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 下拉（退货原因）
/// </summary>
/// <returns></returns>
public ActionResult TuiHuoBuMen()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
//然后又使用 List<SelectXiaLa>来进行查询
List <SelectXiaLa> listNoticeTypeS = (from tb in MyModels.S_SpouseBRanchList
where tb.SpouseBRanchID == 3 || tb.SpouseBRanchID == 4
select new SelectXiaLa
{
id = tb.SpouseBRanchID,
text = tb.SpouseBRanchName
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
//最后拼接起来返回 listNoticeTypeS
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// 下拉框 (库存地点)
/// </summary>
/// <returns></returns>
public ActionResult SelectKuCunDian()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
List <SelectXiaLa> listNoticeTypeS = (from tbAdjLeiXing in myModels.S_StockPlaceList
select new SelectXiaLa
{
id = tbAdjLeiXing.StockPlaceID,
text = tbAdjLeiXing.StockPlaceName
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 商品分类（下拉）
/// </summary>
/// <returns></returns>
public ActionResult SelectGoodFeiLei()
{
List <SelectXiaLa> listCaiGou = new List <SelectXiaLa>();
SelectXiaLa selectXiaLa = new SelectXiaLa()
{
id = 0,
text = "---请选择---"
};
listCaiGou.Add(selectXiaLa);
//然后又使用 List<SelectXiaLa>来进行查询
List <SelectXiaLa> listNoticeTypeS = (from tbGooFeiLeiLiet in MyModels.B_GoodsClassifyList
where tbGooFeiLeiLiet.F_GoodsClassifyID == 0
select new SelectXiaLa
{
id = tbGooFeiLeiLiet.GoodsClassifyID,
text = tbGooFeiLeiLiet.GoodsClassifyName
}).ToList();
listCaiGou.AddRange(listNoticeTypeS);
//最后拼接起来返回 listNoticeTypeS
return(Json(listCaiGou, JsonRequestBehavior.AllowGet));
}