public ActionResult EditAttraction(Attraction attraction)
{
City city = GetHelper <City> .GetById(Globals.CITIES_API_LINK, attraction.city.id);
Country country = GetHelper <Country> .GetById(Globals.COUNTRIES_API_LINK, city.country.id);
Attraction updatedAttraction = new Attraction()
{
id = attraction.id,
name = attraction.name,
address = attraction.address,
type = attraction.type,
city = new City
{
id = city.id,
name = city.name,
country = new Country
{
id = country.id,
name = country.name
}
}
};
UpdateHelper <Attraction> .UpdateEntity(Globals.ATTRACTION_API_LINK, updatedAttraction);
return(RedirectToAction("Index"));
}
public ViewResult Edit(int cityId)
{
ViewData["CountriesList"] = GetCountriesList();
City city = GetHelper <City> .GetById(Globals.CITIES_API_LINK, cityId);
return(View("Edit", city));
}
public ViewResult Edit(int attractionId)
{
ViewData["CitiesList"] = GetCityList();
Attraction attraction = GetHelper <Attraction> .GetById(Globals.ATTRACTION_API_LINK, attractionId);
return(View("Edit", attraction));
}
public ViewResult Edit(int subjectId)
{
ViewData["TeacherList"] = GetTeachersList();
Subject subject = GetHelper <Subject> .GetById(Globals.SUBJECTS_API_LINK, subjectId);
return(View("EditSubject", subject));
}
//诊断管理
public List <Disease_records_Model> Get_zdgl()
{
string sql = $"select createtime,sum(_money) Total,count(id) Patients from Disease_records group by createtime";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Disease_records_Model>(dataSet.Tables[0]));
}
///Bll医生诊断 HCM添加
/// <summary>
/// 获取所属医生的患者资料 是否接诊 未0 已接诊1
/// </summary>
/// <param name="DoctorId">医生 id</param>
/// <param name="seate">是否接诊 未0 已接诊1</param>
/// <returns></returns>
public List <Patient_Model> GetDoctPatiList(int DoctorId, int seate)
{
string sql = $"select * from patient where DoctorId={DoctorId} and seate={seate}";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Patient_Model>(dataSet.Tables[0]));
}
//已接诊
public List <Disease_records_Model> Get_yes()
{
string sql = $"select *from Disease_records join patient on Disease_records.patient_Id=patient.id where seate=1";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Disease_records_Model>(dataSet.Tables[0]));
}
/// <summary>
/// 注册方法
/// </summary>
/// <param name="m">数据</param>
/// <returns></returns>
public int GetDoctorAdd(DoctorLog_Model m)
{
string sql = GetHelper.GetAddSql(m, "id");
int h = helper.ExceuteNonQuery(sql);
return(h);
}
/// <summary>
/// 获取所属医生金额表
/// </summary>
/// <param name="Doctor_ID">医生id</param>
/// <returns></returns>
public List <Doctor_money_Model> GetDoctPatiList(int Doctor_ID)
{
string sql = $"select * from Doctor_money where Doctor_ID={Doctor_ID}";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Doctor_money_Model>(dataSet.Tables[0]));
}
/// <summary>
/// 诊断报告表
/// </summary>
/// <param name="Disease_records_id">诊断记录表ID</param>
/// <returns></returns>
public List <Patient_Model> GetPati_DiagnosisList(int Disease_records_id)
{
string sql = $"select patient.*,describe,diagnosis from patient join Disease_records on patient.id=Disease_records.patient_Id where Disease_records.id={Disease_records_id}";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Patient_Model>(dataSet.Tables[0]));
}
//诊断列表
public List <Disease_records_Model> Get_Administrationlist(string sickdate)
{
string sql = $"select* from Disease_records join patient on Disease_records.patient_Id = patient.id where Disease_records.createtime = '{sickdate}' ";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Disease_records_Model>(dataSet.Tables[0]));
}
//反填
public T GetFanTable <T>(int id, string key)
{
string sql = GetHelper.GetFanSql <T>(id, key);
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <T>(dataSet.Tables[0])[0]);
}
private void textButtonOk_Click(object sender, EventArgs e)
{
try
{
_isOk = false;
if (string.IsNullOrEmpty(textBoxInput.Text))
{
MessageHelper.Popup(WinformRes.Input + ValidationRes.CanNotBeNull);
return;
}
if (VerificationRule.IsNullOrEmpty())
{
_isOk = true;
}
else
{
_isOk = GetHelper.VerifyPassword(textBoxInput.Text, VerificationRule, VerificationParams);
}
if (_isOk)
{
_inputText = textBoxInput.Text;
Close();
}
}
catch (Exception ex)
{
MessageHelper.Popup(ex.Message);
}
}
/// <summary>
/// 显示表信息
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public List <T> GetShowTable <T>()
{
string sql = GetHelper.GetShowSql <T>();
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <T>(dataSet.Tables[0]));
}
/// <summary>
/// 请求艺龙接口
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="request"></param>
/// <param name="method"></param>
/// <returns></returns>
private static string RequestInterface <T>(T request, string method)
{
var requestContent = new BaseRequestEntity <T>()
{
Local = EnumLocal.zh_CN, Version = 1.22, Request = request
};
var str = JsonHelper.SerializeObject(requestContent);
LogHelper.WriteLog("请求信息1：" + str, "ElongHotelInterface");
DateTime now = DateTime.Now;
long timestamp = ConvertDateTimeInt(now);
string sig = MD5(timestamp + MD5(str + ApiGatewayConfig.APPKEY) + ApiGatewayConfig.SECRETKEY);
StringBuilder sb = new StringBuilder();
sb.Append("format=").Append("json").Append("&");
sb.Append("method=").Append(method).Append("&");
sb.Append("signature=").Append(sig).Append("&");
sb.Append("user="******"&");
sb.Append("timestamp=").Append(timestamp).Append("&");
str = Uri.EscapeDataString(str);
sb.Append("data=").Append(str);
string url = string.Format(ApiGatewayConfig.URL_HTTPS, sb.ToString());
LogHelper.WriteLog("请求信息2：" + url, "ElongHotelInterface");
string res = GetHelper.GetUrl(url);
LogHelper.WriteLog("响应信息：" + res, "ElongHotelInterface");
return(res);
}
public List <StarshipLim> GetStarshipByPage(int page = 1)
{
var url = $"https://swapi.co/api/starships?page={page}";
var starList = GetAsync <StarWarsEntityListLim <StarshipLim> >(url).Result;
return(GetHelper.GetEnumeration(starList.Results));
}
public static string GetToken()
{
var timeStamp = GetTimeStamp();
string tokenStr;
if (AccesTokenTime != 0 && (timeStamp - AccesTokenTime) > 590 && (timeStamp - RefreshTokenTime) < 890)
{
tokenStr = GetHelper.GetUrl(ApiGatewayConfig.REFRESH_BASE_URL + "?AID="
+ ApiGatewayConfig.AID + "&SID=" + ApiGatewayConfig.SID
+ "&refresh_token=" + RefreshToken);
}
else
{
tokenStr = GetHelper.GetUrl(ApiGatewayConfig.TOKEN_BASE_URL + "?AID="
+ ApiGatewayConfig.AID + "&SID=" + ApiGatewayConfig.SID
+ "&KEY=" + ApiGatewayConfig.KEY);
}
ReturnToken rToken = JsonHelper.DeserializeJsonToObject <ReturnToken>(tokenStr);
AccessToken = rToken.Access_Token;
RefreshToken = rToken.Refresh_Token;
AccesTokenTime = timeStamp;
RefreshTokenTime = timeStamp;
return(AccessToken);
}
//好评评价
public Disease_records_Model Get_Acclaim(string id)
{
string sql = $"select * from Disease_records join patient on Disease_records.patient_Id=patient.id where Disease_records.id='{id}'";
DataSet dataSet = helper.GetDataSet(sql);
var list = GetHelper.DatatableTolist <Disease_records_Model>(dataSet.Tables[0]);
return(list[0]);
}
//健康档案
public Patient_Model Get_By(string id)
{
string sql = $"select * from patient join Disease_records on Disease_records.patient_Id=patient.id where patient.id='{id}'";
DataSet dataSet = helper.GetDataSet(sql);
var list = GetHelper.DatatableTolist <Patient_Model>(dataSet.Tables[0]);
return(list[0]);
}
public ViewResult ViewStudents(int classId, string className)
{
IEnumerable <Student> students = GetHelper <Student> .GetAll("students").Where(s => s.@class != null && [email protected] == classId);
SetClassName(classId);
ViewData["classId"] = classId;
return(View("Students", students));
}
/// <summary>
/// 医生绑定的银行卡
/// </summary>
/// <param name="id"></param>
/// <param name="Doctor_ID"></param>
/// <returns></returns>
public List <Doctor_bankcard_Model> GetBindBank(int id, int Doctor_ID)
{
string sql = $"select Doctor_bankcard.* from Doctor_money join Doctor_bankcard on Doctor_money.id = Doctor_bankcard.Doctor_moneyId where Doctor_money.id={id} and Doctor_ID={Doctor_ID}";
DataSet ds = helper.GetDataSet(sql);
List <Doctor_bankcard_Model> list = GetHelper.DatatableTolist <Doctor_bankcard_Model>(ds.Tables[0]);
//Doctor_money_Model doc_money = list[0];
return(list);
}
public ActionResult EditSubject(Subject subject)
{
Teacher teacher = GetHelper <Teacher> .GetById(Globals.TEACHERS_API_LINK, subject.teacher.id);
subject.teacher = teacher;
UpdateHelper <Subject> .UpdateEntity(Globals.SUBJECTS_API_LINK, subject);
return(RedirectToAction("Index"));
}
public List <Doctor_money_Model> GetDoctor_money(int Doctor_ID)
{
string sql = $"select * from Doctor_money where Doctor_ID = {Doctor_ID}";
DataSet ds = helper.GetDataSet(sql);
List <Doctor_money_Model> list = GetHelper.DatatableTolist <Doctor_money_Model>(ds.Tables[0]);
//Doctor_money_Model doc_money = list[0];
return(list);
}
// GET: Classes
public ViewResult Index()
{
IEnumerable <Class> classes = GetHelper <Class> .GetAll("classes");
classes = classes.OrderBy(c => c.id);
if (classes == null)
{
ModelState.AddModelError(string.Empty, "Wystąpił błąd serwera - brak danych w bazie.");
}
return(View(classes));
}
public IActionResult OutLogLogsExcel(int uid)
{
string sql = $"select l.id,l.uid,l.Create_Time,l.Log_Seate,l.Log_LP,l.Log_City from log_log l join users u on l.uid = u.uid where l.uid={uid};";
DataSet ds = sqlServerHelper.GetDataSet(sql);
DataTable dt = ds.Tables[0];
var stream = GetHelper.ExcelOut(dt);
var type = "application/ectet-stream";
var filename = $"{DateTime.Now.ToString("yyyyMMddhhmmss")}.xls";
return(File(stream.ToArray(), type, filename));
}
// GET: Subjects
public ViewResult Index()
{
IEnumerable <Subject> subjects = GetHelper <Subject> .GetAll("subjects");
subjects = subjects.OrderBy(s => s.id);
if (subjects == null)
{
ModelState.AddModelError(string.Empty, "Wystąpił błąd serwera - brak danych w bazie.");
}
return(View(subjects));
}
public IActionResult OutOperationLogsExcel(int uid)
{
string sql = $"select o.id,u.user_name,o.Create_Time,o.Ipadds,o.Content from operation_log o join users u on o.uid = u.uid where o.uid={uid};";
DataSet ds = sqlServerHelper.GetDataSet(sql);
DataTable dt = ds.Tables[0];
var stream = GetHelper.ExcelOut(dt);
var type = "application/ectet-stream";
var filename = $"{DateTime.Now.ToString("yyyyMMddhhmmss")}.xls";
return(File(stream.ToArray(), type, filename));
}
//#act
internal bool VerifyStartPassword(bool verifyByInput, string passwordVerificationRule, string password)
{
try
{
if (!passwordVerificationRule.IsNullOrEmpty())
{
if (passwordVerificationRule.Contains("；"))
{
passwordVerificationRule = passwordVerificationRule.Replace("；", ";");
}
if (passwordVerificationRule.Contains("，"))
{
passwordVerificationRule = passwordVerificationRule.Replace("，", ",");
}
var verifyType = passwordVerificationRule.SplitByTwoDifferentStrings("Type:", ";", true)[0];
var verifyParams = passwordVerificationRule.SplitByTwoDifferentStrings("Params:", ";", true)[0];
if (!EnumHelper.IsNameValid <PasswordEncryptionType>(verifyType))
{
throw new ArgumentException("passwordVerificationRule is not correct!");
}
if (verifyByInput)
{
StartPassword = verifyParams;
var dlg = new TextInputDialog();
{
dlg.Text = EasyWinAppRes.PlsInputPassword;
dlg.VerificationRule = verifyType;
dlg.VerificationParams = verifyParams;
dlg.ShowDialog();
return(dlg.IsOk);
}
}
else
{
if (GetHelper.VerifyPassword(password, verifyType, verifyParams))
{
StartPassword = verifyParams;
return(true);
}
else
{
return(false);
}
}
}
}
catch (Exception ex)
{
throw new ArgumentException("\n>> " + GetType().FullName + ".VerifyStartPassword Error: " + ex.Message);
}
return(true);
}
// GET: Attractions
public ActionResult Index()
{
IEnumerable <Attraction> attractions = GetHelper <Attraction> .GetAll("attractions");
attractions = attractions.OrderBy(a => a.id);
if (attractions == null)
{
ModelState.AddModelError(string.Empty, "Server error - no data in database.");
}
return(View(attractions));
}
public ActionResult EditClass(Class @class)
{
Class oldClass = GetHelper <Class> .GetById(Globals.CLASSES_API_LINK, @class.id);
var oldName = oldClass.name;
oldClass.name = @class.name;
UpdateHelper <Class> .UpdateEntity(Globals.CLASSES_API_LINK, oldClass);
TempData["message"] = "Pomyślnie dokonano edycji klasy " + oldName + " o id: " + @class.id;
return(RedirectToAction("Index"));
}
