public ActionResult ProgItemNode() { List<SelectListItem> modelList = new List<SelectListItem>(); modelList.Add(new SelectListItem { Text = LiveAzure.Resource.Stage.ProgramController.inputBox, Value = "0" }); modelList.Add(new SelectListItem { Text = LiveAzure.Resource.Stage.ProgramController.dropdownListBox, Value = "1" }); ViewBag.modelList = modelList; GeneralProgNode addProgItemNode = new GeneralProgNode(); return View(new GeneralProgNode()); }
public void GeneralTest() { try { // 创建数据库事务 using (var scope = new TransactionScope()) { // 创建EF实体 using (var oLiveEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection)) { GeneralResource oResource = new GeneralResource { Code = "Test", Culture = 0, Matter = "名称" }; string culturename = oResource.CultureName; CultureInfo oCultureCN = new CultureInfo("zh-CN"); CultureInfo oCultureGB = new CultureInfo("en-GB"); CultureInfo oCultureUS = new CultureInfo("en-US"); CultureInfo oCultureFR = new CultureInfo("fr-FR"); CultureInfo oCultureDE = new CultureInfo("de-DE"); GeneralMessageReceive oMessageReceive = new GeneralMessageReceive { SendFrom = "13816626660", Matter = "Hello World", GetFrom = "EUCP", SentTime = new DateTime(2010, 2, 10, 12, 35, 09) }; oLiveEntities.GeneralMessageReceives.Add(oMessageReceive); // 此处,数据库中事实上没有保存 oLiveEntities.SaveChanges(); GeneralProgram oProgram = new GeneralProgram { Code = "Main" }; GeneralProgNode oNode = new GeneralProgNode { Program = oProgram, Code = "Test" }; oLiveEntities.GeneralProgNodes.Add(oNode); oLiveEntities.SaveChanges(); } // 提交事务,数据库物理写入 scope.Complete(); Debug.WriteLine("Submit Completed"); } } catch (TransactionAbortedException ex) { Console.WriteLine("TransactionAbortedException Message: {0}", ex.Message); } catch (ApplicationException ex) { Console.WriteLine("ApplicationException Message: {0}", ex.Message); } GC.Collect(); }
/// <summary> /// 导入程序菜单和定义 /// </summary> /// <param name="sExcelFile">Excel文件名</param> /// <param name="sSheetName">Sheet名</param> public void ImportPrograms(string sExcelFile, string sSheetName) { try { ExcelData oExcel = new ExcelData(sExcelFile, sSheetName); // 程序定义字段 DataColumn colPgCode = oExcel.ExcelTable.Columns["程序代码"]; DataColumn colPgParent = oExcel.ExcelTable.Columns["上级"]; DataColumn colPgUrl = oExcel.ExcelTable.Columns["URL"]; DataColumn colPgLeaf = oExcel.ExcelTable.Columns["叶子"]; // 功能定义字段 DataColumn colNdCode = oExcel.ExcelTable.Columns["功能代码"]; DataColumn colNdOptCN = oExcel.ExcelTable.Columns["中文选项"]; DataColumn colNdOptUS = oExcel.ExcelTable.Columns["英文选项"]; DataColumn colNdMode = oExcel.ExcelTable.Columns["输入模式"]; // 公共字段 DataColumn colNameCN = oExcel.ExcelTable.Columns["中文名称"]; DataColumn colNameUS = oExcel.ExcelTable.Columns["英文名称"]; DataColumn colRemark = oExcel.ExcelTable.Columns["备注"]; // 导入 GeneralProgram oLastProgram = null; string sLastParent = ""; GeneralProgram oParent = null; foreach (DataRow row in oExcel.ExcelTable.Rows) { string sPgCode = row[colPgCode].ToString(); string sPgParent = row[colPgParent].ToString(); string sPgUrl = row[colPgUrl].ToString(); bool bPgLeaf = row[colPgLeaf].ToString() == "1" ? true : false; string sNdCode = row[colNdCode].ToString(); GeneralResource oNdOpt = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colNdOptCN].ToString(), 1033, row[colNdOptUS].ToString()); byte nNdMode; Byte.TryParse(row[colNdMode].ToString(), out nNdMode); GeneralResource oName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colNameCN].ToString(), 1033, row[colNameUS].ToString()); string sRemark = row[colRemark].ToString(); if (!String.IsNullOrEmpty(sPgCode)) { // 定义程序 if (String.IsNullOrEmpty(sPgParent)) { oParent = null; sLastParent = ""; } else if (sPgParent != sLastParent) { oParent = (from p in dbEntity.GeneralPrograms where p.Code == sPgParent select p).FirstOrDefault(); sLastParent = sPgParent; } var oProgram = (from p in dbEntity.GeneralPrograms where p.Code == sPgCode select p).FirstOrDefault(); if (oProgram == null) { oProgram = new GeneralProgram { Code = sPgCode }; dbEntity.GeneralPrograms.Add(oProgram); } oProgram.Parent = oParent; oProgram.ProgUrl = sPgUrl; oProgram.Terminal = bPgLeaf; if (oProgram.Name == null) oProgram.Name = oName; else oProgram.Name.SetResource(ModelEnum.ResourceType.STRING, oName); oProgram.Show = true; oProgram.Remark = sRemark; dbEntity.SaveChanges(); oLastProgram = oProgram; if (Utility.ConfigHelper.GlobalConst.IsDebug) Debug.WriteLine("{0} {1} {2}", this.ToString(), sPgCode, sRemark); } else { // 定义功能点 var oProgNode = (from n in dbEntity.GeneralProgNodes where n.ProgID == oLastProgram.Gid && n.Code == sNdCode select n).FirstOrDefault(); if (oProgNode == null) { oProgNode = new GeneralProgNode { Program = oLastProgram, Code = sNdCode }; dbEntity.GeneralProgNodes.Add(oProgNode); } if (oProgNode.Name == null) oProgNode.Name = oName; else oProgNode.Name.SetResource(ModelEnum.ResourceType.STRING, oName); if (nNdMode == (byte)ModelEnum.OptionalInputMode.COMBOBOX) { if (oProgNode.Optional == null) oProgNode.Optional = oNdOpt; else oProgNode.Optional.SetResource(ModelEnum.ResourceType.STRING, oNdOpt); } oProgNode.InputMode = nNdMode; oProgNode.Remark = sRemark; dbEntity.SaveChanges(); if (Utility.ConfigHelper.GlobalConst.IsDebug) Debug.WriteLine(" {0} {1}", sNdCode, sRemark); } } oEventBLL.WriteEvent(String.Format("导入GeneralProgram/GeneralProgNode成功: {0} {1}", sExcelFile, sSheetName), ModelEnum.ActionLevel.GENERIC, ModelEnum.ActionSource.SYSTEM, this.ToString()); } catch (Exception ex) { oEventBLL.WriteEvent(String.Format("导入GeneralProgram/GeneralProgNode错误: {0} {1} {2}", sExcelFile, sSheetName, ex.Message), ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString()); } }
/// <summary> /// 保存编辑program node子项信息 /// </summary> /// <param name="formCollection">程序功能节点内容</param> public void NodeEditSave(GeneralProgNode model) { if (base.GetProgramNode("EnableEdit") == "1") { GeneralProgNode oGeneralProgNode = dbEntity.GeneralProgNodes.Where(p => p.Gid == model.Gid).Single(); oGeneralProgNode.Code = model.Code; oGeneralProgNode.Name.SetResource(ModelEnum.ResourceType.STRING, model.Name); if (oGeneralProgNode.InputMode == (byte)ModelEnum.OptionalInputMode.TEXTBOX) { oGeneralProgNode.InputMode = model.InputMode; if (model.InputMode == (byte)ModelEnum.OptionalInputMode.COMBOBOX) oGeneralProgNode.Optional = new GeneralResource(ModelEnum.ResourceType.STRING, model.Optional); } else { oGeneralProgNode.InputMode = model.InputMode; if (oGeneralProgNode.InputMode == (byte)ModelEnum.OptionalInputMode.COMBOBOX) oGeneralProgNode.Optional.SetResource(ModelEnum.ResourceType.STRING, model.Optional); else oGeneralProgNode.Optional.Deleted = true; } dbEntity.SaveChanges(); } }
/// <summary> /// 保存新建program node子项信息 /// </summary> /// <param name="formCollection">程序功能节点内容</param> /// <returns>重定向到程序功能节点列表</returns> public ActionResult NodeAddSave(GeneralProgNode model) { if (base.GetProgramNode("EnableEdit") == "1") { GeneralProgNode oGeneralProgNode = new GeneralProgNode { ProgID = model.ProgID, Code = model.Code, InputMode = model.InputMode, Name = new GeneralResource(ModelEnum.ResourceType.STRING, model.Name) }; if (oGeneralProgNode.InputMode == (byte)ModelEnum.OptionalInputMode.COMBOBOX) oGeneralProgNode.Optional = new GeneralResource(ModelEnum.ResourceType.STRING, model.Optional); dbEntity.GeneralProgNodes.Add(oGeneralProgNode); dbEntity.SaveChanges(); return RedirectToAction("NodeIndex", new { id = model.ProgID }); } return RedirectToAction("ErrorPage", "Home", new { message = LiveAzure.Resource.Common.NoPermission }); }
/// <summary> /// 添加程序功能节点页面 /// </summary> /// <returns>添加程序功能节点视图</returns> //public ActionResult NodeAdd() //{ // return View(); //} /// <summary> /// 跳转添加子项 /// </summary> /// <param name="progNodeGid">选中程序节点的Guid</param> /// <returns>程序功能节点列表</returns> public ActionResult NodeAdd(Guid progNodeGid) { if (base.GetProgramNode("EnableEdit") == "1") { GeneralProgNode oGeneralProgNode = new GeneralProgNode { Name = NewResource(ModelEnum.ResourceType.STRING), Optional = NewResource(ModelEnum.ResourceType.STRING) }; ViewBag.InputModeList = SelectEnumList(typeof(ModelEnum.OptionalInputMode), 1); oGeneralProgNode.ProgID = progNodeGid; return View(oGeneralProgNode); } return RedirectToAction("ErrorPage", "Home", new { message = LiveAzure.Resource.Common.NoPermission }); }
public void TestOld() { LiveEntities dbEntity = new LiveEntities(ConfigHelper.LiveConnection.Connection); CultureInfo oCulture1 = new CultureInfo("zh-CN"); CultureInfo oCulture2 = new CultureInfo("zh-TW"); CultureInfo oCulture = new CultureInfo("ja-JP"); decimal dm = 123894.56m; string s1 = oCulture.NumberFormat.CurrencySymbol + dm.ToString(oCulture.NumberFormat); Debug.WriteLine(s1); string symbolRMB = (new CultureInfo("zh-CN")).NumberFormat.CurrencySymbol; string symbolUSD = (new CultureInfo("en-US")).NumberFormat.CurrencySymbol; string symbolEUR = (new CultureInfo("fr-FR")).NumberFormat.CurrencySymbol; Guid? oUnitRMB = (from m in dbEntity.GeneralMeasureUnits where m.Code == symbolRMB select m.Gid).FirstOrDefault(); Guid? oUnitUSD = (from m in dbEntity.GeneralMeasureUnits where m.Code == symbolUSD select m.Gid).FirstOrDefault(); Guid? oUnitEUR = (from m in dbEntity.GeneralMeasureUnits where m.Code == symbolEUR select m.Gid).FirstOrDefault(); GeneralResource oMoney = new GeneralResource { Rtype = (byte)ModelEnum.ResourceType.MONEY, Currency = oUnitRMB, Cash = 123.56m, ResourceItems = new List<GeneralResItem> { new GeneralResItem { Currency = oUnitUSD, Cash = 34.67m }, new GeneralResItem { Currency = oUnitEUR, Cash = 31.69m } } }; dbEntity.GeneralResources.Add(oMoney); dbEntity.SaveChanges(); GeneralBLL oGeneralBLL = new GeneralBLL(dbEntity); string sm = oGeneralBLL.GetMoneyString(oMoney.Gid, oUnitRMB); string sMoneyCode1 = oMoney.GetCurrencyUnit(dbEntity).Code; string sMoneyCode2 = oMoney.GetCurrencyUnit(dbEntity, oUnitUSD.Value).Code; GeneralProgNode oProgNode = new GeneralProgNode { Program = dbEntity.GeneralPrograms.Where(p => p.Code == "ConfigIndex").FirstOrDefault(), Code = "EnableModify", Name = new GeneralResource { Culture = 1033, Matter = "Modify", ResourceItems = new List<GeneralResItem> { new GeneralResItem { Culture = 2052, Matter = "允许修改" } } }, InputMode = (byte)ModelEnum.OptionalInputMode.COMBOBOX, Optional = new GeneralResource { Culture = 1033, Matter = "{0|No},{1|Yes}", ResourceItems = new List<GeneralResItem> { new GeneralResItem { Culture = 2052, Matter = "{0|否},{1|是}" } } } }; dbEntity.GeneralProgNodes.Add(oProgNode); dbEntity.SaveChanges(); MemberPrivilege oPrivilege = new MemberPrivilege { User = dbEntity.MemberUsers.Where(u => u.LoginName == "test").FirstOrDefault(), Ptype = (byte)ModelEnum.UserPrivType.PROGRAM_NODE, PrivilegeItems = new List<MemberPrivItem> { new MemberPrivItem { RefID = oProgNode.Gid, NodeCode = "EnableModify", NodeValue = "1" } } }; dbEntity.MemberPrivileges.Add(oPrivilege); dbEntity.SaveChanges(); Dictionary<string, string> oProgramNodes = new Dictionary<string, string>(); oProgramNodes.Add("Supervisor", "1"); if (oProgramNodes.ContainsKey("Supervisor") && (oProgramNodes["Supervisor"] == "1")) { Debug.WriteLine(oProgramNodes["Supervisor"]); } if (oProgramNodes.ContainsKey("Key") && (oProgramNodes["Key"] == "1")) { string s = oProgramNodes["Key"]; Debug.WriteLine(s); } TimeSpan oTimeSpan = TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now); DateTimeOffset oLocalTime1 = new DateTimeOffset(2011, 8, 24, 13, 45, 24, oTimeSpan); DateTime oLocalTime2 = DateTime.Now; oLocalTime2 = DateTime.SpecifyKind(oLocalTime2, DateTimeKind.Utc); DateTimeOffset oLocalTime3 = oLocalTime2; DateTimeOffset oLocalTime4 = oLocalTime1; GeneralConfig oConfig1 = new GeneralConfig { Code = "Test11", DateValue = oLocalTime1 }; GeneralConfig oConfig2 = new GeneralConfig { Code = "Test21", DateValue = oLocalTime3 }; GeneralConfig oConfig3 = new GeneralConfig { Code = "Test31", DateValue = oLocalTime4 }; dbEntity.GeneralConfigs.Add(oConfig1); dbEntity.GeneralConfigs.Add(oConfig2); dbEntity.GeneralConfigs.Add(oConfig3); dbEntity.SaveChanges(); GeneralTodoList oTodo2 = (from t in dbEntity.GeneralTodoLists where t.Gid == new Guid("3429BF77-1ECE-E011-A3A0-60EB69D65AE8") select t).FirstOrDefault(); // string strSQL = String.Format("SELECT * FROM dbo.fn_FindTest('{0}')", Guid.Empty); // string strSQL = String.Format("EXECUTE sp_FindTest '{0}'", Guid.Empty); var fnFindTest = dbEntity.Database.SqlQuery<ShipList>("SELECT * FROM fn_FindTest({0})", Guid.Empty); foreach (ShipList fnItem in fnFindTest) { Debug.WriteLine(fnItem.ShipID); Debug.WriteLine(fnItem.ShipWeight); } Guid og = Guid.Empty; Guid? og1 = null; Guid? og2 = Guid.NewGuid(); Guid? og3 = Guid.Empty; if (og == Guid.Empty) Debug.WriteLine(og); if (og1.HasValue) Debug.WriteLine(og1.Value); if (og2.HasValue) Debug.WriteLine(og2.Value); if (og3.HasValue) Debug.WriteLine(og3.Value); var list = from c in dbEntity.WarehouseInformations where c.Deleted == false select c.Parent; foreach (var v in list) { Debug.WriteLine(v.FullName.Matter); //Debug.WriteLine(v.Key); //foreach (var item in v) //{ // Debug.WriteLine(item.FullName.Matter); //} //if (v.FullName == null) // Debug.WriteLine("is null"); //foreach (var v2 in v.FullName.ResourceItems) // Debug.WriteLine(v2.Matter); } EventBLL oEventBLL = new EventBLL(dbEntity); oEventBLL.WriteEvent("系统启动", ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString()); GeneralConfig oConfig = dbEntity.GeneralConfigs.Where(c => c.Code == "SessionName").FirstOrDefault(); List<ListItem> oList2 = oConfig.SelectEnumList(typeof(ModelEnum.ActionSource), 2); string oListName = oConfig.SelectEnumName(typeof(ModelEnum.ActionSource), 2); }
//===================================================================== public void InsertTestData() { //res 表中添加角色 GeneralResource resRole = new GeneralResource { Code = GetRandCode(), Matter = "General User", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resRole); //res 表中添加组织全名 GeneralResource resOrg = new GeneralResource { Code = GetRandCode(), Matter = "筑巢信息科技有限公司", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resOrg); //res 表中添加组织简称 GeneralResource resShort = new GeneralResource { Code = GetRandCode(), Matter = "筑巢", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resShort); //res 表中添加数据 GeneralResource resData = new GeneralResource { Code = GetRandCode(), Culture = 2052, Matter = "A Test" }; oLiveEntities.GeneralResources.Add(resData); GeneralResource resProg0 = new GeneralResource { Code = GetRandCode(), Culture = 2052, Matter = "Config" }; oLiveEntities.GeneralResources.Add(resProg0); //res 表中添加程序定义 GeneralResource resProg1 = new GeneralResource { Code = GetRandCode(), Matter = "generalProperty", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resProg1); //res 表中添加程序定义 GeneralResource resProg2 = new GeneralResource { Code = GetRandCode(), Matter = "Units", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resProg2); //res 表中添加程序定义 GeneralResource resProg3 = new GeneralResource { Code = GetRandCode(), Matter = "Classification", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resProg3); //res 表中添加程序定义 GeneralResource resProg4 = new GeneralResource { Code = GetRandCode(), Matter = "Organization", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resProg4); //unit表中添加数据 GeneralMeasureUnit oUnit = new GeneralMeasureUnit { Utype = 2, Code = GetRandCode(), Name = resData }; oLiveEntities.GeneralMeasureUnits.Add(oUnit); //unit表中添加数据 GeneralMeasureUnit oUnit0 = new GeneralMeasureUnit { Utype = 6, Code = GetRandCode(), Name = resData }; oLiveEntities.GeneralMeasureUnits.Add(oUnit0); //文化表中添加数据 GeneralCultureUnit culture = new GeneralCultureUnit { Piece = oUnit, Weight = oUnit0, Culture = 2052 }; oLiveEntities.GeneralCultureUnits.Add(culture); //组织表中添加数据 MemberOrganization org = new MemberOrganization { Code = GetRandCode(), FullName = resOrg, ShortName = resShort, WorkPhone = "15121040098", HomeUrl = "http://www.zhuchao.com" }; oLiveEntities.MemberOrganizations.Add(org); MemberOrganization chl = new MemberOrganization { Code = GetRandCode(), FullName = resOrg, ShortName = resShort, WorkPhone = "15121040098", HomeUrl = "http://www.zhuchao.com" }; oLiveEntities.MemberOrganizations.Add(chl); //角色表中添加数据 MemberRole role = new MemberRole { Name = resRole, Code = GetRandCode(), Organization = org }; oLiveEntities.MemberRoles.Add(role); //新建渠道 MemberChannel mChl = new MemberChannel { Code = GetRandCode(), CellPhone = "4525254254", Email = "*****@*****.**", }; oLiveEntities.MemberChannels.Add(mChl); MemberOrgChannel oChl = new MemberOrgChannel { Organization = org, Channel = mChl }; oLiveEntities.MemberOrgChannels.Add(oChl); //添加用户 MemberUser user = new MemberUser { Organization = org, Channel = mChl, Role = role, LoginName = GetRandCode() + "@qq.com", Passcode = GetRandCode() }; oLiveEntities.MemberUsers.Add(user); //添加用户 MemberUser user0 = new MemberUser { Organization = org, Channel = mChl, Role = role, LoginName = "*****@*****.**", Passcode = "123" }; oLiveEntities.MemberUsers.Add(user0); //添加程序定义 GeneralProgram prog = new GeneralProgram { Name = resProg0, Code = GetRandCode() }; oLiveEntities.GeneralPrograms.Add(prog); //添加程序定义 GeneralProgram prog0 = new GeneralProgram { Name = resProg1, Code = GetRandCode() }; oLiveEntities.GeneralPrograms.Add(prog0); //添加程序定义 GeneralProgram prog1 = new GeneralProgram { Name = resProg2, Code = GetRandCode(), Parent = prog }; oLiveEntities.GeneralPrograms.Add(prog1); //添加程序定义 GeneralProgram prog2 = new GeneralProgram { Name = resProg3, Code = GetRandCode(), Parent = prog }; oLiveEntities.GeneralPrograms.Add(prog2); //添加程序定义 GeneralProgram prog3 = new GeneralProgram { Name = resProg4, Code = GetRandCode(), Parent = prog }; oLiveEntities.GeneralPrograms.Add(prog3); //添加程序定义 GeneralProgram prog5 = new GeneralProgram { Name = resProg4, Code = GetRandCode(), Parent = prog1 }; oLiveEntities.GeneralPrograms.Add(prog5); //res 表中添加程序定义 GeneralResource resnode = new GeneralResource { Code = "resnode", Matter = "功能节点1", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resProg1); GeneralResource resoptional = new GeneralResource { Code = "resnodeoption", Matter = "0|不显示,1|显示", Culture = 2052 }; oLiveEntities.GeneralResources.Add(resProg1); //添加程序功能定义 GeneralProgNode progNode = new GeneralProgNode { Program = prog, Code = "prognode", Name = resnode, Optional = resoptional, InputMode = 1 }; oLiveEntities.GeneralProgNodes.Add(progNode); oLiveEntities.SaveChanges(); //添加权限控制 MemberPrivilege prol = new MemberPrivilege { User = user0, Ptype = 0 }; oLiveEntities.MemberPrivileges.Add(prol); //添加权限控制 MemberPrivilege prol0 = new MemberPrivilege { User = user0, Ptype = 1 }; oLiveEntities.MemberPrivileges.Add(prol0); MemberPrivItem prinode = new MemberPrivItem { Privilege = prol0, RefID = progNode.Gid, NodeValue = "1" }; oLiveEntities.MemberPrivItems.Add(prinode); //添加权限控制明细 MemberPrivItem prolItem = new MemberPrivItem { Privilege = prol, RefID = prog.Gid }; oLiveEntities.MemberPrivItems.Add(prolItem); //添加权限控制明细 MemberPrivItem prolItem0 = new MemberPrivItem { Privilege = prol, RefID = prog0.Gid }; oLiveEntities.MemberPrivItems.Add(prolItem0); //添加权限控制明细 MemberPrivItem prolItem1 = new MemberPrivItem { Privilege = prol, RefID = prog1.Gid }; oLiveEntities.MemberPrivItems.Add(prolItem1); //添加权限控制明细 MemberPrivItem prolItem2 = new MemberPrivItem { Privilege = prol, RefID = prog2.Gid }; oLiveEntities.MemberPrivItems.Add(prolItem2); oLiveEntities.SaveChanges(); }