private void CreatePickupType() { List <DataDictionaryInfo> dataDictionaryInfos = new List <DataDictionaryInfo>(); var dict = _context.Set <DataDictionary>().Add(new DataDictionary { DictionaryName = "仓储备货类型" }); DataDictionaryInfo dataDictionaryInfo1 = new DataDictionaryInfo { DictionaryCode = "1", DictionaryDescription = "正常", DataDictionary = dict }; DataDictionaryInfo dataDictionaryInfo2 = new DataDictionaryInfo { DictionaryCode = "2", DictionaryDescription = "紧急", DataDictionary = dict }; DataDictionaryInfo dataDictionaryInfo3 = new DataDictionaryInfo { DictionaryCode = "3", DictionaryDescription = "塔奥", DataDictionary = dict }; DataDictionaryInfo dataDictionaryInfo4 = new DataDictionaryInfo { DictionaryCode = "4", DictionaryDescription = "诚众", DataDictionary = dict }; dataDictionaryInfos.Add(dataDictionaryInfo1); dataDictionaryInfos.Add(dataDictionaryInfo2); dataDictionaryInfos.Add(dataDictionaryInfo3); dataDictionaryInfos.Add(dataDictionaryInfo4); var dictInfo = _context.Set <DataDictionaryInfo>().AddRange(dataDictionaryInfos); //var dict2 = _context.Set<DataDictionary>().Add(new DataDictionary { DictionaryName = "仓储备货类型", Operator = Guid.Empty, DataDictionaryInfos = dataDictionaryInfos }); }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { //获取父id string parentId = Request.QueryString["parentId"]; if (!string.IsNullOrEmpty(parentId)) { this.hidParentId.Value = parentId; } else { this.hidParentId.Value = "-1"; } //获取id string strId = Request.QueryString["id"]; if (!string.IsNullOrEmpty(strId)) { this.hidDicId.Value = strId; //获取配置文件路径。 string configFile = AppDomain.CurrentDomain.BaseDirectory.ToString() + SystemConfig.databaseConfigFileName; //创建操作对象 DataDicOperater dicOper = DataDicOperater.createDataDicOperater(configFile, SystemConfig.databaseConfigNodeName, SystemConfig.configFileKey); if (dicOper != null) { ////获取字典项信息 DataDictionaryInfo dicInfo = dicOper.getDataDictionary(Convert.ToInt32(strId)); if (dicInfo != null) { this.txtDicName.Value = dicInfo.name; this.txtDicValue.Value = dicInfo.value.ToString(); this.txtDicCode.Value = dicInfo.code; this.txtDicOrder.Value = dicInfo.order.ToString(); } else { YMessageBox.show(this, "获取字典信息失败!错误信息[" + dicOper.errorMessage + "]"); return; } } else { YMessageBox.show(this, "创建数据库操作对象失败!"); return; } } } }
/// <summary> /// 绑定字典项。 /// 作者:董帅 创建时间:2012-8-28 21:46:08 /// </summary> public void bindDicInfos() { try { //获取配置文件路径。 string configFile = AppDomain.CurrentDomain.BaseDirectory.ToString() + SystemConfig.databaseConfigFileName; //获取数据库操作对象 DataDicOperater dicOper = DataDicOperater.createDataDicOperater(configFile, SystemConfig.databaseConfigNodeName, SystemConfig.configFileKey); if (dicOper != null) { //获取父字典项 if (this.hidParentId.Value == "-1") { this.spanParentName.InnerText = "顶级字典"; this.returnButton.Disabled = true; this.hidReturnId.Value = ""; } else { DataDictionaryInfo org = dicOper.getDataDictionary(Convert.ToInt32(this.hidParentId.Value)); this.spanParentName.InnerText = org.name; this.hidReturnId.Value = org.parentId.ToString(); } //获取组织机构列表 List <DataDictionaryInfo> dics = dicOper.getDataDictionaryByParentId(Convert.ToInt32(this.hidParentId.Value)); if (dics != null) { this.dicList.DataSource = dics; this.dicList.DataBind(); } else { YMessageBox.show(this, "获取字典数据失败!错误信息[" + dicOper.errorMessage + "]"); } } else { YMessageBox.show(this, "获取数据库操作对象失败!"); } } catch (Exception ex) { YMessageBox.show(this, "运行错误!错误信息[" + ex.Message + "]"); } }
private async static void TestDataDictionary() { List <DataDictionaryInfo> dataDictionaryInfos = new List <DataDictionaryInfo>(); int result = 0; using (var db = new TestDbContext()) { db.Database.Log = Console.WriteLine; using (var tran = db.Database.BeginTransaction()) { try { var dict = await db.Set <DataDictionary>().AsNoTracking().FirstOrDefaultAsync(); if (dict is null) { dict = db.Set <DataDictionary>().Add(new DataDictionary { DictionaryName = "仓储备货类型" }); result = await db.SaveChangesAsync(); } else { db.Set <DataDictionary>().Attach(dict); } DataDictionaryInfo dataDictionaryInfo1 = new DataDictionaryInfo { DictionaryCode = "1", DictionaryDescription = "正常", DataDictionary = dict }; DataDictionaryInfo dataDictionaryInfo2 = new DataDictionaryInfo { DictionaryCode = "2", DictionaryDescription = "紧急", DataDictionary = dict }; DataDictionaryInfo dataDictionaryInfo3 = new DataDictionaryInfo { DictionaryCode = "3", DictionaryDescription = "塔奥", DataDictionary = dict }; DataDictionaryInfo dataDictionaryInfo4 = new DataDictionaryInfo { DictionaryCode = "4", DictionaryDescription = "诚众", DataDictionary = dict }; dataDictionaryInfos.Add(dataDictionaryInfo1); dataDictionaryInfos.Add(dataDictionaryInfo2); dataDictionaryInfos.Add(dataDictionaryInfo3); dataDictionaryInfos.Add(dataDictionaryInfo4); var dictInfo = db.Set <DataDictionaryInfo>().AddRange(dataDictionaryInfos); result = await db.SaveChangesAsync(); } catch (Exception ex) { result = 0; } finally { if (result > 0) { tran.Commit(); } else { tran.Rollback(); } } } } }
/// <summary> /// 保存数据。 /// 作者:董帅 创建时间:2012-8-28 17:28:54 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void butSave_Click(object sender, EventArgs e) { try { DataDictionaryInfo dataDicInfo = new DataDictionaryInfo(); dataDicInfo.name = this.txtDicName.Value; if (string.IsNullOrEmpty(dataDicInfo.name) || dataDicInfo.name.Length > 20) { YMessageBox.show(this, "名称不合法!"); return; } dataDicInfo.value = Convert.ToInt32(this.txtDicValue.Value); dataDicInfo.code = this.txtDicCode.Value; dataDicInfo.order = Convert.ToInt32(this.txtDicOrder.Value); dataDicInfo.parentId = Convert.ToInt32(this.hidParentId.Value); //获取配置文件路径。 string configFile = AppDomain.CurrentDomain.BaseDirectory.ToString() + SystemConfig.databaseConfigFileName; //创建操作对象 DataDicOperater dataDicOper = DataDicOperater.createDataDicOperater(configFile, SystemConfig.databaseConfigNodeName, SystemConfig.configFileKey); if (dataDicOper != null) { if (string.IsNullOrEmpty(this.hidDicId.Value)) { //新增 if (dataDicOper.createNewDataDictionary(dataDicInfo) > 0) { YMessageBox.showAndResponseScript(this, "保存成功!", "", "window.parent.menuButtonOnClick('数据字典','icon-dictionary','sys/dataDictionary/dataDictionary_list.aspx?parentId=" + this.hidParentId.Value + "');window.parent.closePopupsWindow('#popups');"); } else { YMessageBox.show(this, "创建机构失败!错误信息:[" + dataDicOper.errorMessage + "]"); return; } } else { //修改 dataDicInfo.id = Convert.ToInt32(this.hidDicId.Value); if (dataDicOper.changeDataDictionary(dataDicInfo)) { YMessageBox.showAndResponseScript(this, "保存成功!", "", "window.parent.menuButtonOnClick('数据字典','icon-dictionary','sys/dataDictionary/dataDictionary_list.aspx?parentId=" + this.hidParentId.Value + "');window.parent.closePopupsWindow('#popups');"); } else { YMessageBox.show(this, "修改字典项失败!错误信息:[" + dataDicOper.errorMessage + "]"); return; } } } else { YMessageBox.show(this, "创建数据库操作对象失败!"); return; } } catch (Exception ex) { YMessageBox.show(this, "程序异常!错误信息[" + ex.Message + "]"); } }