public static void SaveRecord(RecordView recordToSave) { RecordDAL recordHandler = new RecordDAL(); Random _random = new Random(); VaccineView recordVaccine = recordToSave.Vaccines.FirstOrDefault(); if (recordVaccine != null) { VaccineView vaccine = VaccineManager.GetVaccine(recordVaccine.Name); if (vaccine != null) { Record record = new Record { isVaccine = true, recordNumber = "RCRD" + _random.Next(20, 300), notes = "", petId = new Guid(recordToSave.PetId), status = "open", tags = GetAnualTags(recordToSave.Tags, recordToSave.Vaccines), type = "vaccine", vaccineId = new Guid(vaccine.Id), createdDate = DateTime.Now, createdBy = Constant.ADMIN_EMAIL, }; recordHandler.Post(record); } } }
// Used for checking exixtance of the Record in the Database public int checkExistance_BAL(int employeeid) { RecordDAL rDal = new RecordDAL(); try { return rDal.checkExistance(employeeid); } catch (Exception ex) { throw; } finally { rDal = null; } }
//Used for Inserting Record in the Database public int InsertRecord_BAL( string firstname, string lastname, DateTime dateofbirth,DateTime hiredate , string email, string phonenumber) { RecordDAL rDal = new RecordDAL(); try { return rDal.InsertRecord( firstname,lastname, dateofbirth, hiredate, email, phonenumber); } catch { throw; } finally { rDal = null; } }
public void DeleteEmployee(int employeeid) { RecordDAL rDal = new RecordDAL(); try { rDal.DeleteEmployee(employeeid); } catch { throw; } finally { rDal = null; } }
public DataTable RetrieveRecords() { //Creating the object of DAL file. RecordDAL rdAL = new RecordDAL(); try { //Calling the method of DAl using DAL object //and return the result to the caller of the method. return rdAL.RetrieveRecords(); } catch { throw; } finally { //rdAL = null; } }
//JSON数据格式 //{ // Username: string // Description:string // Time:DateTime // LocationStr string(四川_成都_郫县) // Answers:string("010100") // PicNames:string的JArray //} public void ProcessRequest(HttpContext context) { StreamReader reader = new StreamReader(context.Request.InputStream, Encoding.UTF8); string requestStr = reader.ReadToEnd(); JObject jObj = JObject.Parse(requestStr); string username = jObj["Username"].ToString(); string description = jObj["Description"].ToString(); DateTime time = DateTime.Parse(jObj["Time"].ToString()); string locationStr = jObj["LocationStr"].ToString(); string answers = jObj["Answers"].ToString(); JArray picNames = JArray.Parse(jObj["PicNames"].ToString()); //添加到自检记录 RecordModel record = new RecordModel(); record.Answers = answers; record.Description = description; //如果locationStr为null,则返回"000000"(中国),否则解析并保存 if (string.IsNullOrEmpty(locationStr)) { record.Citycode = "000000"; } else { record.Citycode = LocationDAL.GetLocalId(locationStr); } record.Time = time; record.User_id = UserDAL.GetByUsername(username).User_id; long record_id = RecordDAL.Insert(record); //添加自检图片 foreach (string picName in picNames) { PhotoModel photo = new PhotoModel(); photo.Path = picName; photo.Record_id = record_id; PhotoDAL.Insert(photo); } //返回Record_id给移动端 JObject jObjSend = new JObject(); jObjSend.Add("Record_id", record_id); byte[] buf = Encoding.UTF8.GetBytes(jObjSend.ToString()); context.Response.OutputStream.Write(buf, 0, buf.Length); Thread thread = new Thread(() => { List <CVResultModel> results = new List <CVResultModel>(); //检查图片是否分析完成(是否Insert到CVResult中) const int WAIT_TIME = 240; //等待时间(如果240秒某张图片都没有传输成功且分析完成,则放弃) foreach (string picName in picNames) { //轮询 for (int i = 0; i < WAIT_TIME; i++) { if (null != CVResultDAL.GetById(picName)) { results.Add(CVResultDAL.GetById(picName)); break; } Thread.Sleep(1000); } } //计算分数并保存 float score = ScoreUtil.GetScore(results); RecordDAL.UpdateScore(score, record_id); }); thread.Start(); }
public static List <RecordView> GetRecords(string name) { List <RecordView> recordViews = new List <RecordView>(); RecordDAL recordHandler = new RecordDAL(); PetDAL petHandler = new PetDAL(); List <Record> records = recordHandler.GetList(); List <Pet> petList = petHandler.GetList(); Pet pet = petList.Where(p => p.name.Trim() == name).FirstOrDefault(); if (pet != null && !string.IsNullOrEmpty(pet.name)) { records = records.Where(r => r.petId == pet.id).ToList(); foreach (Record record in records) { RecordView recordView = new RecordView() { Id = record.id.ToString(), IsVaccine = record.isVaccine.Value, Name = record.recordNumber == null ? "" : record.recordNumber.Trim(), Notes = record.notes == null ? "" : record.notes.Trim(), RecordNumber = record.recordNumber.Trim(), Status = record.status == null ? "" : record.status.Trim(), Tags = record.tags != null?record.tags.Split(',').ToList() : new List <string>(), Type = record.type == null ? "" : record.type.Trim(), }; if (record.isVaccine.Value) { VaccineDAL vaccineHandler = new VaccineDAL(); List <Vaccine> vaccines = vaccineHandler.GetList(); vaccines = vaccines.Where(v => v.id == record.vaccineId).ToList(); List <VaccineView> vaccineViews = new List <VaccineView>(); foreach (var vaccine in vaccines) { vaccineViews.Add(new VaccineView { Cost = vaccine.cost.ToString(), Description = vaccine.description == null ? "" : vaccine.description.Trim(), Disease = vaccine.disease == null ? "" : vaccine.disease.Trim(), Id = vaccine.id.ToString(), Living = vaccine.living == true ? "Is living" : "Not living", Name = vaccine.name == null ? "" : vaccine.name.Trim(), Preparation = vaccine.preparation == null ? "" : vaccine.preparation.Trim(), Type = vaccine.type == null ? "" : vaccine.type.Trim(), }); } recordView.Vaccines = vaccineViews; } recordView.Tags = recordView.Tags.Select(s => s.Trim()).ToList(); recordViews.Add(recordView); } } if (recordViews.Count >= 1) { return(recordViews); } else { return(null); } }
/// <summary> /// 窗口加载时:通过GET请求的"record_id"参数到数据库取得相应的自检信息并显示 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { long record_id; if (long.TryParse(Request.Params["record_id"], out record_id)) { //调用数据库访问类查询该主键对应的自检记录 RecordModel record = RecordDAL.GetById(record_id); PhotoModel[] photos = PhotoDAL.GetAllByRecordId(record_id); //原图片 List <string> srcUrls = new List <string>(); List <string> dstUrls = new List <string>(); foreach (var photo in photos) { srcUrls.Add("~/ImageWebForm.aspx?fileType=src&picName=" + photo.Path); dstUrls.Add("~/ImageWebForm.aspx?fileType=dst&picName=" + photo.Path); } //将图片绑定到控件上 dl_srcImgs.DataSource = srcUrls; dl_srcImgs.DataBind(); dl_dstImgs.DataSource = dstUrls; dl_dstImgs.DataBind(); //取得该自检对应图片的所有处理结果 List <CVResultModel> results = new List <CVResultModel>(); foreach (var photo in photos) { var result = CVResultDAL.GetById(photo.Path); if (result != null) { results.Add(result); } } //分析处理结果 float score = ScoreUtil.GetScore(results); //结论 StringBuilder builder = new StringBuilder(); //builder.AppendFormat("系统分析得分:{0:f2}", score).AppendLine(); var group = Severity.Group(score); switch (group) { case Severity.SeverityEnum.Normal: builder.AppendLine("牙齿正常,请注意保持"); break; case Severity.SeverityEnum.Light: builder.AppendLine("有少量龋齿或程度较轻"); break; case Severity.SeverityEnum.Medium: builder.AppendLine("有一定龋齿或程度中等"); break; case Severity.SeverityEnum.Severe: builder.AppendLine("有大量龋齿或龋坏严重"); break; default: break; } if (group != Severity.SeverityEnum.Normal) { builder.AppendLine("可能为色素沉着,牙石或牙垢,保持口腔清洁或前往正规医院洗牙可以让结果更准确"); } lbl_conclusion.Text = builder.ToString().Replace(Environment.NewLine, "<br>"); //医生意见 DiagnosisModel[] diagnoses = DiagnosisDAL.GetAllByRecordId(record_id); List <string> comments = new List <string>(); foreach (var diagnosis in diagnoses) { string item = string.Format("{0} {1}", diagnosis.Time.ToString(), DoctorDAL.GetById(diagnosis.Doc_id).RealName) + Environment.NewLine + diagnosis.Result; comments.Add(item); } dl_comments.DataSource = comments; dl_comments.DataBind(); } else { //record_id出错 } }
public void ProcessRequest(HttpContext context) { StreamReader reader = new StreamReader(context.Request.InputStream, Encoding.UTF8); string requestStr = reader.ReadToEnd(); //返回所有自检结果,其中本地区的置前 if ("ListAll".Equals(requestStr)) { ////获取IP地理信息 //string hostIP = context.Request.UserHostAddress; //IPRecord ip = HttpHelper.GetIPRecord(hostIP); ////通过IP地理信息获取所在区域的编号 //RecordModel[] recordModels = null; //if (string.IsNullOrEmpty(ip.Province)) //{ // //返回所有的自检 // recordModels = RecordDAL.GetAll(); //} //else if (string.IsNullOrEmpty(ip.City)) //{ // //返回指定省份的自检 // recordModels = RecordDAL.GetAllProvinceFirst(ip.Province); //} //else if (string.IsNullOrEmpty(ip.District)) //{ // //返回指定城市的自检 // recordModels = RecordDAL.GetAllCityFirst(ip.City); //} //else //{ // //返回指定区域的自检 // recordModels = RecordDAL.GetAllAreaFirst(ip.District); //} RecordModel[] recordModels = RecordDAL.GetAll(); JObject jObj = new JObject(); jObj.Add("count", recordModels.Length); JArray jArr = new JArray(); foreach (RecordModel recordModel in recordModels) { jArr.Add(JsonConvert.SerializeObject(new ExRecordModel(recordModel))); } jObj.Add("content", jArr); byte[] bytes = Encoding.UTF8.GetBytes(jObj.ToString()); context.Response.OutputStream.Write(bytes, 0, bytes.Length); } else if (requestStr.StartsWith("Patient: ")) { //返回指定用户的自检信息 string username = requestStr.Substring("Patient: ".Length); RecordModel[] recordModels = RecordDAL.GetByUsername(username); JObject jObj = new JObject(); jObj.Add("count", recordModels.Length); JArray jArr = new JArray(); foreach (RecordModel recordModel in recordModels) { jArr.Add(JsonConvert.SerializeObject(recordModel)); } jObj.Add("content", jArr); byte[] bytes = Encoding.UTF8.GetBytes(jObj.ToString()); context.Response.OutputStream.Write(bytes, 0, bytes.Length); } else if (requestStr.StartsWith("Record_id: ")) { //返回指定编号的自检信息 long record_id; if (long.TryParse(requestStr.Substring("Record_id: ".Length), out record_id)) { var record = RecordDAL.GetById(record_id); string json = JsonConvert.SerializeObject(record); byte[] bytes = Encoding.UTF8.GetBytes(json); context.Response.OutputStream.Write(bytes, 0, bytes.Length); } } else { //返回指定id对应的自检图片 long id = long.Parse(requestStr); PhotoModel[] photos = PhotoDAL.GetAllByRecordId(id); JObject jObj = new JObject(); jObj.Add("count", photos.Length); JArray jArr = new JArray(); foreach (PhotoModel photo in photos) { jArr.Add(JsonConvert.SerializeObject(photo)); } jObj.Add("content", jArr); byte[] bytes = Encoding.UTF8.GetBytes(jObj.ToString()); context.Response.OutputStream.Write(bytes, 0, bytes.Length); } }
//Updating Record public int UpdateRecord_BAL( int employeeid, string firstname, string lastname, string email, Int32 phonenumber) { RecordDAL rDal = new RecordDAL(); try { return rDal.UpdateRecord( employeeid, firstname, lastname, email, phonenumber); } catch { throw; } finally { rDal = null; } }