public string GetForm1(string flag, string dtp_current_start, string dtp_current_end, string dtp_period_start, string dtp_period_end)
{
Response.ContentType = "application/json";
Response.Charset = "utf-8";
Response.CacheControl = "no-cache";
//Response.AppendHeader("Content-encoding", "gzip");
//flag = "all";
//dtp_current_start = "2019-01-01";
//dtp_current_end = "2019-02-01";
//dtp_period_start = "2019-03-01";
//dtp_period_end = "2019-04-05";
if (flag == "" ||
dtp_current_start == "" ||
dtp_current_end == "" ||
dtp_period_start == "" ||
dtp_period_end == "")
{
return("");
}
var list = new SameReriodIncomeReportService(flag
, dtp_current_start
, dtp_current_end
, dtp_period_start
, dtp_period_end).Do();
var result = new LayPadding <SamePeriodIncomRatio>
{
result = true,
msg = "success",
list = list,
count = list.Count
};
return(result.ToJson());
}
public ActionResult GetOutFeeDetail(int pageIndex, int pageSize, string pno, string date, string seqno, string bi, string drcode)
{
if (pno == "" || date == "" || seqno == "" || bi == "" || drcode == "")
{
return(Content("".ToJson()));;
}
var param = new FeeParam {
Pno = pno,
Date = date,
SeqNO = seqno,
Bi = bi,
DrCode = drcode
};
var keyWord = $@"{pno}_{date}_{seqno}_{bi}_{drcode}";
var service = new PatientFeeService();
var pageData = service.PinYin(pageIndex, pageSize, keyWord);
var count = service.GetPinYinCout(keyWord);
var result = new LayPadding <FeeEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
protected ActionResult NoPage()
{
var result = new LayPadding<dynamic>()
{
result = true,
msg = "查无数据",
list =null,
count = 0
};
return Content(result.ToJson());
}
/// <summary>
#region 自定义方法
public static LayPadding <AdvertiesmentMDL> GetAdvertiesmentPageList(string fileds, string orderstr, int PageSize, int PageIndex, string strWhere)
{
LayPadding <AdvertiesmentMDL> ulist = new LayPadding <AdvertiesmentMDL>();
var list = new List <AdvertiesmentMDL>();
string cond = string.IsNullOrEmpty(strWhere) ? "" : string.Format(" where {0}", strWhere);
string sql = string.Format("SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY {0}) AS pos, {1} FROM [Advertiesment] {2} ) AS sp WHERE pos BETWEEN {3} AND {4}", orderstr, fileds, cond, (((PageIndex - 1) * PageSize) + 1), PageSize * PageIndex);
DBHelper db = new DBHelper();
using (SqlDataReader reader = db.GetDataReader(sql))
{
AdvertiesmentMDL _AdvertiesmentMDL = null;
while (reader.Read())
{
_AdvertiesmentMDL = new AdvertiesmentMDL();
if (reader["id"] != DBNull.Value)
{
_AdvertiesmentMDL.id = Convert.ToInt32(reader["id"]);
}
if (reader["createtime"] != DBNull.Value)
{
_AdvertiesmentMDL.createtime = Convert.ToDateTime(reader["createtime"]);
}
if (reader["path"] != DBNull.Value)
{
_AdvertiesmentMDL.path = Convert.ToString(reader["path"]);
}
if (reader["type"] != DBNull.Value)
{
_AdvertiesmentMDL.type = Convert.ToString(reader["type"]);
}
if (reader["link"] != DBNull.Value)
{
_AdvertiesmentMDL.link = Convert.ToString(reader["link"]);
}
if (reader["time"] != DBNull.Value)
{
_AdvertiesmentMDL.time = Convert.ToInt32(reader["time"]);
}
if (reader["remark"] != DBNull.Value)
{
_AdvertiesmentMDL.remark = Convert.ToString(reader["remark"]);
}
}
reader.Close();
db.Close();
ulist.data = list;
ulist.count = SelectCount(cond);
return(ulist);
}
}
public ActionResult GetCommonItemList(int pageIndex, int pageSize, string keyWord)
{
var pageData = _itemService.GetPage(pageIndex, pageSize, keyWord);
var result = new LayPadding <AddCommonItemViewModel>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
public ActionResult Index(int pageIndex, int pageSize, string keyWord)
{
var pageData = _itemService.GetPage(pageIndex, pageSize, keyWord);
var result = new LayPadding <DATAITEM_VIEWMODEL>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
public ActionResult Index(int pageIndex, int pageSize, string keyWord)
{
var teamPage = _service.SelectTeam(pageIndex, pageSize, keyWord);
var models = new LayPadding <TeamViewModel>
{
result = true,
msg = "success",
count = teamPage.TotalItems,
list = teamPage.Items
};
return(Content(models.ToJson()));
}
/// <summary>
///
/// </summary>
/// <param name="projectId">项目Id</param>
/// <param name="sdId">病种id</param>
/// <param name="kpiId">kpi id</param>
/// <returns></returns>
public ActionResult Index(int projectId, int sdId, int kpiId)
{
var pageData = _kpiparamService.GetList(projectId, sdId, kpiId);
var result = new LayPadding <PPARAM_VIEWMODEL>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
[HttpPost] //, AuthorizeChecked
public ActionResult Index(int pageIndex, int pageSize) //, string keyWord
{
var pageData = _ingroupService.GetList(pageIndex, pageSize, "", "");
var result = new LayPadding <InGroupEntity>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
//private object getPatientInfo(string url, string pNO, string constr)
//{
// try
// {
// var result = HttpGet(url, string.Format("patientNo={0&connectionString={1}", pNO, constr));
// var tuple = JsonConvert.DeserializeObject<object>(result);
// return tuple;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//private string HttpGet(string Url, string postDataStr)
//{
// HttpWebResponse response = null;
// Stream myResponseStream = null;
// StreamReader myStreamReader = null;
// try
// {
// GC.Collect();//垃圾回收站
// HttpWebRequest request = (HttpWebRequest)WebRequest.Create(Url + (postDataStr == "" ? "" : "?") + postDataStr);
// request.Method = "POST";//GET
// request.ServicePoint.ConnectionLimit = 1024;//默认为2个
// request.KeepAlive = false;
// request.Timeout = 1000000;//100秒
// request.ContentType = "text/html;charset=UTF-8";
// response = (HttpWebResponse)request.GetResponse();
// myResponseStream = response.GetResponseStream();
// myStreamReader = new StreamReader(myResponseStream, Encoding.GetEncoding("utf-8"));
// string retString = myStreamReader.ReadToEnd();
// //myStreamReader.Close();
// //myResponseStream.Close();
// return retString;
// }
// catch (Exception ex)
// {
// //LogHelper.Error("post信息时出错！信息：" + ex.Message);
// //return null;
// throw ex;
// }
// finally
// {
// if (myStreamReader != null)
// {
// myStreamReader.Close();
// myStreamReader.Dispose();
// }
// if (myResponseStream != null)
// {
// myResponseStream.Close();
// myResponseStream.Dispose();
// }
// if (response != null)
// {
// response.Close();
// response.Dispose();
// }
// }
//}
#endregion
#region 获取入组规则信息分页加载到界面 1.0版本
/// <summary>
/// 获取入组规则信息分页加载到界面
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="resultdata"></param>
/// <returns></returns>
public ActionResult GetInGroupResultList(int pageIndex, int pageSize, List <InGroupResultViewModel> resultdata)// GetInGroupResultList,List<InGroupResultViewModel> data
{
var pageData = _inGroupResultService.GetList(pageIndex, pageSize, "", "", resultdata ?? new List <InGroupResultViewModel>());
var result = new LayPadding <InGroupResultViewModel>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
public ActionResult Index(int pageIndex, int pageSize, string keyWord)
{
var pageData = OrganizeService.GetList(pageIndex, pageSize, keyWord);
var result = new LayPadding <Sys_Organize>()
{
Result = true,
Msg = "success",
List = pageData.Items,
Count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
public ActionResult Index(int pageIndex, int pageSize, string keyWord)
{
var pageData = _userService.GetList(pageIndex, pageSize, keyWord);
var result = new LayPadding <Sys_User>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
/// <summary>
/// 获取数据项集合
/// </summary>
/// <param name="primaryKey"></param>
/// <param name="limit"></param>
/// <param name="keyWord"></param>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult GetItemList(string primaryKey, int pageIndex, int pageSize, string keyWord)
{
var id = int.Parse(primaryKey);
var pageData = _itemDepService.GetItemColPage(id, pageIndex, pageSize, keyWord);
var result = new LayPadding <ITEM_COLLECTION_VIEWMODEL>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
public ActionResult Index(string keyWord, int limit, int page)
{
string cond = swhere(keyWord);
var pageData = VideoDAL.GetVideoPageList("*", "id desc", limit, page, cond);
var result = new LayPadding <VideoMDL>()
{
code = 0,
msg = "success",
data = pageData.data,
count = VideoDAL.SelectCount(cond)
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetUserNoOwnedAnchorList(int pageIndex, int pageSize, PageParm pageParm)
{
int totalCount = 0;
var pageData = sysShopLogic.GetShopNoOwnedAnchorList(pageIndex, pageSize, pageParm.where, ref totalCount);
var result = new LayPadding <SysAnchor>()
{
result = true,
msg = "success",
list = pageData,
count = totalCount// pageData.Count
};
return(Content(result.ToJson()));
}
public ActionResult Index(int pageIndex, int pageSize, string keyWord)
{
int totalCount = 0;
var pageData = roleLogic.GetList(pageIndex, pageSize, keyWord, ref totalCount);
var result = new LayPadding <SysRole>()
{
result = true,
msg = "success",
list = pageData,
count = totalCount// pageData.Count
};
return(Content(result.ToJson()));
}
public ActionResult GetDepts(int pageIndex, int pageSize, string keyWord)
{
var service = new DeptService();
var pageData = service.GetList(pageIndex, pageSize, keyWord);
var count = service.GetCout(keyWord);
var result = new LayPadding <DeptEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
/// <summary>
#region 自定义方法
public static LayPadding <VideoMDL> GetVideoPageList(string fileds, string orderstr, int PageSize, int PageIndex, string strWhere)
{
LayPadding <VideoMDL> ulist = new LayPadding <VideoMDL>();
var list = new List <VideoMDL>();
string cond = string.IsNullOrEmpty(strWhere) ? "" : string.Format(" where {0}", strWhere);
string sql = string.Format("SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY {0}) AS pos, {1} FROM [video] {2} ) AS sp WHERE pos BETWEEN {3} AND {4}", orderstr, fileds, cond, (((PageIndex - 1) * PageSize) + 1), PageSize * PageIndex);
DBHelper db = new DBHelper();
using (SqlDataReader reader = db.GetDataReader(sql))
{
VideoMDL _VideoMDL = null;
while (reader.Read())
{
_VideoMDL = new VideoMDL();
if (reader["id"] != DBNull.Value)
{
_VideoMDL.id = Convert.ToInt32(reader["id"]);
}
if (reader["createtime"] != DBNull.Value)
{
_VideoMDL.createtime = Convert.ToDateTime(reader["createtime"]);
}
if (reader["title"] != DBNull.Value)
{
_VideoMDL.title = Convert.ToString(reader["title"]);
}
if (reader["img"] != DBNull.Value)
{
_VideoMDL.img = Convert.ToString(reader["img"]);
}
if (reader["body"] != DBNull.Value)
{
_VideoMDL.body = Convert.ToString(reader["body"]);
}
if (reader["visitnum"] != DBNull.Value)
{
_VideoMDL.visitnum = Convert.ToInt32(reader["visitnum"]);
}
list.Add(_VideoMDL);
}
reader.Close();
db.Close();
ulist.data = list;
return(ulist);
}
}
public ActionResult Index(int pageIndex, int pageSize, string keyWord)
{
var pageData = _kpiService.GetPage(pageIndex, pageSize, keyWord);
var result = new LayPadding <KPI_VIEWMODEL>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
var SD_ID = ProjectProvider.Instance.Current.SD_ID;
var sd = _sdService.Get(r => r.SD_ID == SD_ID);
var EKPI_CAT_PA_CODE = (sd == null) ? "" : sd.EKPI_CAT_PA_CODE;
ViewBag.ItemType = _catconfService.GetSearchList(s => s.CAT_PA_CODE == EKPI_CAT_PA_CODE);
return(Content(result.ToJson()));
}
public ActionResult Index(int pageIndex, int pageSize, string keyWord)
{
if (keyWord == "")
{
return(Content("".ToJson()));;
}
var service = new PathologicalExaminationService();
var pageData = service.GetList(pageIndex, pageSize, keyWord);
var count = service.GetCout(keyWord);
var result = new LayPadding <ItemEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
public ActionResult GetWesternMedicine(int pageIndex, int pageSize, string keyWord)
{
if (keyWord == "")
{
return(Content("".ToJson()));;
}
var service = new DrugInquiryService();
var pageData = service.GetList(pageIndex, pageSize, keyWord);
var count = service.GetCout(keyWord);
var result = new LayPadding <DrugEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
public ActionResult GetOutSumFeeAll(string keyWord)
{
if (keyWord == "_")
{
return(Content("".ToJson()));;
}
var service = new PatientFeeService();
var pageData = service.GetListAll(1, 10000, keyWord);
var count = service.GetCoutAll(keyWord);
var result = new LayPadding <FeeEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
/// <summary>
/// 获取数据项结果列表
/// </summary>
/// <param name="primaryKey"></param>
/// <param name="loadData"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="keyWord"></param>
/// <returns></returns>
public ActionResult GetItemValueList(string primaryKey, List <ITEM_VALUE_VIEWMODEL> loadData, int pageIndex, int pageSize, string keyWord)
{
var id = int.Parse(primaryKey);
var pageData = _itemResultService.GetPage(loadData, id, pageIndex, pageSize, keyWord);
if (pageData.Items.Count == 1 && pageData.Items[0] == null)
{
pageData.Items.Clear();
}
var page = new LayPadding <ITEM_VALUE_VIEWMODEL>()
{
result = true,
msg = "success",
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(page.ToJson()));
}
public ActionResult GetList(int pageIndex, int pageSize, string keyWord)
{
if (keyWord == "")
{
return(Content("".ToJson()));;
}
var service = new HygienicMaterialsService();
var pageData = service.GetList(pageIndex, pageSize, keyWord);
var count = service.GetCout(keyWord);
var result = new LayPadding <HygienicMaterialsEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
public ActionResult Index(int pageIndex, int pageSize, string keyWord)
{
if (keyWord == "" || keyWord != "2016")
{
return(Content("".ToJson()));;
}
var service = new PriceDocumentService();
var pageData = service.GetList(pageIndex, pageSize, keyWord);
var count = service.GetCout(keyWord);
var result = new LayPadding <PriceDocumentEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
public ActionResult GetExperts(int pageIndex, int pageSize, string deptType, string deptName)
{
if (deptType == "" || deptName == "")
{
return(Content("".ToJson()));;
}
var service = new ExpertIntroductionService();
var pageData = service.GetList(pageIndex, pageSize, deptType, deptName);
var count = service.GetCout(deptType, deptName);
var result = new LayPadding <ExpertEntity> ()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
public ActionResult PinYin(int pageIndex, int pageSize, string keyWord)
{
keyWord = keyWord.ToUpper();
if (keyWord == "")
{
return(Content("".ToJson()));;
}
var service = new DrugInquiryService();
var pageData = service.PinYin(pageIndex, pageSize, keyWord);
var count = service.GetPinYinCout(keyWord);
var result = new LayPadding <DrugEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
public ActionResult GetInFeeDetail(int pageIndex, int pageSize, string pno, string date, string admseqno)
{
if (pno == "" || date == "" || admseqno == "")
{
return(Content("".ToJson()));;
}
var keyWord = $@"{pno}_{date}_{admseqno}";
var service = new PatientFeeService();
var pageData = service.GetInList(pageIndex, pageSize, keyWord);
//var count = pageData.Count;
var count = service.GetInFeeListCout(keyWord);
var result = new LayPadding <InFeeEntity>()
{
result = true,
msg = "success",
list = pageData,
count = count
};
return(Content(result.ToJson()));
}
public ActionResult Test(KPI_EXCUTE_VIEWMODEL vm)
{
try
{
var msg = string.Empty;
_procLogService.Log(_procLogService.KPICatCode(), vm?.startDate, vm?.endDate, vm.primaryKey);
var pageData = _kpiService.Test(vm);
var result = new LayPadding <TC_SD_EPKI_VALUE_VIEWMODEL>()
{
result = true,
msg = msg,
list = pageData.Items,
count = pageData.TotalItems
};
return(Content(result.ToJson()));
}
catch (Exception e)
{
_errorLogService.LogErr(e.ToString(), ConvertExeFlag(vm.flag));
return(NoPage());
}
}
public ActionResult Index(int pageIndex, int pageSize, string queryDate, string keyWord)
{
DateTime limitDate = DateTime.Now.StartDateTime();
if (!queryDate.IsNullOrEmpty())
{
switch (queryDate)
{
case "7":
limitDate = DateTime.Now.AddDays(-7).StartDateTime();
break;
case "30":
limitDate = DateTime.Now.AddMonths(-1).StartDateTime();
break;
case "90":
limitDate = DateTime.Now.AddMonths(-3).StartDateTime();
break;
default:
limitDate = DateTime.Now.StartDateTime();
break;
}
}
int totalCount = 0;
var pageData = logLogic.GetList(pageIndex, pageSize, limitDate, keyWord, ref totalCount);
var result = new LayPadding <SysLog>()
{
result = true,
msg = "success",
list = pageData,
count = totalCount//pageData.Count
};
return(Content(result.ToJson()));
}
