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 + "]");
}
}
