public IActionResult ModifyEvaluationbyID(PatientEvaluation peln) { try { var list = _db.ModifyEvaluationbyID(peln); return(new JsonResult(new { result = 1, message = "修改成功" })); } catch (Exception exc) { _log.Fatal($"【添加失败异常】:{exc.Message}"); return(new JsonResult(new { result = 0, messge = exc.Message })); } }
public IActionResult AddEvaluationTable(PatientEvaluation peln) { try { peln.ID = Guid.NewGuid(); var list = _db.AddEvaluationTable(peln); _log.Info($"添加成功:{peln.ID }"); return(new JsonResult(new { result = 1, message = "添加成功!", id = peln.ID })); } catch (Exception exc) { _log.Fatal($"【添加失败异常】:{exc.Message}"); return(new JsonResult(new { result = 0, messge = exc.Message })); } }
/// <summary> /// 修改 /// </summary> /// <param name="id"></param> /// <param name="pevaton"></param> /// <returns></returns> public bool ModifyEvaluationbyID(PatientEvaluation pevaton) { var sql = @" UPDATE T_PE_PatientEvaluations SET PName = @PName, PSex = @PSex, Birthday = @Birthday, Age = @Age, Profession = @Profession, FIDCard = @FIDCard, Citizenship = @Citizenship, HJAddress = @HJAddress, FAddress = @FAddress, Mailbox = @Mailbox, FTel = @FTel, FPhone = @FPhone, FMarriage = @FMarriage, FContacts = @FContacts, FContactsTel = @FContactsTel, Relation = @Relation, Faith = @Faith, Language = @Language, Education = @Education, Medicare = @Medicare, BloodType = @BloodType, Transfusion = @Transfusion, DrugAllergy = @DrugAllergy, FoodAllergy = @FoodAllergy, Smoke = @Smoke, Drink = @Drink, RestsBX = @RestsBX, RestsGMSW = @RestsGMSW, RestsGMYW = @RestsGMYW, RestsSmoke = @RestsSmoke WHERE ID = @id"; var pars = new List <SqlParameter>(); pars.Add(new SqlParameter() { ParameterName = "@PName", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.PName) }); pars.Add(new SqlParameter() { ParameterName = "@PSex", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.PSex) }); pars.Add(new SqlParameter() { ParameterName = "@Birthday", SqlDbType = System.Data.SqlDbType.DateTime, Value = pevaton.Birthday }); pars.Add(new SqlParameter() { ParameterName = "@Age", SqlDbType = System.Data.SqlDbType.Int, Value = pevaton.Age }); pars.Add(new SqlParameter() { ParameterName = "@Profession", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Profession) }); pars.Add(new SqlParameter() { ParameterName = "@FIDCard", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FIDCard) }); pars.Add(new SqlParameter() { ParameterName = "@Citizenship", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Citizenship) }); pars.Add(new SqlParameter() { ParameterName = "@HJAddress", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.HJAddress) }); pars.Add(new SqlParameter() { ParameterName = "@FAddress", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FAddress) }); pars.Add(new SqlParameter() { ParameterName = "@Mailbox", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Mailbox) }); pars.Add(new SqlParameter() { ParameterName = "@FTel", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FTel) }); pars.Add(new SqlParameter() { ParameterName = "@FPhone", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FPhone) }); pars.Add(new SqlParameter() { ParameterName = "@FMarriage", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FMarriage) }); pars.Add(new SqlParameter() { ParameterName = "@FContacts", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FContacts) }); pars.Add(new SqlParameter() { ParameterName = "@FContactsTel", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FContactsTel) }); pars.Add(new SqlParameter() { ParameterName = "@Relation", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Relation) }); pars.Add(new SqlParameter() { ParameterName = "@Faith", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Faith) }); pars.Add(new SqlParameter() { ParameterName = "@Language", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Language) }); pars.Add(new SqlParameter() { ParameterName = "@Education", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Education) }); pars.Add(new SqlParameter() { ParameterName = "@Medicare", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Medicare) }); pars.Add(new SqlParameter() { ParameterName = "@BloodType", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.BloodType) }); pars.Add(new SqlParameter() { ParameterName = "@Transfusion", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Transfusion) }); pars.Add(new SqlParameter() { ParameterName = "@DrugAllergy", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.DrugAllergy) }); pars.Add(new SqlParameter() { ParameterName = "@FoodAllergy", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FoodAllergy) }); pars.Add(new SqlParameter() { ParameterName = "@Smoke", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Smoke) }); pars.Add(new SqlParameter() { ParameterName = "@Drink", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Drink) }); pars.Add(new SqlParameter() { ParameterName = "@RestsBX", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.RestsBX) }); pars.Add(new SqlParameter() { ParameterName = "@RestsGMSW", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.RestsGMSW) }); pars.Add(new SqlParameter() { ParameterName = "@RestsGMYW", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.RestsGMYW) }); pars.Add(new SqlParameter() { ParameterName = "@RestsSmoke", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.RestsSmoke) }); pars.Add(new SqlParameter() { ParameterName = "@id", SqlDbType = System.Data.SqlDbType.UniqueIdentifier, Value = pevaton.ID }); return(_db.SavaData(sql, pars.ToArray()) > 0 ? true : false); }
/// <summary> /// 添加就诊单到数据库 /// </summary> /// <param name="patientevaluation"></param> /// <returns></returns> public bool AddEvaluationTable(PatientEvaluation pevaton) { var sql = @"INSERT INTO T_PE_PatientEvaluations ( [ID], [PName] , [PSex] , [Birthday] , [Age] , [Profession] , [FIDCard] , [Citizenship] , [HJAddress] , [FAddress] , [Mailbox] , [FTel] , [FPhone] , [FMarriage] , [FContacts] , [FContactsTel] , [Relation] , [Faith] , [Language] , [Education] , [Medicare] , [BloodType] , [Transfusion] , [DrugAllergy] , [FoodAllergy] , [Smoke] , [Drink] , [RestsBX] , [RestsGMSW] , [RestsGMYW] , [RestsSmoke] ) VALUES ( @ID, @PName , @PSex , @Birthday , @Age , @Profession , @FIDCard , @Citizenship , @HJAddress , @FAddress , @Mailbox , @FTel , @FPhone , @FMarriage , @FContacts , @FContactsTel , @Relation , @Faith , @Language , @Education , @Medicare , @BloodType , @Transfusion , @DrugAllergy , @FoodAllergy , @Smoke , @Drink , @RestsBX , @RestsGMSW , @RestsGMYW , @RestsSmoke )"; var pars = new List <SqlParameter>(); pars.Add(new SqlParameter() { ParameterName = "@ID", SqlDbType = System.Data.SqlDbType.UniqueIdentifier, Value = pevaton.ID }); pars.Add(new SqlParameter() { ParameterName = "@PName", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.PName) }); pars.Add(new SqlParameter() { ParameterName = "@PSex", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.PSex) }); pars.Add(new SqlParameter() { ParameterName = "@Birthday", SqlDbType = System.Data.SqlDbType.DateTime, Value = pevaton.Birthday }); pars.Add(new SqlParameter() { ParameterName = "@Age", SqlDbType = System.Data.SqlDbType.Int, Value = pevaton.Age }); pars.Add(new SqlParameter() { ParameterName = "@Profession", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Profession) }); pars.Add(new SqlParameter() { ParameterName = "@FIDCard", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FIDCard) }); pars.Add(new SqlParameter() { ParameterName = "@Citizenship", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Citizenship) }); pars.Add(new SqlParameter() { ParameterName = "@HJAddress", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.HJAddress) }); pars.Add(new SqlParameter() { ParameterName = "@FAddress", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FAddress) }); pars.Add(new SqlParameter() { ParameterName = "@Mailbox", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Mailbox) }); pars.Add(new SqlParameter() { ParameterName = "@FTel", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FTel) }); pars.Add(new SqlParameter() { ParameterName = "@FPhone", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FPhone) }); pars.Add(new SqlParameter() { ParameterName = "@FMarriage", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FMarriage) }); pars.Add(new SqlParameter() { ParameterName = "@FContacts", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FContacts) }); pars.Add(new SqlParameter() { ParameterName = "@FContactsTel", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FContactsTel) }); pars.Add(new SqlParameter() { ParameterName = "@Relation", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Relation) }); pars.Add(new SqlParameter() { ParameterName = "@Faith", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Faith) }); pars.Add(new SqlParameter() { ParameterName = "@Language", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Language) }); pars.Add(new SqlParameter() { ParameterName = "@Education", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Education) }); pars.Add(new SqlParameter() { ParameterName = "@Medicare", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Medicare) }); pars.Add(new SqlParameter() { ParameterName = "@BloodType", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.BloodType) }); pars.Add(new SqlParameter() { ParameterName = "@Transfusion", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Transfusion) }); pars.Add(new SqlParameter() { ParameterName = "@DrugAllergy", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.DrugAllergy) }); pars.Add(new SqlParameter() { ParameterName = "@FoodAllergy", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.FoodAllergy) }); pars.Add(new SqlParameter() { ParameterName = "@Smoke", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Smoke) }); pars.Add(new SqlParameter() { ParameterName = "@Drink", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.Drink) }); pars.Add(new SqlParameter() { ParameterName = "@RestsBX", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.RestsBX) }); pars.Add(new SqlParameter() { ParameterName = "@RestsGMSW", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.RestsGMSW) }); pars.Add(new SqlParameter() { ParameterName = "@RestsGMYW", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.RestsGMYW) }); pars.Add(new SqlParameter() { ParameterName = "@RestsSmoke", SqlDbType = System.Data.SqlDbType.VarChar, Value = CheckNull(pevaton.RestsSmoke) }); return(_db.SavaData(sql, pars.ToArray()) > 0 ? true : false); }