/// <summary> /// 网站访问统计 /// </summary> /// <returns></returns> public ActionResult WebVisit() { VisitRecord visitModel = new VisitRecord(); visitModel.VisitReffer = Request.QueryString["oldlink"].ToString(); visitModel.VisitRefferType = int.Parse(GetVisitReferrerType(Request.QueryString["oldlink"].ToString())); visitModel.VisitResolution = Request.QueryString["s"].ToString(); visitModel.VisitURL = Request.QueryString["id"].ToString(); visitModel.VisitTimeIn = System.DateTime.Now; visitModel.VisitIP = _services.WebHelper.GetCurrentIpAddress(); visitModel.VisitOS = Request.QueryString["sys"].ToString(); visitModel.VisitTitle = Request.QueryString["title"].ToString(); visitModel.VisitBrowerType = Request.QueryString["b"].ToString(); visitModel.VisitRefferKeyWork = ""; visitModel.VisitProvince = Request.QueryString["p"].ToString(); visitModel.VisitCity = Request.QueryString["c"].ToString(); // 获取source后面的内容] string url = Request.QueryString["id"].ToString(); if (url.IndexOf("fromsource=") > 0) { int startindex = url.IndexOf("fromsource="); int endindex = url.Length - startindex - 11; string id = url.Substring(startindex + 11, endindex); visitModel.FromSource = id; } // 这里执行添加到数据库的操作并返回添加以后ID信息 this._visitRecordService.Value.InsertVisitRecord(visitModel); int newID = visitModel.Id; return(Json(newID.ToString(), JsonRequestBehavior.AllowGet)); }
private void RenderMyViewData(VisitRecord model) { ViewData.Add("CognitiveChannel", new SelectList(EnumHelper.GetItemValueList <EnumCognitiveChannel>(), "Key", "Value", model.CognitiveChannel)); ViewData.Add("PriceResponse", new SelectList(EnumHelper.GetItemValueList <EnumPriceResponse>(), "Key", "Value", model.PriceResponse)); ViewData.Add("VisitWay", new SelectList(EnumHelper.GetItemValueList <EnumVisitWay>(), "Key", "Value", model.VisitWay)); ViewData.Add("FollowStep", new SelectList(EnumHelper.GetItemValueList <EnumFollowStep>(), "Key", "Value", model.FollowStep)); ViewData.Add("FollowLevel", new SelectList(EnumHelper.GetItemValueList <EnumFollowLevel>(), "Key", "Value", model.FollowLevel)); }
// // GET: /Crm/VisitRecord/Create public ActionResult Create() { var model = new VisitRecord(); this.RenderMyViewData(model); return(View("Edit", model)); }
public VisitRecord GetRecord() { VisitRecord ret = new VisitRecord(); ret.title = DropDownList_type.SelectedItem.Text; ret.visit_date = FindPicker(PickerAndCalendar_visitDate).SelectedDate; ret.remark = TextBox_remark.Text; return(ret); }
/// <summary> /// 添加 /// </summary> /// <param name="visitRecord"></param> /// <returns>添加是否成功</returns> public bool Insert(VisitRecord visitRecord) { //不插入访问时间,数据库自动填充默认值 var visit = new { visit_record_id = visitRecord.visit_record_id, desk_id = visitRecord.desk_id, consumer_num = visitRecord.consumer_num }; string SQL = SQLBuilder.BuildInsertSQL(visit, TableName); int result = Connection.ExecuteSql(SQL, (Object)visit); return(result == 1 ? true : false); }
protected void Grid_visitRecord_ItemDataBound(object sender, ComponentArt.Web.UI.GridItemDataBoundEventArgs e) { VisitRecord r = (VisitRecord)e.DataItem; TdUserResult res = userService.GetUserById(r.user_id); if (res.result) { e.Item.ToArray()[2] = res.user.real_name; } }
public ActionResult Select(int id) { VisitRecord visitRecord = db.VisitRecords.Find(id); if (visitRecord == null) { return(HttpNotFound()); } return(View(visitRecord)); }
public ActionResult Create() { var model = new VisitRecord(); this.RenderMyViewData(model); var users = this.IDKLManagerService.GetCustomerList().Select(c => new { CustomerName = c.CustomerName }); ViewData.Add("CustomerName", new SelectList(users, "CustomerName", "CustomerName")); return(View("Edit", model)); }
/// <summary> /// Deletes an visitRecord /// </summary> /// <param name="visitRecord">VisitRecord</param> public virtual void DeleteVisitRecord(VisitRecord visitRecord) { if (visitRecord == null) { throw new ArgumentNullException("visitRecord"); } _visitRecordRepository.Delete(visitRecord); //event notification _eventPublisher.EntityDeleted(visitRecord); }
public void SaveVisitRecord(VisitRecord visitRecord) { using (var dbContext = new CrmDbContext()) { if (visitRecord.ID > 0) { dbContext.Update <VisitRecord>(visitRecord); } else { dbContext.Insert <VisitRecord>(visitRecord); } } }
public async Task <IActionResult> Edit(string id, [Bind("VisitReason,Prescription,Visitid,VisitDate,Visited,PatientId,DoctorId")] VisitRecord visitRecord) { if (id != visitRecord.Visitid) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(visitRecord); await _context.SaveChangesAsync(); if (visitRecord.Visited == true) { //Clear appointment once patient visits the doctor int patient_id = visitRecord.PatientId; var appointment_context = _context.Appointment.Where(a => a.PatientId == patient_id).FirstOrDefault(); _context.Appointment.Remove(appointment_context); await _context.SaveChangesAsync(); var record = new Billing { BillingAmount = 50, BillingDate = DateTime.UtcNow, PatientId = visitRecord.PatientId, Paid = false }; _context.Add(record); await _context.SaveChangesAsync(); //return RedirectToAction("Create", "Billings"); return(RedirectToAction("Index", "VisitRecords")); } } catch (DbUpdateConcurrencyException) { if (!VisitRecordExists(visitRecord.Visitid)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["DoctorId"] = new SelectList(_context.Doctor, "DoctorId", "DoctorEmail", visitRecord.DoctorId); ViewData["PatientId"] = new SelectList(_context.Patient, "PatientId", "PatientEmail", visitRecord.PatientId); return(View(visitRecord)); }
public ActionResult Create(FormCollection collection) { var model = new VisitRecord(); this.TryUpdateModel <VisitRecord>(model); try { this.IDKLManagerService.AddVisitRecord(model); } catch (HYZK.FrameWork.Common.BusinessException e) { this.ModelState.AddModelError(e.Name, e.Message); return(View("Edit", model)); } return(this.RefreshParent()); }
/// <summary> /// 新增一条拜访记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button_addRecord_Click(object sender, EventArgs e) { //DataSet ds = new DataSet(); //dataCommon.GetAllData("select * from _Customers where id=" + CustomerInfo_edit.CustomerId, ds, CustomersData._CUSTOMERS_TABLE); //dataCommon.GetAllData("select top 1 * from _VisitRecord", ds, VisitRecordData._VISITRECORD_TABLE); //dataCommon.GetAllData(string.Format("select * from _VisitPlan where CustomerId={0} and PlanType=1 and PlanStatus='{1}'", CustomerInfo_edit.CustomerId, CustomerService.PLANSTATUS_PENDING), ds, VisitPlanData._VISITPLAN_TABLE); //// 修改客户的最近访问信息 [3/10/2009] //DataRow dr_customer = ds.Tables[CustomersData._CUSTOMERS_TABLE].Rows[0]; //dr_customer[CustomersData.LASTVISITDATE_FIELDS] = DateTime.Now; //dr_customer[CustomersData.LASTVISITINFO_FIELDS] = VisitRecordInfo_addVisit.Remark; //DataRow dr = ds.Tables[VisitRecordData._VISITRECORD_TABLE].NewRow(); //dr[VisitRecordData.CUSTOMERID_FIELDS] = CustomerInfo_edit.CustomerId; //dr[VisitRecordData.PERSONID_FIELDS] = LoginSession.GetCurrentUser(this).PersonId; //dr[VisitRecordData.REMARK_FIELDS] = VisitRecordInfo_addVisit.Remark; //dr[VisitRecordData.TITLE_FIELDS] = VisitRecordInfo_addVisit.RecordTitle; //dr[VisitRecordData.VISITDATE_FIELDS] = VisitRecordInfo_addVisit.VisitDate; //ds.Tables[VisitRecordData._VISITRECORD_TABLE].Rows.Add(dr); VisitRecord record = VisitRecordInfo_addVisit.GetRecord(); record = customerService.AddVisitRecord(the_customer.id, record.title, record.remark, record.visit_date, me.id); //foreach (DataRow dr_status in ds.Tables[VisitPlanData._VISITPLAN_TABLE].Rows) //{ // dr_status[VisitPlanData.PLANSTATUS_FIELDS] = CustomerService.PLANSTATUS_VISITED; //} //DataRow dr_plan = ds.Tables[VisitPlanData._VISITPLAN_TABLE].NewRow(); //dr_plan[VisitPlanData.CUSTOMERID_FIELDS] = CustomerInfo_edit.CustomerId; //dr_plan[VisitPlanData.PERSONID_FIELDS] = LoginSession.GetCurrentUser(this).PersonId; //dr_plan[VisitPlanData.PLANSTATUS_FIELDS] = CustomerService.PLANSTATUS_PENDING; //dr_plan[VisitPlanData.PLANTYPE_FIELDS] = CustomerService.PLANTYPE_VISITPLAN; //dr_plan[VisitPlanData.REMARK_FIELDS] = TextBox_addVisit_nextVisit.Text; //dr_plan[VisitPlanData.VISITPLANDATE_FIELDS] = FindPicker(PickerAndCalendar_addVisitRecord_nextVisit).SelectedDate; //ds.Tables[VisitPlanData._VISITPLAN_TABLE].Rows.Add(dr_plan); //dataCommon.UpdateData(ds); //AddLoadMessage("您成功添加了拜访记录"); VisitRecordInfo_addVisit.Cleanup(); CustomerDataBind(); }
public async Task <IActionResult> Edit(int id, [Bind("ApptId,ApptDate,AppointmentReason,PatientEmail,PatientId,VisitRecord,DoctorId")] Appointment appointment) { if (id != appointment.ApptId) { return(NotFound()); } if (ModelState.IsValid) { try { if (appointment.VisitRecord == true) { var addtovisit = new VisitRecord { DoctorId = appointment.DoctorId, PatientId = (int)appointment.PatientId, Prescription = "N/A", VisitDate = appointment.ApptDate, VisitReason = appointment.AppointmentReason, Visited = false, Visitid = Guid.NewGuid().ToString() }; _context.Add(addtovisit); await _context.SaveChangesAsync(); } _context.Update(appointment); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AppointmentExists(appointment.ApptId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["DoctorId"] = new SelectList(_context.Doctor, "DoctorId", "DoctorEmail", appointment.DoctorId); ViewData["PatientId"] = new SelectList(_context.Patient, "PatientId", "PatientEmail", appointment.PatientId); return(View(appointment)); }
//public string RecordId //{ // set // { // ViewState["RecordId"] = value; // VisitInfoBind(); // } // get // { // if (null == ViewState["RecordId"]) // return null; // return ViewState["RecordId"].ToString(); // } //} public void VisitInfoBind(VisitRecord record) { //if (null == RecordId) // return; BaseInfoBind(); //DataSet ds = new DataSet(); //dataCommon.GetAllData(string.Format("select * from _VisitRecord where Id={0}", RecordId), ds, VisitRecordData._VISITRECORD_TABLE); //if (ds.Tables[VisitRecordData._VISITRECORD_TABLE].Rows.Count == 0) // throw new Exception(string.Format("没有找到ID是{0}的拜访记录", RecordId)); //DataRow dr = ds.Tables[VisitRecordData._VISITRECORD_TABLE].Rows[0]; FocusItemByText(DropDownList_type, record.title); TextBox_remark.Text = record.remark; FindPicker(PickerAndCalendar_visitDate).SelectedDate = record.visit_date; //cal_visit = (ComponentArt.Web.UI.Calendar)PickerAndCalendar_visitDate.FindControl("Picker1"); //cal_visit.SelectedDate = Convert.ToDateTime(dr[VisitRecordData.VISITDATE_FIELDS]); //PersonId = dr[VisitRecordData.PERSONID_FIELDS].ToString(); }
private void RenderMyViewData(VisitRecord model, bool isBasic = false) { ViewData.Add("VisitWay", new SelectList(EnumHelper.GetItemValueList <EnumVisitWay>(), "Key", "Value", model.VisitWay)); ViewData.Add("FollowLevel", new SelectList(EnumHelper.GetItemValueList <EnumFollowLevel>(), "Key", "Value", model.FollowLevel)); ViewData.Add("FollowStep", new SelectList(EnumHelper.GetItemValueList <EnumFollowStep>(), "Key", "Value", model.FollowStep)); ViewData.Add("ProductType", new SelectList(EnumHelper.GetItemValueList <EnumProductType>(), "Key", "Value", model.ProductType)); ViewData.Add("Focus", new SelectList(EnumHelper.GetItemList <EnumFocus>(), "Key", "Value", (EnumFocus)model.Focus)); ViewData.Add("CognitiveChannel", new SelectList(EnumHelper.GetItemList <EnumCognitiveChannel>(), "Key", "Value", (EnumCognitiveChannel)model.CognitiveChannel)); ViewData.Add("PriceResponse", new SelectList(EnumHelper.GetItemValueList <EnumPriceResponse>(), "Key", "Value", model.PriceResponse)); ViewData.Add("AreaDemand", new SelectList(EnumHelper.GetItemValueList <EnumAreaDemand>(), "Key", "Value", model.AreaDemand)); ViewData.Add("Motivation", new SelectList(EnumHelper.GetItemValueList <EnumMotivation>(), "Key", "Value", model.Motivation)); ViewData.Add("ProjectId", new SelectList(this.CrmService.GetProjectList(), "Id", "Name", model.ProjectId)); if (isBasic) { return; } ViewData.Add("CityId", new SelectList(this.CityDic.Values, "Id", "Name", model.CityId)); if (model.CityId == 0) { model.CityId = this.CityDic.First().Key; } var areas = this.AreaDic.Values.Where(a => a.CityId == model.CityId); ViewData.Add("AreaId", new SelectList(areas, "Id", "Name", model.AreaId)); var request = new CustomerRequest(); request.Customer.UserId = this.UserContext.LoginInfo.UserID; var customerList = this.CrmService.GetCustomerList(request).ToList(); customerList.ForEach(c => c.Name = string.Format("{0}({1})", c.Name, c.Tel)); ViewData.Add("CustomerId", new SelectList(customerList, "Id", "Name", model.CustomerId)); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Session["HostID"] = Request["HostID"].ToString(); using (DataClassesDataContext db = new DataClassesDataContext()) { VisitRecord vs = new VisitRecord(); vs.UserID = Session["UserID"].ToString(); vs.HostID = Session["HostID"].ToString(); vs.Date = DateTime.Now.Date; db.VisitRecord.InsertOnSubmit(vs); db.SubmitChanges(); } } Init1(); Init2(); Init3(); Init4(); Init5(); Init6(); }
/// <summary> /// 插入访问记录,更新桌子状态 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { if (Regex.IsMatch(NumTextBox.Text, @"^\d+\.\d+\z|^\d+\z")) { //插入访问记录 VisitRecord visitRecord = new VisitRecord(); visitRecord.desk_id = this.desk_id; visitRecord.consumer_num = Convert.ToInt32(NumTextBox.Text); visitRecordDao.Insert(visitRecord); //更新桌子状态 Desk desk = new Desk(); desk.desk_id = this.desk_id; desk.current_record = visitRecord.visit_record_id; deskDao.SetVisitRecord(desk); this.Close(); } else { MessageBox.Show("请输入数字"); } }
public ActionResult Create(FormCollection collection) { var model = new VisitRecord(); this.TryUpdateModel <VisitRecord>(model); model.CreateTime = model.VisitTime = DateTime.Now; model.Username = this.UserContext.LoginInfo.LoginName; model.UserId = this.UserContext.LoginInfo.UserID; try { this.CrmService.SaveVisitRecord(model); } catch (BusinessException e) { this.ModelState.AddModelError(e.Name, e.Message); this.RenderMyViewData(model); return(View("Edit", model)); } return(this.RefreshParent()); }
public ViewModelTreatRegiment(VisitRecord vis) { visit = vis; CurPatient = vis.Patient; }