private void TopShiftForm_Load(object sender, EventArgs e) { cmd = new Xr.Common.Controls.OpaqueCommand(this); GetKeShi(); //午别下拉框数据 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); dict = new DictEntity(); dict.value = "2"; dict.label = "晚上"; dictList.Add(dict); dict = new DictEntity(); dict.value = "3"; dict.label = "全天"; dictList.Add(dict); treePeriod.Properties.DataSource = dictList; treePeriod.Properties.DisplayMember = "label"; treePeriod.Properties.ValueMember = "value"; }
public DoctorTemporaryStopFrm(string deptId, string Periods) { InitializeComponent(); MainForm = (Form)this.Parent; cmd = new Xr.Common.Controls.OpaqueCommand(AppContext.Session.waitControl); cmd.ShowOpaqueLayer(225, false); Period = Periods; 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; cmd.HideOpaqueLayer(); GetDoctorSetting(); }
public bool UpdateDict(DictEntity dictEntity) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" DictID=@DictID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" DictKey=@DictKey"); sqlCommandText.Append(", Note=@Note"); sqlCommandText.Append(", EditUserID=@EditUserID"); sqlCommandText.Append(", EditDate=getdate()"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.Dict SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString())); db.AddInParameter(cmd, "@DictID", DbType.Int64, dictEntity.DictID); db.AddInParameter(cmd, "@DictKey", DbType.AnsiString, dictEntity.DictKey); db.AddInParameter(cmd, "@Note", DbType.AnsiString, dictEntity.Note); db.AddInParameter(cmd, "@EditUserID", DbType.Int64, dictEntity.EditUserID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public bool AddDict(DictEntity dictEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @JournalID"); sqlCommandText.Append(", @DictKey"); sqlCommandText.Append(", @Note"); sqlCommandText.Append(", @InUserID"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.Dict ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, dictEntity.JournalID); db.AddInParameter(cmd, "@DictKey", DbType.AnsiString, dictEntity.DictKey); db.AddInParameter(cmd, "@Note", DbType.AnsiString, dictEntity.Note); db.AddInParameter(cmd, "@InUserID", DbType.Int64, dictEntity.InUserID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public static void BindComboBoxData(ComboBox cmb, string key, bool isAddEmptyItem) { if (InitDataUtil.DictList == null) { return; } List <FishEntity.DictEntity> list = InitDataUtil.DictList.FindAll((i) => { return(i.pcode.Equals(key)); }); if (isAddEmptyItem) { if (list == null) { list = new List <DictEntity>(); } DictEntity empty = new DictEntity(); empty.code = string.Empty; empty.name = string.Empty; list.Insert(0, empty); } cmb.DisplayMember = "name"; cmb.ValueMember = "code"; cmb.DataSource = list; }
private void ModifyNumberSourceEdit_Load(object sender, EventArgs e) { cmd = new Xr.Common.Controls.OpaqueCommand(this); cmd.ShowOpaqueLayer(0f); deBegin.EditValue = beginDate; deEnd.EditValue = endDate; //获取可操作科室 String url = AppContext.AppConfig.serverUrl + "cms/dept/qureyOperateDept"; this.DoWorkAsync(500, (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> >(); treeDept.Properties.DataSource = deptList; treeDept.Properties.TreeList.KeyFieldName = "id"; treeDept.Properties.TreeList.ParentFieldName = "parentId"; treeDept.Properties.DisplayMember = "name"; treeDept.Properties.ValueMember = "id"; treeDept.EditValue = deptId; lueDoctor.Properties.DataSource = doctorList; lueDoctor.Properties.DisplayMember = "name"; lueDoctor.Properties.ValueMember = "id"; lueDoctor.EditValue = doctorId; //合并值相同的单元格 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(); cmd.HideOpaqueLayer(); } else { cmd.HideOpaqueLayer(); MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, this); return; } }); }
public ExecResult SaveDict(DictEntity model) { ExecResult execResult = new ExecResult(); IDictService service = ServiceContainer.Instance.Container.Resolve <IDictService>(); return(service.Save(model)); }
public DictEntity GetDictModelByKey(DictQuery query) { IDictService service = ServiceContainer.Instance.Container.Resolve <IDictService>(); DictEntity model = service.GetDictByKey(query.DictKey, query.JournalID); return(model); }
public DictEntity GetDictModel(DictQuery query) { IDictService service = ServiceContainer.Instance.Container.Resolve <IDictService>(); DictEntity model = service.GetDict(query.DictID); return(model); }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, DictEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception) { throw; } }
public List <DictEntity> MakeDictList(DataTable dt) { List <DictEntity> list = new List <DictEntity>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { DictEntity dictEntity = MakeDict(dt.Rows[i]); list.Add(dictEntity); } } return(list); }
private void importDict(string type) { try { var typeId = GetValueByControlName(type); if (!string.IsNullOrEmpty(typeId)) { var sbSql = new StringBuilder(); var code = txtDictCodeField.Text; var name = txtDictNameField.Text; var table = txtDictTableName.Text; var typeIDField = txtDictTypeID.Text; sbSql.AppendFormat(sqlTemplate, code, name, table, typeIDField, typeId); var dt = new SqlHelper(txtSQLConnection.Text).ExecuteDataTable(sbSql.ToString()); if (dt.Rows.Count > 0) { var json = JsonConvert.SerializeObject(dt); var mongodb = new MongoDBHelper(txtMongodbCon.Text, txtMongoCollection.Text); var dict = new DictEntity(); dict.type = type; dict.data = new List <BsonDocument>(); foreach (DataRow dr in dt.Rows) { var doc = new BsonDocument(); doc.Set("code", dr[code].ToString()); doc.Set("name", dr[name].ToString()); dict.data.Add(doc); } var documentName = "DC_DICTION"; var filter = new BsonDocument(); filter.Set("type", type); var docs = mongodb.GetDocumentsByFilter <DictEntity>(documentName, filter); if (!docs.Any() || docs.First().data.Count < dt.Rows.Count) { mongodb.DeleteMany <DictEntity>(documentName, filter); mongodb.Insert <DictEntity>(documentName, dict); txtResult.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " - 【" + type + "】数据导入成功,导入" + dt.Rows.Count + "条\r\n"; } } } } catch (Exception ex) { txtResult.Text += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " - 【" + type + "】导入失败," + ex.Message + "\r\n"; } }
public ActionResult Save(DictEntity model) { ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); if (model.DictID == 0) { model.InUserID = CurAuthor.AuthorID; } else { model.EditUserID = CurAuthor.AuthorID; } model.JournalID = CurAuthor.JournalID; ExecResult result = service.SaveDict(model); return(Json(new { result = result.result, msg = result.msg })); }
public DictEntity GetDictByKey(string dictKey, long JournalID) { DictEntity dictEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 DictID,JournalID,DictKey,Note,InUserID,EditUserID,EditDate,AddDate FROM dbo.Dict WITH(NOLOCK)"); sqlCommandText.Append(" WHERE DictKey=@DictKey"); sqlCommandText.Append(" AND JournalID=@JournalID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@DictKey", DbType.String, dictKey); db.AddInParameter(cmd, "@JournalID", DbType.Int64, JournalID); using (IDataReader dr = db.ExecuteReader(cmd)) { dictEntity = MakeDict(dr); } return(dictEntity); }
public DictEntity MakeDict(DataRow dr) { DictEntity dictEntity = null; if (dr != null) { dictEntity = new DictEntity(); dictEntity.DictID = (Int64)dr["DictID"]; dictEntity.JournalID = (Int64)dr["JournalID"]; dictEntity.DictKey = (String)dr["DictKey"]; dictEntity.Note = (String)dr["Note"]; dictEntity.InUserID = (Int64)dr["InUserID"]; dictEntity.EditUserID = (Int64)dr["EditUserID"]; dictEntity.EditDate = (DateTime)dr["EditDate"]; dictEntity.AddDate = (DateTime)dr["AddDate"]; } return(dictEntity); }
public ActionResult Create(Int64 dictId = 0) { DictEntity model = null; if (dictId > 0) { DictQuery query = new DictQuery(); query.JournalID = CurAuthor.JournalID; query.DictID = dictId; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model = service.GetDictModel(query); } if (model == null) { model = new DictEntity(); } return(View(model)); }
/// <summary> /// 保存数据字典 /// </summary> /// <param name="model"></param> /// <returns></returns> public ExecResult Save(DictEntity model) { ExecResult execResult = new ExecResult(); model.DictKey = model.DictKey.TextFilter(); if (DictkeyIsExists(model)) { execResult.result = EnumJsonResult.error.ToString(); execResult.msg = "该数据字典名称已存在!"; return(execResult); } bool result = false; model.Note = model.Note.TextFilter(); if (model.DictID == 0) { result = AddDict(model); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "新增数据字典成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "新增数据字典失败!"; } } else { result = UpdateDict(model); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "修改数据字典成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "修改数据字典失败!"; } } return(execResult); }
public DictEntity MakeDict(IDataReader dr) { DictEntity dictEntity = null; if (dr.Read()) { dictEntity = new DictEntity(); dictEntity.DictID = (Int64)dr["DictID"]; dictEntity.JournalID = (Int64)dr["JournalID"]; dictEntity.DictKey = (String)dr["DictKey"]; dictEntity.Note = (String)dr["Note"]; dictEntity.InUserID = (Int64)dr["InUserID"]; dictEntity.EditUserID = (Int64)dr["EditUserID"]; dictEntity.EditDate = (DateTime)dr["EditDate"]; dictEntity.AddDate = (DateTime)dr["AddDate"]; } dr.Close(); return(dictEntity); }
/// <summary> /// 数据字典是否已经存在 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool DictkeyIsExists(DictEntity model) { string strSql = "SELECT 1 FROM dbo.Dict a with(nolock) WHERE JournalID=@JournalID and DictKey=@DictKey"; if (model.DictID > 0) { strSql += " and DictID<>" + model.DictID; } DbCommand cmd = db.GetSqlStringCommand(strSql); db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID); db.AddInParameter(cmd, "@DictKey", DbType.AnsiString, model.DictKey); object obj = db.ExecuteScalar(cmd); if (obj == null) { return(false); } return(obj.TryParse <Int32>() == 1); }
public List <DictEntity> MakeDictList(IDataReader dr) { List <DictEntity> list = new List <DictEntity>(); while (dr.Read()) { DictEntity dictEntity = new DictEntity(); dictEntity.DictID = (Int64)dr["DictID"]; dictEntity.JournalID = (Int64)dr["JournalID"]; dictEntity.DictKey = (String)dr["DictKey"]; dictEntity.Note = (String)dr["Note"]; dictEntity.InUserID = (Int64)dr["InUserID"]; dictEntity.EditUserID = (Int64)dr["EditUserID"]; dictEntity.EditDate = (DateTime)dr["EditDate"]; dictEntity.AddDate = (DateTime)dr["AddDate"]; list.Add(dictEntity); } dr.Close(); return(list); }
/// <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(); }
public bool DeleteDict(DictEntity dictEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("DELETE FROM dbo.Dict"); sqlCommandText.Append(" WHERE DictID=@DictID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@DictID", DbType.Int64, dictEntity.DictID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
private void BindCountryBrandData() { //cmbBand.DataSource = null; if (cmbCountry.SelectedValue == null) { return; } string pcode = cmbCountry.SelectedValue.ToString(); FishEntity.DictEntity pModel = InitDataUtil.DictList.Find((i) => { return(i.code == pcode && i.pcode.Equals(FishEntity.Constant.CountryType)); }); int pid = 0; if (pModel != null) { pid = pModel.id; } List <FishEntity.DictEntity> list = InitDataUtil.DictList.FindAll((i) => { return(i.pid == pid && i.pcode.Equals(FishEntity.Constant.Brand)); }); if (true) { if (list == null) { list = new List <DictEntity>(); } DictEntity empty = new DictEntity(); empty.code = string.Empty; empty.name = string.Empty; list.Insert(0, empty); } cmbBand.DisplayMember = "name"; cmbBand.ValueMember = "code"; cmbBand.DataSource = list; }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="dict">DictEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddDict(DictEntity dict) { return(DictDataAccess.Instance.AddDict(dict)); }
public static DictEntity ToEntity(this DictDto model, DictEntity destination) { return(model.MapTo(destination)); }
public static DictDto ToModel(this DictEntity entity) { return(entity.MapTo <DictEntity, DictDto>()); }
private void DeptSettingsForm_Load(object sender, EventArgs e) { MainForm = (Form)this.Parent; pageControl1.MainForm = MainForm; cmd = new Xr.Common.Controls.OpaqueCommand(AppContext.Session.waitControl); cmd.ShowOpaqueLayer(0f); dcDeptInfo.DataType = typeof(DeptInfoEntity); bool scFlag = false; foreach (FunctionEntity function in AppContext.Session.functionList) { if (function.name.Equals("科室设置删除功能")) { scFlag = true; break; } } btnDel.Visible = scFlag; 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); lueIsOpen.Properties.DataSource = dictList; lueIsOpen.Properties.DisplayMember = "label"; lueIsOpen.Properties.ValueMember = "value"; dictList = new List <DictEntity>(); dict = new DictEntity(); dict.value = "0"; dict.label = "是"; dictList.Add(dict); dict = new DictEntity(); dict.value = "1"; dict.label = "否"; dictList.Add(dict); lueIsPush.Properties.DataSource = dictList; lueIsPush.Properties.DisplayMember = "label"; lueIsPush.Properties.ValueMember = "value"; lueIsBook.Properties.DataSource = dictList; lueIsBook.Properties.DisplayMember = "label"; lueIsBook.Properties.ValueMember = "value"; //查询医院下拉框数据 String url = AppContext.AppConfig.serverUrl + "cms/hospital/findAll"; this.DoWorkAsync(0, (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) { lueHospital.Properties.DataSource = objT["result"].ToObject <List <HospitalInfoEntity> >(); lueHospital.Properties.DisplayMember = "name"; lueHospital.Properties.ValueMember = "id"; //查询宣传显示下拉框数据 url = AppContext.AppConfig.serverUrl + "sys/sysDict/findByType?type=show_hide"; this.DoWorkAsync(0, (o) => //耗时逻辑处理(此处不能操作UI控件,因为是在异步中) { data = HttpClass.httpPost(url); return(data); }, null, (data2) => //显示结果(此处用于对上面结果的处理,比如显示到界面上) { objT = JObject.Parse(data2.ToString()); if (string.Compare(objT["state"].ToString(), "true", true) == 0) { lueIsShow.Properties.DataSource = objT["result"].ToObject <List <DictEntity> >(); lueIsShow.Properties.DisplayMember = "label"; lueIsShow.Properties.ValueMember = "value"; //查询状态下拉框数据 url = AppContext.AppConfig.serverUrl + "sys/sysDict/findByType?type=is_use"; this.DoWorkAsync(0, (o) => //耗时逻辑处理(此处不能操作UI控件,因为是在异步中) { data = HttpClass.httpPost(url); return(data); }, null, (data3) => //显示结果(此处用于对上面结果的处理,比如显示到界面上) { objT = JObject.Parse(data3.ToString()); if (string.Compare(objT["state"].ToString(), "true", true) == 0) { lueIsUse.Properties.DataSource = objT["result"].ToObject <List <DictEntity> >(); lueIsUse.Properties.DisplayMember = "label"; lueIsUse.Properties.ValueMember = "value"; SearchData(1, 10000); } else { cmd.HideOpaqueLayer(); MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MainForm); return; } }); } else { cmd.HideOpaqueLayer(); MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MainForm); return; } }); } else { cmd.HideOpaqueLayer(); MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MainForm); return; } }); }
/// <summary> /// 更新存储媒介中的实体数据 /// </summary> /// <param name="dict">DictEntity实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public bool UpdateDict(DictEntity dict) { return(DictDataAccess.Instance.UpdateDict(dict)); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="dict">DictEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteDict(DictEntity dict) { return(DictDataAccess.Instance.DeleteDict(dict)); }
/// <summary> /// 数据字典是否已经存在 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool DictkeyIsExists(DictEntity model) { return(DictDataAccess.Instance.DictkeyIsExists(model)); }