private void lueHospital_EditValueChanged(object sender, EventArgs e) { if (lueHospital.EditValue == null || lueHospital.EditValue.ToString().Length == 0) { treeParentId.Properties.DataSource = null; return; } HospitalInfoEntity hospitalInfo = lueHospital.GetSelectedDataRow() as HospitalInfoEntity; //查询上级科室下拉框数据 String url = AppContext.AppConfig.serverUrl + "cms/dept/findAll?hospital.code=" + hospitalInfo.code;// +"&deptIds=" + AppContext.Session.deptIds; String data = HttpClass.httpPost(url); JObject objT = JObject.Parse(data); if (string.Compare(objT["state"].ToString(), "true", true) == 0) { List <DeptEntity> deptLsit = objT["result"].ToObject <List <DeptEntity> >(); DeptEntity dept = new DeptEntity(); dept.id = "0"; dept.name = "无"; deptLsit.Insert(0, dept); treeParentId.Properties.DataSource = deptLsit; treeParentId.Properties.TreeList.KeyFieldName = "id"; treeParentId.Properties.TreeList.ParentFieldName = "parentId"; treeParentId.Properties.DisplayMember = "name"; treeParentId.Properties.ValueMember = "id"; } else { MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MainForm); return; } }
/// <summary> /// DELETE Department method /// </summary> /// <param name="depart"></param> /// <returns> /// bool value of method's execution /// </returns> public static bool Remove(Depart depart) { using (EquipmentsEntities context = new EquipmentsEntities()) { try { int id = Convert.ToInt32(depart.Id); DeptEntity dept = context.Depts.Single(d => d.Id == id); context.Depts.Remove(dept); var equipments = context.Equip.Where(e => e.DeptsId == dept.Id).ToList(); foreach (var eq in equipments) { eq.DeptsId = null; } context.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } }
private void treeMenuControl1_MenuItemClick(object sender, EventArgs e, object selectItem) { DeptEntity dept = selectItem as DeptEntity; string hospitalId = dept.hospitalId; deptId = dept.id; SearchData(1, pageControl1.PageSize, hospitalId, deptId); }
/// <summary> /// 科室列表点击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <param name="selectItem"></param> private void treeMenuControl1_MenuItemClick(object sender, EventArgs e, object selectItem) { DeptEntity dept = selectItem as DeptEntity; SelectDeptid = dept.id; ClearReservationUIInfo(); List <Dictionary <int, String> > dcs = new List <Dictionary <int, String> >(); reservationCalendar1.ChangeValidDate(dcs); this.mcTimeSpan.setDataSources(null, true, ""); GetDoctorName(AppContext.Session.hospitalId, SelectDeptid); }
public JsonResult Edit(int id, IFormCollection collection) { DeptEntity entity = new DeptEntity(); TryUpdateModelAsync(entity); var result = service.Update(entity, AppUser, () => { DeptUtil.Clear(); }); return(Json(result)); }
private void button1_Click(object sender, EventArgs e) { var context = new DeptEntity(); Department dept = new Department(); context.Departments.Add(dept); dept.ID = Convert.ToInt32(id.Text); dept.Name = ename.Text; dept.Location = elable.Text; context.Departments.Add(dept); context.SaveChanges(); }
/// <summary> /// CREATE Department method /// </summary> /// <param name="depart"></param> /// <returns> /// bool value of method's execution /// </returns> public static bool Create(Depart depart) { using (EquipmentsEntities context = new EquipmentsEntities()) { try { DeptEntity newE = new DeptEntity(); newE.DeptName = depart.Name; context.Depts.Add(newE); context.SaveChanges(); return(true); } catch { return(false); } } }
/// <summary> /// 窗口加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ScheduledListForm_Load(object sender, EventArgs e) { MainForm = (Form)this.Parent; deBegin.EditValue = DateTime.Now.ToString("yyyy-MM-dd"); deEnd.EditValue = DateTime.Now.ToString("yyyy-MM-dd"); cmd = new Xr.Common.Controls.OpaqueCommand(AppContext.Session.waitControl); List <DeptEntity> deptList = Clone <List <DeptEntity> >(AppContext.Session.deptList); DeptEntity dept = new DeptEntity(); dept.id = "`"; dept.name = "全部"; deptList.Insert(0, dept); treeDept.Properties.DataSource = deptList; treeDept.Properties.TreeList.KeyFieldName = "id"; treeDept.Properties.TreeList.ParentFieldName = "parentId"; treeDept.Properties.DisplayMember = "name"; treeDept.Properties.ValueMember = "id"; treeDept.EditValue = dept.id; //合并值相同的单元格 gridView1.OptionsView.AllowCellMerge = true; //设置表格中状态下拉框的数据 List <DictEntity> dictList = new List <DictEntity>(); DictEntity dict = new DictEntity(); dict.value = "0"; dict.label = "正常"; dictList.Add(dict); dict = new DictEntity(); dict.value = "1"; dict.label = "停诊"; dictList.Add(dict); repositoryItemLookUpEdit1.DataSource = dictList; repositoryItemLookUpEdit1.DisplayMember = "label"; repositoryItemLookUpEdit1.ValueMember = "value"; repositoryItemLookUpEdit1.ShowHeader = false; repositoryItemLookUpEdit1.ShowFooter = false; SearchData(); }
private void treeMenuControl1_MenuItemClick(object sender, EventArgs e, object selectItem) { DeptEntity dept = selectItem as DeptEntity; String param = "pageNo=1&pageSize=10000&hospital.id=" + dept.hospitalId + "&dept.id=" + dept.id; String url = AppContext.AppConfig.serverUrl + "cms/doctor/list?" + param; cmd.ShowOpaqueLayer(); this.DoWorkAsync(500, (o) => //耗时逻辑处理(此处不能操作UI控件,因为是在异步中) { String data = HttpClass.httpPost(url); return(data); }, null, (data) => //显示结果(此处用于对上面结果的处理,比如显示到界面上) { JObject objT = JObject.Parse(data.ToString()); if (string.Compare(objT["state"].ToString(), "true", true) == 0) { List <DoctorInfoEntity> doctorList = objT["result"]["list"].ToObject <List <DoctorInfoEntity> >(); //设置医生列表 List <Item> itemList = new List <Item>(); foreach (DoctorInfoEntity doctor in doctorList) { Item item = new Item(); item.name = doctor.name; item.value = doctor.id; item.tag = doctor.code; itemList.Add(item); } mcDoctor.setDataSource(itemList); cmd.HideOpaqueLayer(); } else { cmd.HideOpaqueLayer(); MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MainForm); return; } }); }
void GetAll() { using (SqlConnection conn = new SqlConnection(strConn))//使用using的方式系统自动关闭连接 { //打开数据库连接 conn.Open(); //设定SQL叙述 string sql = string.Format("select d.deptId,d.deptName,e.name from department d, employee e where d.deptMgrId = e.empId"); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { DeptEntity deptEntity = new DeptEntity(); for (int i = 0; i < dr.FieldCount; i++) { deptEntity.DeptId = int.Parse(dr[0].ToString()); deptEntity.DeptName = dr[1].ToString(); deptEntity.DeptMgr = dr[2].ToString(); } deptlist.Add(deptEntity); } } }
private void UserForm_Load(object sender, EventArgs e) { MainForm = (Form)this.Parent; //Infor(); cmd = new Xr.Common.Controls.OpaqueCommand(this); gridBand3.Caption = gridBand15.Caption = gridBand32.Caption = gridBand13.Caption = "开放总额\r\n(预约+现场)"; //查询科室下拉框数据 List <DeptEntity> deptList = Clone <List <DeptEntity> >(AppContext.Session.deptList); DeptEntity dept = new DeptEntity(); dept.id = " "; dept.name = "全部"; deptList.Insert(0, dept); treeDeptId.Properties.DataSource = deptList; treeDeptId.Properties.TreeList.KeyFieldName = "id"; treeDeptId.Properties.TreeList.ParentFieldName = "parentId"; treeDeptId.Properties.DisplayMember = "name"; treeDeptId.Properties.ValueMember = "id"; //默认选择选择第一个 if (deptList.Count > 0) { treeDeptId.EditValue = deptList[0].id; } /*String url = AppContext.AppConfig.serverUrl + "cms/dept/findAll?hospital.code=" + AppContext.AppConfig.hospitalCode + "&code=" + AppContext.AppConfig.deptCode; * String data = HttpClass.httpPost(url); * JObject objT = JObject.Parse(data); * if (string.Compare(objT["state"].ToString(), "true", true) == 0) * { * List<DeptEntity> deptList = new List<DeptEntity>() { new DeptEntity { id = " ", parentId = "", name = "请选择" } }; * deptList.AddRange(objT["result"].ToObject<List<DeptEntity>>()); * //DeptEntity dept = new DeptEntity(); * //dept.id = "0"; * //dept.name = "无"; * //deptList.Insert(0, dept); * * treeDeptId.Properties.DataSource = deptList; * treeDeptId.Properties.TreeList.KeyFieldName = "id"; * treeDeptId.Properties.TreeList.ParentFieldName = "parentId"; * treeDeptId.Properties.DisplayMember = "name"; * treeDeptId.Properties.ValueMember = "id"; * } * else * { * MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MainForm); * return; * } * //若没配置科室编码让其选择一个 * if (AppContext.AppConfig.deptCode == String.Empty) * { * treeDeptId.EditValue = " "; * } * else * { * * treeDeptId.EditValue = AppContext.Session.deptId; * } */ //配置时间格式 setDateFomartDefult(true); TabpageName = xtraTabControl1.SelectedTabPage.Text; }
/// <summary> /// 窗口加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ScheduledListForm_Load(object sender, EventArgs e) { MainForm = (Form)this.Parent; deBegin.EditValue = DateTime.Now.ToString("yyyy-MM-dd"); deEnd.EditValue = DateTime.Now.AddDays(11).ToString("yyyy-MM-dd");//修改为当前日期+11之后的日期。 cmd = new Xr.Common.Controls.OpaqueCommand(AppContext.Session.waitControl); bool hzFlag = false; foreach (FunctionEntity function in AppContext.Session.functionList) { if (function.name.Equals("已排班列表门诊特需互转")) { hzFlag = true; break; } } if (hzFlag) { buttonControl2.Visible = hzFlag; } else { buttonControl4.Location = new Point(25, 47); } bool fhFlag = false; foreach (FunctionEntity function in AppContext.Session.functionList) { if (function.name.Equals("已排班列表放号审核")) { fhFlag = true; break; } } if (hzFlag && fhFlag) { buttonControl3.Visible = fhFlag; } else if (!hzFlag && fhFlag) { buttonControl3.Visible = fhFlag; buttonControl3.Location = new Point(131, 47); } bool addFlag = false; foreach (FunctionEntity function in AppContext.Session.functionList) { if (function.name.Equals("已排班列表增加排班")) { addFlag = true; break; } } buttonControl1.Visible = addFlag; if (hzFlag && !fhFlag) { buttonControl1.Location = new Point(239, 47); } if (!hzFlag && fhFlag) { buttonControl1.Location = new Point(217, 47); } else if (!hzFlag && !fhFlag) { buttonControl1.Location = new Point(131, 47); } //合并值相同的单元格 gridView1.OptionsView.AllowCellMerge = true; //设置表格中状态下拉框的数据 List <DictEntity> dictList = new List <DictEntity>(); DictEntity dict = new DictEntity(); dict.value = "0"; dict.label = "正常"; dictList.Add(dict); dict = new DictEntity(); dict.value = "1"; dict.label = "停诊"; dictList.Add(dict); repositoryItemLookUpEdit1.DataSource = dictList; repositoryItemLookUpEdit1.DisplayMember = "label"; repositoryItemLookUpEdit1.ValueMember = "value"; repositoryItemLookUpEdit1.ShowHeader = false; repositoryItemLookUpEdit1.ShowFooter = false; lookUpEdit1.Properties.DataSource = dictList; lookUpEdit1.Properties.DisplayMember = "label"; lookUpEdit1.Properties.ValueMember = "value"; lookUpEdit1.ItemIndex = 0; List <DictEntity> dictList2 = new List <DictEntity>(); dict = new DictEntity(); dict.value = "`"; dict.label = "全部"; dictList2.Add(dict); dict = new DictEntity(); dict.value = "0"; dict.label = "放号"; dictList2.Add(dict); dict = new DictEntity(); dict.value = "1"; dict.label = "未放号"; dictList2.Add(dict); lookUpEdit2.Properties.DataSource = dictList2; lookUpEdit2.Properties.DisplayMember = "label"; lookUpEdit2.Properties.ValueMember = "value"; lookUpEdit2.ItemIndex = 0; cmd.ShowOpaqueLayer(0f); //获取可操作科室 String url = AppContext.AppConfig.serverUrl + "cms/dept/qureyOperateDept"; this.DoWorkAsync(0, (o) => { String data = HttpClass.httpPost(url); return(data); }, null, (data) => { JObject objT = JObject.Parse(data.ToString()); if (string.Compare(objT["state"].ToString(), "true", true) == 0) { List <DeptEntity> deptList = objT["result"]["deptList"].ToObject <List <DeptEntity> >(); DeptEntity dept = new DeptEntity(); dept.id = "`"; dept.name = "全部"; //deptList.Insert(0, dept); treeDept.Properties.DataSource = deptList; treeDept.Properties.TreeList.KeyFieldName = "id"; treeDept.Properties.TreeList.ParentFieldName = "parentId"; treeDept.Properties.DisplayMember = "name"; treeDept.Properties.ValueMember = "id"; treeDept.EditValue = AppContext.Session.deptList[0].id; SearchData(); } else { cmd.HideOpaqueLayer(); MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MainForm); return; } }); }