/// <summary> /// 获取收入列表 /// </summary> /// <returns></returns> public string GetIEList() { EF.FMS_DevelopEntities entity = new EF.FMS_DevelopEntities(); string C_GUID = Session["CurrentCompanyGuid"].ToString(); var ieList = entity.SP_QueryIEListForProductSales(C_GUID); return(JsonConvert.SerializeObject(ieList)); }
public string GetSaledDetail() { var productId = Request.QueryString["pguid"]; EF.FMS_DevelopEntities entity = new EF.FMS_DevelopEntities(); string C_GUID = Session["CurrentCompanyGuid"].ToString(); var detail = from p in entity.V_Product_Saled_Detail where p.C_GUID == C_GUID && p.product_guid == productId select p; return(JsonConvert.SerializeObject(detail)); }
public string GetProductList() { string C_GUID = Session["CurrentCompanyGuid"].ToString(); EF.FMS_DevelopEntities entity = new EF.FMS_DevelopEntities(); var typeId = Request.QueryString["typeId"]; var subTypeId = Request.QueryString["subTypeId"]; var MaterielManage = Request.QueryString["MaterielManage"]; var business_GUID = Request.QueryString["business_GUID"]; var subBusiness_GUID = Request.QueryString["subBusiness_GUID"]; var product = from p in entity.V_Prodcut_List where p.C_GUID == C_GUID && p.TypeId == typeId && p.SubTypeId == subTypeId && p.MaterielManage_GUID == MaterielManage && p.Business_GUID == business_GUID && p.SubBusiness_GUID == subBusiness_GUID select p; if (MaterielManage == "") { product = from p in entity.V_Prodcut_List where p.C_GUID == C_GUID select p; } return(JsonConvert.SerializeObject(product)); }
/// <summary> /// 获取资产费用与成本类别 /// </summary> /// <returns>JSON字符串({code:**,name:**})</returns> public ActionResult GetAssetCostType() { EF.FMS_DevelopEntities entities = new EF.FMS_DevelopEntities(); var costTypeList = from a in entities.T_AssetCostType select a; List <DropDownItem> items = new List <DropDownItem>(); var index = 0; foreach (EF.T_AssetCostType type in costTypeList) { items.Add(new DropDownItem()); index = items.Count - 1; items[index].label = type.name; items[index].value = type.code; } var costType = Newtonsoft.Json.JsonConvert.SerializeObject(items); return(Content(costType)); }