public ActionResult Index(int page = 1) { SysEnum.RepNormalType RepNormalType = SysEnum.Parse <SysEnum.RepNormalType>(Function.GetRequestString("RepNormalType")); var list = RepResearchNormalBLL.GetList(p => true); list = list.Where(a => a.TypeFlag == (int)RepNormalType); ViewBag.RepNormalType = RepNormalType; string Name = Function.GetRequestString("Name"); DateTime DateBegin = Function.GetRequestDateTime("DateBegin"); DateTime DateEnd = Function.GetRequestDateTime("DateEnd"); if (DateBegin > DicInfo.DateZone) { list = list.Where(a => DbFunctions.DiffDays(a.DateBegin, DateBegin) <= 0); ViewBag.TxtDateBegin = DateBegin.ToString("yyyy-MM-dd"); } if (DateEnd > DicInfo.DateZone) { list = list.Where(a => DbFunctions.DiffDays(a.DateEnd, DateEnd) >= 0); ViewBag.TxtDateEnd = DateEnd.ToString("yyyy-MM-dd"); } switch (RepNormalType) { case SysEnum.RepNormalType.集体调研: if (!PowerActionBLL.PowerCheck(PowerInfo.P_工作信息管理.PP常规.PPP集体调研.查看所有)) { list = list.Where(a => a.CreateUserID == CurrentUser.ID); } break; case SysEnum.RepNormalType.一加三: if (!PowerActionBLL.PowerCheck(PowerInfo.P_工作信息管理.PP常规.PPP一加三.查看所有)) { list = list.Where(a => a.CreateUserID == CurrentUser.ID); } break; case SysEnum.RepNormalType.蹲点: if (!PowerActionBLL.PowerCheck(PowerInfo.P_工作信息管理.PP常规.PPP蹲点.查看所有)) { list = list.Where(a => a.CreateUserID == CurrentUser.ID); } break; case SysEnum.RepNormalType.教研组织: if (!PowerActionBLL.PowerCheck(PowerInfo.P_工作信息管理.PP常规.PPP教研组织.查看所有)) { list = list.Where(a => a.CreateUserID == CurrentUser.ID); } break; default: break; } list = list.OrderByDescending(p => p.ID); IPagedList <RepResearchNormalInfo> result = list.ToPagedList(page, PageSize); return(View(result)); }
/// <summary> /// 保存企业投诉保修 /// </summary> /// <param name="username"></param> /// <param name="address"></param> /// <param name="phone"></param> /// <param name="descri"></param> /// <returns></returns> public string SaveHouseOwnerComplainRepair(string username, string address, string phone, string descri) { try { if (string.IsNullOrWhiteSpace(address)) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "住址为必填项")); } if (string.IsNullOrWhiteSpace(phone)) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "联系号码为必填项")); } if (string.IsNullOrWhiteSpace(descri)) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "描述为必填项")); } WebSecurityService wsClient = new WebSecurityService(); object userId = wsClient.GetUserId(username); if (userId == null) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "用户【" + username + "】不存在或已被删除")); } SysEnum seBll = new SysEnum(); var seModel = seBll.GetModel(SysEnumHelper.GetEnumNameForComplainRepairType(SysEnumHelper.ComplainRepairType.ResidentFamily)); if (seModel == null) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "找不到投诉保修类型,待系统管理员设定后再使用")); } ComplainRepairInfo model = new ComplainRepairInfo(); model.UserId = Guid.Parse(userId.ToString()); model.LastUpdatedDate = DateTime.Now; model.Phone = phone.Trim(); model.Descri = descri.Trim(); model.SysEnumId = Guid.Parse(seModel.Id.ToString()); model.Status = (byte)SysEnumHelper.ComplainRepairStatus.受理中; model.Address = address.Trim(); ComplainRepair bll = new ComplainRepair(); int effect = bll.Insert(model); if (effect == 110) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "已存在相同数据记录,请勿重复提交!")); } if (effect < 1) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "操作失败,请正确操作!")); } else { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", true, "保存成功,我们会尽快处理!")); } } catch (Exception ex) { return(string.Format("<Rsp><IsOK>{0}</IsOK><RtMsg>{1}</RtMsg></Rsp>", false, "异常:" + ex.Message)); } }
public string DelSysEnum(string id) { string errorMsg = string.Empty; try { if (!HttpContext.Current.User.IsInRole("Administrators")) { return(MC.Role_InvalidError); } if (string.IsNullOrWhiteSpace(id)) { return(MC.Submit_InvalidRow); } Guid gId = Guid.Empty; Guid.TryParse(id, out gId); if (gId.Equals(Guid.Empty)) { return(MC.GetString(MC.Submit_Params_GetInvalidRegex, "对应标识值")); } SysEnum bll = new SysEnum(); bll.Delete(gId); return("1"); } catch (Exception ex) { errorMsg = ex.Message; } return(MC.GetString(MC.Submit_Ex_Error, errorMsg)); }
protected void Page_Load(object sender, EventArgs e) { this.Page.Title = "工作删除"; BP.WF.Node nd = new BP.WF.Node(this.FK_Node); this.ToolBar1.Add("<b>删除方式:</b>"); this.ToolBar1.AddDDL("DDL1"); this.DDL1.Attributes["onchange"] = "OnChange(this);"; this.ToolBar1.AddBtn("Btn_OK", "确定"); this.ToolBar1.GetBtnByID("Btn_OK").Attributes["onclick"] = " return confirm('您确定要执行吗?');"; this.ToolBar1.GetBtnByID("Btn_OK").Click += new EventHandler(ReturnWork_Click); this.ToolBar1.AddBtn("Btn_Cancel", "取消"); this.ToolBar1.GetBtnByID("Btn_Cancel").Click += new EventHandler(ReturnWork_Click); string appPath = this.Request.ApplicationPath; TextBox tb = new TextBox(); tb.TextMode = TextBoxMode.MultiLine; tb.ID = "TB_Doc"; tb.Rows = 15; tb.Columns = 50; this.Pub1.Add(tb); if (this.IsPostBack == false) { if (nd.HisDelWorkFlowRole == DelWorkFlowRole.DeleteAndWriteToLog) { /*删除并记录日志 */ SysEnum se = new SysEnum(BtnAttr.DelEnable, (int)DelWorkFlowRole.DeleteAndWriteToLog); this.DDL1.Items.Add(new ListItem(se.Lab, se.IntKey.ToString())); } if (nd.HisDelWorkFlowRole == DelWorkFlowRole.DeleteByFlag) { /*逻辑删除 */ SysEnum se = new SysEnum(BtnAttr.DelEnable, (int)DelWorkFlowRole.DeleteByFlag); this.DDL1.Items.Add(new ListItem(se.Lab, se.IntKey.ToString())); } if (nd.HisDelWorkFlowRole == DelWorkFlowRole.ByUser) { /*让用户来决定.*/ SysEnums ses = new SysEnums(BtnAttr.DelEnable); foreach (SysEnum se in ses) { DelWorkFlowRole role = (DelWorkFlowRole)se.IntKey; if (role == DelWorkFlowRole.None) { continue; } if (role == DelWorkFlowRole.ByUser) { continue; } this.DDL1.Items.Add(new ListItem(se.Lab, se.IntKey.ToString())); } } } }
void btn_Click(object sender, EventArgs e) { //原有个数 SysEnums souceSes = new SysEnums(); souceSes.Retrieve(SysEnumAttr.EnumKey, this.RefNo, SysEnumAttr.IntKey); SysEnums ses = new SysEnums(); for (int i = 0; i < souceSes.Count + 10; i++) { TextBox tb = this.UCSys1.GetTextBoxByID("TB_" + i); if (tb == null) { continue; } if (string.IsNullOrEmpty(tb.Text)) { continue; } SysEnum se = new SysEnum(); se.IntKey = i; se.Lab = tb.Text.Trim(); se.Lang = BP.Web.WebUser.SysLang; se.EnumKey = this.RefNo; se.MyPK = se.EnumKey + "_" + se.Lang + "_" + se.IntKey; ses.AddEntity(se); } if (ses.Count == 0) { this.Alert("枚举项目不能为空."); return; } ses.Delete(SysEnumAttr.EnumKey, this.RefNo); string lab = ""; foreach (SysEnum se in ses) { se.Save(); lab += "@" + se.IntKey + "=" + se.Lab; } SysEnumMain main = new SysEnumMain(this.RefNo); main.Name = UCSys1.GetTextBoxByID("TB_Name").Text; main.CfgVal = lab; main.Update(); this.Alert("保存成功."); }
/// <summary> /// 检查听评对象用记是否存在,不存在则创建 /// </summary> private bool CreatePConfirmlectureUserID(ResearchInfo infoResearch) { UserInfo infoUser = null; if (infoResearch.lectureUserID > 0) { infoUser = UserBLL.GetList(a => a.ID == infoResearch.lectureUserID && a.DepartmentID == infoResearch.ResearchPlanInfo.DepartmentID).FirstOrDefault(); if (null != infoUser) { return(true); } } infoUser = new UserInfo(); infoUser.DepartmentID = infoResearch.ResearchPlanInfo.DepartmentID; infoUser.Name = Function.GetRequestString("TxtLectureUserID"); infoUser.Code = infoUser.Name; infoUser.PassWord = Guid.NewGuid().ToString().Replace("-", ""); infoUser.Email = infoUser.Tel = string.Empty; infoUser.CreateDate = infoUser.LastDate = DateTime.Now; infoUser.Enable = false; infoUser.LocationX = infoUser.LocationY = 0; infoUser.WechatOpenID = infoUser.WechatNameNick = infoUser.WechatHeadImg = infoUser.Sex = string.Empty; infoUser.IDCard = string.Empty; infoUser.TypeID = -1; infoUser.DefaultSubjectID = infoResearch.SubjectID; if (string.IsNullOrEmpty(infoUser.Name)) { return(false); } //再根据名称找一,如果就不要加啦 var ExistItem = UserBLL.GetList(a => a.Name.StartsWith(infoUser.Name + "|外区")).FirstOrDefault(); if (null != ExistItem) { infoResearch.lectureUserID = ExistItem.ID; return(true); } //做insert前最后修正 infoUser.Name = infoUser.Code = infoUser.Name + "|" + SysEnum.GetName(typeof(SysEnum.ResearchArea), infoResearch.ResearchPlanInfo.AreaID) + Guid.NewGuid().ToString().Replace("-", ""); infoUser.SubjectInfo.Add(infoResearch.SubjectInfo); return(UserBLL.Create(infoUser).ID > 0); }
public string SaveSysEnum(SysEnumInfo sysEnumModel) { if (string.IsNullOrWhiteSpace(sysEnumModel.EnumName)) { return(MessageContent.Submit_Params_InvalidError); } if (string.IsNullOrWhiteSpace(sysEnumModel.EnumCode)) { return(MessageContent.Submit_Params_InvalidError); } if (string.IsNullOrWhiteSpace(sysEnumModel.EnumValue)) { return(MessageContent.Submit_Params_InvalidError); } Guid gId = Guid.Empty; Guid.TryParse(sysEnumModel.Id.ToString(), out gId); sysEnumModel.Id = gId; Guid parentId = Guid.Empty; Guid.TryParse(sysEnumModel.ParentId.ToString(), out parentId); sysEnumModel.ParentId = parentId; SysEnum bll = new SysEnum(); int effect = -1; if (!gId.Equals(Guid.Empty)) { effect = bll.Update(sysEnumModel); } else { effect = bll.Insert(sysEnumModel); } if (effect == 110) { return(MessageContent.Submit_Exist); } if (effect > 0) { return("1"); } else { return(MessageContent.Submit_Error); } }
/// <summary> /// 绑定运输环节 /// </summary> private void BindTranNode() { SysEnum seBll = new SysEnum(); var list = seBll.GetList("and t2.EnumCode = 'SendReceiveType' "); string itemAppend = ""; foreach (var item in list) { itemAppend += "{\"id\":\"" + item.EnumCode + "\",\"text\":\"" + item.EnumValue + "\"},"; } itemAppend = itemAppend.Trim(','); htmlAppend += "<div id=\"myDataForTranNode\" style=\"display:none;\">["; htmlAppend += itemAppend; htmlAppend += "]</div>"; }
/// <summary> /// 获取列表查询条件项,并构建查询参数集 /// </summary> private void GetSearchItem() { parms = new ParamsHelper(); SysEnum seBll = new SysEnum(); var model = seBll.GetModel("PublicTerritory"); if (model == null) { MessageBox.Messager(Page, "数据字典未配置”投诉保修类别/公共区域投诉保修“", MessageContent.AlertTitle_Ex_Error, "error"); return; } sqlWhere += "and SysEnumId = @SysEnumId "; SqlParameter parm = new SqlParameter("@SysEnumId", SqlDbType.UniqueIdentifier); parm.Value = model.Id; parms.Add(parm); }
public string DelSysEnum(string id) { if (string.IsNullOrWhiteSpace(id)) { return(MessageContent.Submit_InvalidRow); } Guid gId = Guid.Empty; Guid.TryParse(id, out gId); if (gId.Equals(Guid.Empty)) { return(MessageContent.GetString(MessageContent.Submit_Params_GetInvalidRegex, "对应标识值")); } SysEnum bll = new SysEnum(); bll.Delete(gId); return("1"); }
private void GetJsonForCbbRepair(HttpContext context) { SysEnum seBll = new SysEnum(); var list = seBll.GetListIncludeChild("ComplainCategory"); if (list == null || list.Count() == 0) { context.Response.Write("[]"); } string json = ""; foreach (var model in list) { json += "{\"id\":\"" + model.Id + "\",\"text\":\"" + model.EnumValue + "\"},"; } context.Response.Write("[" + json.Trim(',') + "]"); }
/// <summary> /// 获取模板参数并绑定到前端控件 /// </summary> private void BindTemplateParams() { htmlAppend += "<div id=\"myDataForSmsParam\" style=\"display:none;\">["; SysEnum seBll = new SysEnum(); string itemAppend = ""; var list = seBll.GetList("and t2.EnumCode = 'SmsParam'", null); if (list != null && list.Count > 0) { foreach (var item in list) { itemAppend += "{\"EnumCode\":\"" + item.EnumCode + "\",\"EnumValue\":\"" + item.EnumValue + "\",\"ParamsValue\":\"\",\"status\":\"否\"},"; } itemAppend = itemAppend.Trim(','); htmlAppend += itemAppend; } htmlAppend += "]</div>"; }
private void GetJsonForCombobox(HttpContext context) { string enumCode = context.Request.QueryString["enumCode"]; SysEnum seBll = new SysEnum(); var dic = seBll.GetKeyValueByParent(enumCode); if (dic == null || dic.Count() == 0) { context.Response.Write("[]"); } string json = ""; foreach (var kvp in dic) { json += "{\"id\":\"" + kvp.Key + "\",\"text\":\"" + kvp.Value + "\"},"; } context.Response.Write("[" + json.Trim(',') + "]"); }
/// <summary> /// 获取属于当前枚举代号的所有节点项json格式字符串 /// </summary> /// <param name="enumCode"></param> /// <returns></returns> public static string GetJsonForEnumCode(string enumCode) { SysEnum bll = new SysEnum(); if (!enableCaching) { return(bll.GetTreeJsonForEnumCode("DicCode")); } string key = "SysEnum_Json_" + enumCode + ""; string data = (string)HttpRuntime.Cache[key]; if (data == null) { data = bll.GetTreeJsonForEnumCode("DicCode"); AggregateCacheDependency cd = DependencyFacade.GetSysEnumDependency(); HttpRuntime.Cache.Add(key, data, cd, DateTime.Now.AddHours(sysEnumTimeout), Cache.NoSlidingExpiration, CacheItemPriority.High, null); } return(data); }
public static List <SysEnumInfo> GetList() { SysEnum bll = new SysEnum(); if (!enableCaching) { return(bll.GetList()); } string key = "sysEnum_list"; List <SysEnumInfo> data = (List <SysEnumInfo>)HttpRuntime.Cache[key]; if (data == null) { data = bll.GetList(); AggregateCacheDependency cd = DependencyFacade.GetSysEnumDependency(); HttpRuntime.Cache.Add(key, data, cd, DateTime.Now.AddHours(sysEnumTimeout), Cache.NoSlidingExpiration, CacheItemPriority.High, null); } return(data); }
public string SaveEnum(string enumKey, string enumLab, string cfg) { SysEnumMain sem = new SysEnumMain(); sem.No = enumKey; if (sem.RetrieveFromDBSources() == 0) { sem.Name = enumLab; sem.CfgVal = cfg; sem.Lang = WebUser.SysLang; sem.Insert(); } else { sem.Name = enumLab; sem.CfgVal = cfg; sem.Lang = WebUser.SysLang; sem.Update(); } string[] strs = cfg.Split('@'); foreach (string str in strs) { if (string.IsNullOrEmpty(str)) { continue; } string[] kvs = str.Split('='); SysEnum se = new SysEnum(); se.EnumKey = enumKey; se.Lang = WebUser.SysLang; se.IntKey = int.Parse(kvs[0]); se.Lab = kvs[1]; se.Insert(); } return("save ok."); }
public static List <SysEnumInfo> GetList(string parentName) { SysEnum bll = new SysEnum(); SqlParameter parm = new SqlParameter("@EnumName", parentName); if (!enableCaching) { return(bll.GetList(1, 100000, "and t2.EnumName = @EnumName", parm)); } string key = "sysEnum_list_" + parentName + ""; List <SysEnumInfo> data = (List <SysEnumInfo>)HttpRuntime.Cache[key]; if (data == null) { data = bll.GetList(1, 100000, "and t2.EnumName = @EnumName", parm); AggregateCacheDependency cd = DependencyFacade.GetSysEnumDependency(); HttpRuntime.Cache.Add(key, data, cd, DateTime.Now.AddHours(sysEnumTimeout), Cache.NoSlidingExpiration, CacheItemPriority.High, null); } return(data); }
void btn_New_Click(object sender, EventArgs e) { string no = this.UCSys1.GetTextBoxByID("TB_No").Text; string name = this.UCSys1.GetTextBoxByID("TB_Name").Text; SysEnumMain m = new SysEnumMain(); m.No = no; if (m.RetrieveFromDBSources() == 1) { this.Alert("枚举编号:" + m.No + " 已经被:" + m.Name + "占用"); return; } m.Name = name; if (string.IsNullOrEmpty(name)) { this.Alert("枚举名称不能为空"); return; } SysEnums ses = new SysEnums(); for (int i = 0; i < 20; i++) { TextBox tb = this.UCSys1.GetTextBoxByID("TB_" + i); if (tb == null) { continue; } if (string.IsNullOrEmpty(tb.Text)) { continue; } SysEnum se = new SysEnum(); se.IntKey = i; se.Lab = tb.Text.Trim(); se.Lang = BP.Web.WebUser.SysLang; se.EnumKey = m.No; se.MyPK = se.EnumKey + "_" + se.Lang + "_" + se.IntKey; ses.AddEntity(se); } if (ses.Count == 0) { this.Alert("枚举项目不能为空."); return; } string lab = ""; foreach (SysEnum se in ses) { se.Save(); lab += "@" + se.IntKey + "=" + se.Lab; } m.Lang = BP.Web.WebUser.SysLang; m.CfgVal = lab; m.Insert(); this.Response.Redirect("EnumList.aspx?RefNo=" + m.No + "&T=" + DateTime.Now.ToString("yyyyMMddHHmmssfff"), true); }
public ActionResult Create(ResearchPlanInfo info) { #region 计划对象ResearchPlanInfo info.Name = string.Format("{0}听评{1}", CurrentUser.Name, SysEnum.GetName(typeof(SysEnum.ResearchArea), info.AreaID)); if (string.IsNullOrEmpty(info.Memo)) { info.Memo = string.Empty; } if (info.DateBegin.Date < DateTime.Now.Date) { return(Json(new APIJson("日期有误"))); } if (info.TemplateID <= 0) { return(Json(new APIJson("请选择评价模板"))); } info.CategoryID = PlanCategoryPersonalID; info.Address = string.Empty; info.DateEnd = info.DateBegin; info.TypeEnum = (int)SysEnum.ResearchPlanType.个人听课; info.CreateUserID = CurrentUser.ID; info.CreateDate = DateTime.Now; info.Status = (int)SysEnum.ResearchPlanStatus.进行中; info.SummaryDetail = string.Empty; info.SummaryUserName = string.Empty; #endregion #region 听评课对象ResearchInfo var infoResearch = new ResearchInfo(); infoResearch.UserID = CurrentUser.ID; infoResearch.SubjectID = Function.GetRequestInt("SubjectID"); infoResearch.lectureUserID = Function.GetRequestInt("lectureUserID", 0); infoResearch.Topic = Function.GetRequestString("Topic"); infoResearch.LessionNumber = Function.GetRequestInt("LessionNumber"); infoResearch.ClassName = Function.GetRequestString("ClassName"); infoResearch.GradeName = Function.GetRequestString("GradeName"); infoResearch.SubjectiveOpinion = string.Empty; infoResearch.NoteMemo = string.Empty; infoResearch.Status = (int)SysEnum.ResearchStatus.未评; infoResearch.ScoreTotal = 0; infoResearch.ScoreLever = (int)SysEnum.ResearchScoreLever.合格; infoResearch.CreateDate = DateTime.Now; var infoExist = ResearchBLL.GetList(a => DbFunctions.DiffDays(a.CreateDate, infoResearch.CreateDate) == 0 && a.ResearchPlanID == infoResearch.ResearchPlanID && a.UserID == CurrentUser.ID && a.ClassName == infoResearch.ClassName && a.GradeName == infoResearch.GradeName && a.LessionNumber == infoResearch.LessionNumber ).FirstOrDefault(); if (null != infoExist) { return(Json(new APIJson(2, "您还在听评当前课程,将直接进入", new { PlanID = infoExist.ResearchPlanID, ResearchID = infoExist.ID }))); } //infoResearch.ResearchPlanID //infoResearch.SubjectID if (string.IsNullOrEmpty(infoResearch.Topic)) { return(Json(new APIJson(-1, "请填写课题"))); } if (string.IsNullOrEmpty(infoResearch.ClassName)) { return(Json(new APIJson(-1, "请填写年级"))); } if (string.IsNullOrEmpty(infoResearch.GradeName)) { return(Json(new APIJson(-1, "请填写班级"))); } if (infoResearch.SubjectID <= 0) { return(Json(new APIJson(-1, "请选择学科"))); } SubjectInfo infoSubject = SubjectBLL.GetList(a => a.ID == infoResearch.SubjectID).FirstOrDefault(); if (null == infoSubject) { return(Json(new APIJson(-1, "请选择学科"))); } infoResearch.SubjectInfo = infoSubject; infoResearch.SubjectiveOpinion = string.Empty; infoResearch.NoteMemo = string.Empty; infoResearch.Status = (int)SysEnum.ResearchStatus.未评; infoResearch.ScoreTotal = 0; infoResearch.ScoreLever = (int)SysEnum.ResearchScoreLever.合格; infoResearch.ResearchPlanInfo = info; info.ResearchInfo.Add(infoResearch); #endregion if (!CreatePConfirmDepartmentID(info)) { return(Json(new APIJson(-1, "请认真输放学校信息,对于系统未录入的学校,请务必认真输入全名"))); } if (!CreatePConfirmlectureUserID(infoResearch)) { return(Json(new APIJson(-1, "请认真输放听课对象,对于系统未录入的老师,请务必认真填写其姓名"))); } if (ResearchPlanBLL.Create(info).ID > 0) { return(Json(new APIJson(0, "提交成功", new { PlanID = info.ID, ResearchID = infoResearch.ID }))); } return(Json(new APIJson(-1, "提交失败,请重试"))); }
private static void WorkProcessor() { Random rnd = new Random(); bool isPassNight = false; //是否已到深夜0点 DateTime startTime = DateTime.MinValue; //开始时间 DateTime endTime = DateTime.MinValue; //结束时间 try { TyUser bll = new TyUser(); SysEnum seBll = new SysEnum(); while (true) { if (!isPassNight) { if (DateTime.Now.Hour == 0) { isPassNight = true; } } List <SysEnumInfo> seList = seBll.GetList("and t2.EnumCode = 'UserProcessor'"); double runTimeout = 0; double.TryParse(seList.Find(m => m.EnumCode == "RunTimeout").EnumValue.Trim(), out runTimeout); bool isOff = seList.Find(m => m.EnumCode == "On/Off").EnumValue.Trim().ToLower() == "off" ? true : false; if (isOff) { Thread.Sleep(5000); continue; } string sStartTime = seList.Find(m => m.EnumCode.Trim() == "StartTime").EnumValue; string sEndTime = seList.Find(m => m.EnumCode.Trim() == "EndTime").EnumValue; if ((sStartTime.IndexOf(':') != -1) && (sEndTime.IndexOf(':') != -1)) { DateTime currTime = DateTime.Now; sStartTime = string.Format("{0} {1}", currTime.ToString("yyyy-MM-dd"), sStartTime); sEndTime = string.Format("{0} {1}", currTime.ToString("yyyy-MM-dd"), sEndTime); DateTime.TryParse(sStartTime, out startTime); DateTime.TryParse(sEndTime, out endTime); DateTime maxTime = DateTime.Parse(string.Format("{0} {1}", currTime.ToString("yyyy-MM-dd"), "23:59:59")); if ((startTime != DateTime.MinValue) && (endTime != DateTime.MinValue)) { if (currTime >= endTime || currTime <= startTime) { Thread.Sleep(5000); continue; } } } #region 步用户表开始 TyUser tyuserBll = new TyUser(); List <string> newUsers = new List <string>(); string[] oldUsers = tyuserBll.GetTyUsers(); List <TyUserInfo> userList = tyuserBll.GetList(); foreach (string userName in oldUsers) { if (!userList.Exists(m => m.UserName == userName)) { newUsers.Add(userName); } } if (newUsers.Count > 0) { using (TransactionScope scope = new TransactionScope()) { foreach (string userName in newUsers) { string psw = (rnd.NextDouble() * Int32.MaxValue).ToString().PadLeft(6, '0').Substring(0, 6); Membership.CreateUser(userName, psw, "" + userName + "@tygaweb.com"); Roles.AddUserToRole(userName, "Users"); tyuserBll.Insert(new TyUserInfo { UserName = userName, Password = psw, IsEnable = true, LastUpdatedDate = DateTime.Now }); } scope.Complete(); } } #endregion if (runTimeout > 0) { TimeSpan ts = DateTime.Now.AddMinutes(runTimeout) - DateTime.Now; Thread.Sleep(ts); } else { Thread.Sleep(5000); } } } catch (Exception ex) { WriteLog log = new WriteLog(); log.Write(ex.Message); } }
/// <summary> /// 批量提交PDA扫描数据 /// </summary> /// <param name="dt">应包含opType、barCode、scanTime、userName等列</param> /// <returns>返回:包含“成功”,则调用成功,否则返回调用失败原因</returns> public string InsertByBatch(DataTable dt) { if (dt == null || dt.Rows.Count == 0) { return("无任何可保存的数据"); } string[] colNames = { "opType", "barCode", "scanTime", "userName" }; DataColumnCollection cols = dt.Columns; foreach (DataColumn col in cols) { if (!colNames.Contains(col.ColumnName)) { return("检测到提交的数据集中未包含" + col.ColumnName + "列"); } } DataRowCollection rows = dt.Rows; List <PDAOrderScanDetailInfo> osdList = new List <PDAOrderScanDetailInfo>(); //定义非重复的用户名、用户ID Dictionary <string, object> dicUser = new Dictionary <string, object>(); try { SysEnum seBll = new SysEnum(); var seList = seBll.GetList("and t2.EnumCode = 'SendReceiveType'", null); if (seList == null || seList.Count == 0) { return("服务端的操作类型未设定,请先完成设定"); } var firstModel = seList.OrderBy(m => m.Sort).First(); foreach (DataRow row in rows) { string opType = ""; if (row["opType"] != DBNull.Value) { opType = row["opType"].ToString(); } else { return("操作类型不能为空"); } var seModel = seList.Find(m => m.EnumValue.Trim() == opType.Trim()); if (seModel == null) { return("不存在操作类型:" + opType); } string barCode = ""; if (row["barCode"] != DBNull.Value) { barCode = row["barCode"].ToString(); } DateTime scanTime = DateTime.MinValue; if (row["scanTime"] != DBNull.Value) { DateTime.TryParse(row["scanTime"].ToString(), out scanTime); } if (scanTime == DateTime.MinValue) { return("数据集中包含不合法数据:scanTime值格式不正确"); } string userName = ""; if (row["userName"] != DBNull.Value) { userName = row["userName"].ToString(); } if (string.IsNullOrEmpty(userName)) { return("数据集中包含用户名为空"); } if (!dicUser.ContainsKey(userName)) { dicUser.Add(userName, Guid.Empty); } osdList.Add(new PDAOrderScanDetailInfo { OrderCode = barCode, CurrNodeId = seModel.Id, ScanTime = scanTime, Remark = seModel.Remark, Sort = seModel.Sort, LastUpdatedDate = DateTime.Now, UserName = userName, SysEnumValue = opType }); } TyUser tyuBll = new TyUser(); foreach (KeyValuePair <string, object> kvp in dicUser) { MembershipUser user = Membership.GetUser(kvp.Key, false); if (user == null) { return("不存在用户:" + kvp.Key); } TyUserInfo tyuModel = tyuBll.GetModelByUser(user.UserName); var currList = osdList.FindAll(m => m.UserName == kvp.Key); foreach (var item in currList) { item.UserId = user.ProviderUserKey; string sRemark = ""; if (tyuModel != null && !string.IsNullOrWhiteSpace(tyuModel.OrganizationName)) { sRemark = string.Format(item.Remark, tyuModel.OrganizationName); } else { sRemark = item.Remark.Replace(@"{0}", ""); } sRemark = item.SysEnumValue + ":" + sRemark; item.Remark = sRemark; } } PDAOrderScan osBll = new PDAOrderScan(); PDAOrderScanDetail osdBll = new PDAOrderScanDetail(); Order oBll = new Order(); SmsSend smsBll = new SmsSend(); var q = osdList.OrderBy(m => m.Sort); foreach (var item in q) { object nextNodeId = Guid.Empty; var currSeModel = seList.Find(m => m.EnumValue.Trim() == item.SysEnumValue); var nextSeModel = seList.FindAll(m => m.Sort > item.Sort).OrderBy(m => m.Sort).FirstOrDefault(); if (nextSeModel == null) { nextNodeId = item.CurrNodeId; } else { nextNodeId = nextSeModel.Id; } var lastSeModel = seList.OrderByDescending(m => m.Sort).First(); bool isFinish = lastSeModel.EnumValue.Trim() == item.SysEnumValue; bool isOsdExists = false; PDAOrderScanInfo currOsModel = new PDAOrderScanInfo(); currOsModel.OrderCode = item.OrderCode; currOsModel.CurrNodeId = item.CurrNodeId; currOsModel.NextNodeId = nextNodeId; currOsModel.IsFinish = isFinish; currOsModel.LastUpdatedDate = DateTime.Now; PDAOrderScanDetailInfo currOsdModel = new PDAOrderScanDetailInfo(); currOsdModel.OrderCode = item.OrderCode; currOsdModel.CurrNodeId = item.CurrNodeId; currOsdModel.ScanTime = item.ScanTime; currOsdModel.UserId = item.UserId; currOsdModel.LastUpdatedDate = currOsModel.LastUpdatedDate; currOsdModel.Remark = item.Remark; if (item.SysEnumValue == "干线发运" || item.SysEnumValue == "干线到达") { var orders = oBll.GetOrderByCarcode(item.OrderCode); if (orders == null || orders.Count() == 0) { return("操作类型:" + item.SysEnumValue + "找不到订单号,有错误"); } foreach (var currOrderCode in orders) { currOsModel.OrderCode = currOrderCode; currOsdModel.OrderCode = currOrderCode; var oldOsdList = osdBll.GetList(currOrderCode); if (oldOsdList != null) { isOsdExists = oldOsdList.Exists(m => m.CurrNodeId.Equals(item.CurrNodeId)); } if (!isOsdExists) { SmsSendInfo ssiModel = new SmsSendInfo(); ssiModel.OrderCode = currOrderCode; ssiModel.TranNode = currSeModel.EnumCode; ssiModel.TranNodeText = currSeModel.EnumValue; using (TransactionScope scope = new TransactionScope()) { if (osBll.GetModel(currOrderCode) == null) { osBll.Insert(currOsModel); } else { osBll.Update(currOsModel); } osdBll.Insert(currOsdModel); scope.Complete(); } smsBll.InsertByStrategy(ssiModel); } } } else if (item.Sort == firstModel.Sort) { var oldOsModel = osBll.GetModel(item.OrderCode); if (oldOsModel == null) { SmsSendInfo ssiModel = new SmsSendInfo(); ssiModel.OrderCode = item.OrderCode; ssiModel.TranNode = currSeModel.EnumCode; ssiModel.TranNodeText = currSeModel.EnumValue; using (TransactionScope scope = new TransactionScope()) { osBll.Insert(currOsModel); osdBll.Insert(currOsdModel); scope.Complete(); } smsBll.InsertByStrategy(ssiModel); } } else { var oldOsModel = osBll.GetModel(item.OrderCode); if (oldOsModel == null) { return("订单号:" + item.OrderCode + ",操作类型:" + item.SysEnumValue + "未取货,有错误"); } var oldOsdList = osdBll.GetList(item.OrderCode); if (oldOsdList != null) { isOsdExists = oldOsdList.Exists(m => m.CurrNodeId.Equals(item.CurrNodeId)); currOsModel.IsFinish = oldOsdList.Count == 5; } if (currOsModel.IsFinish) { continue; } if (!isOsdExists) { SmsSendInfo ssiModel = new SmsSendInfo(); ssiModel.OrderCode = currOsModel.OrderCode; ssiModel.TranNode = currSeModel.EnumCode; ssiModel.TranNodeText = currSeModel.EnumValue; using (TransactionScope scope = new TransactionScope()) { osBll.Update(currOsModel); osdBll.Insert(currOsdModel); scope.Complete(); } smsBll.InsertByStrategy(ssiModel); } } Console.WriteLine("request: opType:{0},barCode:{1},scanTime:{3},user:{2}", item.SysEnumValue, item.OrderCode, item.ScanTime, item.UserName); } return("保存成功"); } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// 新增PDA扫描数据 /// </summary> /// <param name="opType">操作类型</param> /// <param name="barCode">单号条码</param> /// <param name="scanTime">扫描时间</param> /// <param name="userName">用户名</param> /// <returns>返回:包含“成功”,则调用成功,否则返回调用失败原因</returns> public string Insert(string opType, string barCode, DateTime scanTime, string userName) { #region 参数合法性检查 if (string.IsNullOrEmpty(opType)) { return("操作类型不能为空"); } opType = opType.Trim(); if (string.IsNullOrEmpty(barCode)) { return("单号条码不能为空"); } barCode = barCode.Trim(); //if (barCode.Length != 13) //{ // return "单号条码不正确"; //} if (scanTime == DateTime.MinValue) { return("扫描时间格式不正确"); } if (string.IsNullOrEmpty(userName)) { return("用户不能为空"); } #endregion try { MembershipUser user = Membership.GetUser(userName); if (user == null) { return("不存在用户:" + userName); } SysEnum seBll = new SysEnum(); var seList = seBll.GetList("and t2.EnumCode = 'SendReceiveType'", null); if (seList == null || seList.Count == 0) { return("服务端的操作类型未设定,请先完成设定"); } var firstModel = seList.OrderBy(m => m.Sort).First(); var currSeModel = seList.Find(m => m.EnumValue.Trim() == opType); if (currSeModel == null) { return("当前操作类型“" + opType + "”不存在"); } object nextNodeId = Guid.Empty; var nextSeModel = seList.FindAll(m => m.Sort > currSeModel.Sort).OrderBy(m => m.Sort).FirstOrDefault(); if (nextSeModel == null) { nextNodeId = currSeModel.Id; } else { nextNodeId = nextSeModel.Id; } bool isOsdExists = false; PDAOrderScanInfo currOsModel = new PDAOrderScanInfo(); currOsModel.OrderCode = barCode; currOsModel.CurrNodeId = currSeModel.Id; currOsModel.NextNodeId = nextNodeId; currOsModel.IsFinish = false; currOsModel.LastUpdatedDate = DateTime.Now; PDAOrderScanDetailInfo currOsdModel = new PDAOrderScanDetailInfo(); currOsdModel.OrderCode = barCode; currOsdModel.CurrNodeId = currOsModel.CurrNodeId; currOsdModel.ScanTime = scanTime; currOsdModel.UserId = user.ProviderUserKey; currOsdModel.LastUpdatedDate = currOsModel.LastUpdatedDate; Order oBll = new Order(); PDAOrderScan osBll = new PDAOrderScan(); PDAOrderScanDetail osdBll = new PDAOrderScanDetail(); TyUser tyuBll = new TyUser(); SmsSend smsBll = new SmsSend(); string sRemark = ""; TyUserInfo tyuModel = tyuBll.GetModelByUser(user.UserName); if (tyuModel != null && !string.IsNullOrWhiteSpace(tyuModel.OrganizationName)) { sRemark = string.Format(currSeModel.Remark, tyuModel.OrganizationName); } else { sRemark = currSeModel.Remark.Replace(@"{0}", ""); } sRemark = currSeModel.EnumValue + ":" + sRemark; currOsdModel.Remark = sRemark; if (opType == "干线发运" || opType == "干线到达") { var orders = oBll.GetOrderByCarcode(barCode); if (orders == null || orders.Count() == 0) { return("操作类型:" + barCode + "找不到订单号,有错误"); } foreach (var currOrderCode in orders) { currOsModel.OrderCode = currOrderCode; currOsdModel.OrderCode = currOrderCode; var oldOsdList = osdBll.GetList(currOrderCode); if (oldOsdList != null) { isOsdExists = oldOsdList.Exists(m => m.CurrNodeId.Equals(currSeModel.Id)); } if (isOsdExists) { return("订单号:" + currOrderCode + " 操作类型:" + opType + "已存在,不能重复提交"); } //发短信 SmsSendInfo ssiModel = new SmsSendInfo(); ssiModel.OrderCode = currOrderCode; ssiModel.TranNode = currSeModel.EnumCode; ssiModel.TranNodeText = currSeModel.EnumValue; using (TransactionScope scope = new TransactionScope()) { if (osBll.GetModel(currOrderCode) == null) { osBll.Insert(currOsModel); } else { osBll.Update(currOsModel); } osdBll.Insert(currOsdModel); scope.Complete(); } smsBll.InsertByStrategy(ssiModel); } } else if (currSeModel.Sort == firstModel.Sort) { var oldOsModel = osBll.GetModel(barCode); if (oldOsModel != null) { return("订单号:" + barCode + ",操作类型:" + opType + "已存在,不能重复提交"); } SmsSendInfo ssiModel = new SmsSendInfo(); ssiModel.OrderCode = barCode; ssiModel.TranNode = currSeModel.EnumCode; ssiModel.TranNodeText = currSeModel.EnumValue; using (TransactionScope scope = new TransactionScope()) { osBll.Insert(currOsModel); osdBll.Insert(currOsdModel); scope.Complete(); } smsBll.InsertByStrategy(ssiModel); } else { var oldOsModel = osBll.GetModel(barCode); if (oldOsModel == null) { return("订单号:" + barCode + ",操作类型:" + opType + "未取货,有错误"); } var oldOsdList = osdBll.GetList(barCode); if (oldOsdList != null) { isOsdExists = oldOsdList.Exists(m => m.CurrNodeId.Equals(currSeModel.Id)); currOsModel.IsFinish = oldOsdList.Count == 5; } if (currOsModel.IsFinish) { return("订单号:" + barCode + "已完成所有操作"); } if (isOsdExists) { return("订单号:" + barCode + ",操作类型:" + opType + "已存在,不能重复提交"); } SmsSendInfo ssiModel = new SmsSendInfo(); ssiModel.OrderCode = barCode; ssiModel.TranNode = currSeModel.EnumCode; ssiModel.TranNodeText = currSeModel.EnumValue; using (TransactionScope scope = new TransactionScope()) { osBll.Update(currOsModel); osdBll.Insert(currOsdModel); scope.Complete(); } smsBll.InsertByStrategy(ssiModel); } Console.WriteLine("request: opType:{0},barCode:{1},scanTime:{3},user:{2}", opType, barCode, scanTime, userName); return("保存成功"); } catch (Exception ex) { return(ex.Message); } }
public string GetJsonForSysEnum() { SysEnum bll = new SysEnum(); return(bll.GetTreeJson()); }
public void BindStep1() { this.Pub1.AddTable(); this.Pub1.AddCaption("表单创建向导:填写表单基础信息"); SysEnum se = new SysEnum(MapDataAttr.FrmType, this.FrmType); this.Pub1.AddTR(); this.Pub1.AddTD("表单类型"); this.Pub1.AddTD(se.Lab); this.Pub1.AddTD("返回上一步可以更改"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("数据源"); BP.Sys.SFDBSrc srcs = new SFDBSrc(this.DBSrc); this.Pub1.AddTD(srcs.Name); this.Pub1.AddTD("您可以把表单创建不同的数据源上."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("创建路径"); //更改绑定样式 qin //BP.Sys.SysFormTrees trees = new SysFormTrees(); //去除对应数据源根目录 //trees.Retrieve(SysFormTreeAttr.DBSrc, this.DBSrc, SysFormTreeAttr.IsDir, "0"); DataTable dt = DBAccess.RunSQLReturnTable("SELECT No,Name,ParentNo FROM Sys_FormTree WHERE DBSrc='local' AND IsDir='0'"); BP.Web.Controls.DDL ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_FrmTree"; BP.Web.Controls.DDL.MakeTree(dt, "ParentNo", "0", "No", "Name", ddl, -1); //ddl.Bind(trees, this.DBSrc); this.Pub1.AddTD(ddl); this.Pub1.AddTD("表单类别."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("<font color='Red'>*</font>表单名称"); TextBox tb = new TextBox(); tb.ID = "TB_Name"; tb.Columns = 90; tb.AutoPostBack = true; tb.TextChanged += new EventHandler(tb_TextChanged); this.Pub1.AddTD(tb); this.Pub1.AddTD("1到30个字符"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("<font color='Red'>*</font>表单编号"); tb = new TextBox(); tb.ID = "TB_No"; tb.Columns = 90; this.Pub1.AddTD(tb); this.Pub1.AddTD("以字母或者下划线开头,不能包含中文或者其他特殊字符."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("<font color='Red'>*</font>数据表"); tb = new TextBox(); tb.ID = "TB_PTable"; tb.Columns = 90; this.Pub1.AddTD(tb); this.Pub1.AddTD("只能以字母或者下划线开头,不能包含中文与其它特殊字符。"); this.Pub1.AddTREnd(); #region 快速填写. this.Pub1.AddTR(); this.Pub1.AddTD("快速填写"); this.Pub1.AddTDBegin(); RadioButton rb = new RadioButton(); rb.ID = "RB0"; rb.Text = "生成全拼名称"; rb.CheckedChanged += new EventHandler(tb_TextChanged); rb.Checked = true; rb.AutoPostBack = true; rb.GroupName = "ss"; this.Pub1.Add(rb); rb = new RadioButton(); rb.ID = "RB1"; rb.Text = "生成简拼名称"; rb.CheckedChanged += new EventHandler(tb_TextChanged); rb.GroupName = "ss"; rb.AutoPostBack = true; this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTD("注意:允许多个表单指定同一个表."); this.Pub1.AddTREnd(); #endregion 快速填写. #region 表单生成方式. this.Pub1.AddTR(); if ((BP.Sys.FrmType)(this.FrmType) != BP.Sys.FrmType.Url) { if ((BP.Sys.FrmType)(this.FrmType) == BP.Sys.FrmType.FreeFrm || (BP.Sys.FrmType)(this.FrmType) == BP.Sys.FrmType.Column4Frm || (BP.Sys.FrmType)(this.FrmType) == BP.Sys.FrmType.SLFrm) { this.Pub1.AddTD("表单生成方式"); this.Pub1.AddTDBegin("colspan=2"); rb = new RadioButton(); rb.ID = "RB_FrmGenerMode_0"; rb.Text = "直接生成表单"; rb.Checked = true; rb.GroupName = "s2s"; this.Pub1.Add(rb); this.Pub1.AddBR(); rb = new RadioButton(); rb.ID = "RB_FrmGenerMode_1"; rb.Text = "从ccfrom云表单库中选择一个表单模版导入"; rb.GroupName = "s2s"; this.Pub1.Add(rb); this.Pub1.AddBR(); rb = new RadioButton(); rb.ID = "RB_FrmGenerMode_2"; rb.Text = "从本机或其他数据库的的表导入表结构"; rb.GroupName = "s2s"; this.Pub1.Add(rb); this.Pub1.AddBR(); } //ExcelFrm,WordFrm 只保留上传 if ((BP.Sys.FrmType)(this.FrmType) == BP.Sys.FrmType.ExcelFrm || (BP.Sys.FrmType)(this.FrmType) == BP.Sys.FrmType.WordFrm) { this.Pub1.AddTD("<font color='Red'>*</font>上传" + se.Lab + "(默认模版)"); this.Pub1.AddTDBegin("colspan=2"); FileUpload fUp = new FileUpload(); fUp.ID = "fUpFrm"; fUp.Width = 300; this.Pub1.Add(" "); this.Pub1.Add(fUp); } this.Pub1.AddTDEnd(); } else { this.Pub1.AddTD("<font color='Red'>*</font>表单Url"); this.Pub1.AddTDBegin("colspan=2"); tb = new TextBox(); tb.ID = "TB_Url"; tb.Columns = 40; this.Pub1.Add(tb); this.Pub1.Add(" 请正确填写表单链接,支持全局变量@Ho"); this.Pub1.AddTDEnd(); } this.Pub1.AddTREnd(); // //ExcelFrm,WordFrm 只保留上传 //if ((BP.Sys.FrmType)(this.FrmType) == BP.Sys.FrmType.ExcelFrm || // (BP.Sys.FrmType)(this.FrmType) == BP.Sys.FrmType.WordFrm) //{ // this.Pub1.AddTRend(); // this.Pub1.AddTREnd(); //} #endregion 表单生成方式. #region 操作按钮放到table中,布局缩放不会乱 this.Pub1.AddTR(); this.Pub1.AddTDBegin(" colspan='3' "); Button btn = new Button(); btn.ID = "Btn_Save"; btn.Text = "下一步"; btn.Click += new EventHandler(BindStep1_Click); this.Pub1.Add(btn); this.Pub1.Add("<input type='button' value='返回上一步' onclick='Back();' />"); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); #endregion this.Pub1.AddTableEnd(); }
private string SetEntityAttrVal(string no, DataRow dr, Attrs attrs, Entity en, DataTable dt, int saveType) { string errInfo = ""; //按照属性赋值. foreach (Attr item in attrs) { if (item.Key == "No") { en.SetValByKey(item.Key, no); continue; } if (item.Key == "Name") { en.SetValByKey(item.Key, dr[item.Desc].ToString()); continue; } if (dt.Columns.Contains(item.Desc) == false) { continue; } //枚举处理. if (item.MyFieldType == FieldType.Enum) { string val = dr[item.Desc].ToString(); SysEnum se = new SysEnum(); int i = se.Retrieve(SysEnumAttr.EnumKey, item.UIBindKey, SysEnumAttr.Lab, val); if (i == 0) { errInfo += "err@枚举[" + item.Key + "][" + item.Desc + "],值[" + val + "]不存在."; continue; } en.SetValByKey(item.Key, se.IntKey); continue; } //外键处理. if (item.MyFieldType == FieldType.FK) { string val = dr[item.Desc].ToString(); Entity attrEn = item.HisFKEn; int i = attrEn.Retrieve("Name", val); if (i == 0) { errInfo += "err@外键[" + item.Key + "][" + item.Desc + "],值[" + val + "]不存在."; continue; } if (i != 1) { errInfo += "err@外键[" + item.Key + "][" + item.Desc + "],值[" + val + "]重复.."; continue; } //把编号值给他. en.SetValByKey(item.Key, attrEn.GetValByKey("No")); continue; } //boolen类型的处理.. if (item.MyDataType == DataType.AppBoolean) { string val = dr[item.Desc].ToString(); if (val == "是" || val == "有") { en.SetValByKey(item.Key, 1); } else { en.SetValByKey(item.Key, 0); } continue; } string myval = dr[item.Desc].ToString(); en.SetValByKey(item.Key, myval); } try { if (en.IsNoEntity == true) { if (saveType == 0) { en.Insert(); } else { en.Update(); } } } catch (Exception ex) { return("err@" + ex.Message); } return(errInfo); }
public void BindCond() { string msg = ""; string note = ""; Cond cond = new Cond(); cond.MyPK = this.GenerMyPK; cond.RetrieveFromDBSources(); if (BP.WF.Glo.OSModel == OSModel.WorkFlow) { SysEnums ses = new SysEnums("StaGrade"); Stations sts = new Stations(); sts.RetrieveAll(); string sql = "SELECT No,Name FROM Port_Station WHERE StaGrade NOT IN (SELECT IntKey FROM Sys_Enum WHERE EnumKey='StaGrade')"; DataTable dt = DBAccess.RunSQLReturnTable(sql); if (dt.Rows.Count != 0) { if (ses.Count == 0) { SysEnum se = new SysEnum(); se.EnumKey = "StaGrade"; se.Lab = "普通岗"; se.IntKey = 0; se.Insert(); ses.AddEntity(se); } foreach (Station st in sts) { st.StaGrade = 0; st.Save(); } //Pub1.AddEasyUiPanelInfo("错误", // "在ccflow的集成工作模式下,岗位表集成或者维护错误,有" + dt.Rows.Count + // "个岗位枚举值对应不上:<br />{技术信息:排查的sql:" + sql + "}", "icon-no"); //return; } this.Pub1.AddTable("class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'"); foreach (SysEnum se in ses) { this.Pub1.AddTR(); CheckBox mycb = new CheckBox(); mycb.Text = se.Lab; mycb.ID = "CB_s_d" + se.IntKey; this.Pub1.AddTD("colspan=3 class='GroupTitle'", mycb); this.Pub1.AddTREnd(); int i = 0; string ctlIDs = ""; foreach (Station st in sts) { if (st.StaGrade != se.IntKey) { continue; } i++; if (i == 4) { i = 1; } if (i == 1) { Pub1.AddTR(); } CheckBox cb = new CheckBox(); cb.ID = "CB_" + st.No; ctlIDs += cb.ID + ","; cb.Text = st.Name; if (cond.OperatorValue.ToString().Contains("@" + st.No + "@")) { cb.Checked = true; } Pub1.AddTD(cb); if (i == 3) { Pub1.AddTREnd(); } } mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')"; switch (i) { case 1: Pub1.AddTD(); Pub1.AddTD(); Pub1.AddTREnd(); break; case 2: Pub1.AddTD(); Pub1.AddTREnd(); break; default: break; } } } else { /*BPM 模式*/ BP.GPM.StationTypes tps = new BP.GPM.StationTypes(); tps.RetrieveAll(); BP.GPM.Stations sts = new BP.GPM.Stations(); sts.RetrieveAll(); string sql = "SELECT No,Name FROM Port_Station WHERE FK_StationType NOT IN (SELECT No FROM Port_StationType)"; DataTable dt = DBAccess.RunSQLReturnTable(sql); if (dt.Rows.Count != 0) { if (tps.Count == 0) { var stp = new BP.GPM.StationType { No = "01", Name = "普通岗" }; stp.Save(); tps.AddEntity(stp); } //更新所有对不上岗位类型的岗位,岗位类型为01或第一个 foreach (BP.GPM.Station st in sts) { st.FK_StationType = tps[0].No; st.Update(); } //Pub1.AddEasyUiPanelInfo("错误", // "在ccflow的集成工作模式下,岗位表集成或者维护错误,有" + dt.Rows.Count + // "个岗位外键对应不上:<br />{技术信息:排查的sql:" + sql + "}", "icon-no"); //return; } this.Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'"); foreach (BP.GPM.StationType tp in tps) { this.Pub1.AddTR(); CheckBox mycb = new CheckBox(); mycb.Text = tp.Name; mycb.ID = "CB_s_d" + tp.No; this.Pub1.AddTD("colspan=3 class='GroupTitle'", mycb); this.Pub1.AddTREnd(); int i = 0; string ctlIDs = ""; foreach (BP.GPM.Station st in sts) { if (st.FK_StationType != tp.No) { continue; } i++; if (i == 4) { i = 1; } if (i == 1) { Pub1.AddTR(); } CheckBox cb = new CheckBox(); cb.ID = "CB_" + st.No; ctlIDs += cb.ID + ","; cb.Text = st.Name; if (cond.OperatorValue.ToString().Contains("@" + st.No + "@")) { cb.Checked = true; } this.Pub1.AddTD(cb); if (i == 3) { Pub1.AddTREnd(); } } mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')"; switch (i) { case 1: Pub1.AddTD(); Pub1.AddTD(); Pub1.AddTREnd(); break; case 2: Pub1.AddTD(); Pub1.AddTREnd(); break; default: break; } } } this.Pub1.AddTableEnd(); Pub1.AddBR(); Pub1.AddSpace(1); var btn = new LinkBtn(false, NamesOfBtn.Save, "保存"); btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); Pub1.AddSpace(1); btn = new LinkBtn(false, NamesOfBtn.Delete, "删除"); btn.Attributes["onclick"] = " return confirm('您确定要删除吗?');"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); }
protected void Page_Load(object sender, EventArgs e) { PushMsgs msgs = new PushMsgs(this.FK_Flow); var msg = msgs.GetEntityByKey(PushMsgAttr.FK_Event, this.Event, PushMsgAttr.FK_Node, int.Parse(this.NodeID)) as PushMsg; if (msg == null) { msg = new PushMsg(); msg.FK_Event = this.Event; msg.FK_Node = int.Parse(this.NodeID); } if (!string.IsNullOrWhiteSpace(this.ThePushWay)) { if (this.ThePushWay != msg.PushWay.ToString()) { msg.PushDoc = string.Empty; msg.Tag = string.Empty; } msg.PushWay = int.Parse(this.ThePushWay); } this.Pub1.AddTable("class='Table' cellspacing='1' cellpadding='1' border='1' style='width:100%'"); this.Pub1.AddTR(); this.Pub1.AddTD("style='width:100px'", "推送设置方式:"); var ddl = new DDL(); ddl.BindSysEnum(PushMsgAttr.PushWay); ddl.ID = "DDL_" + PushMsgAttr.PushWay; ddl.SetSelectItem((int)msg.PushWay); ddl.AutoPostBack = true; ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged); this.Pub1.AddTD(ddl); this.Pub1.AddTREnd(); switch ((PushWay)msg.PushWay) { case PushWay.ByParas: #region 照系统指定参数 Pub1.AddTR(); Pub1.AddTD("输入参数名:"); Pub1.AddTDBegin(); var rad = new RadioBtn(); rad.GroupName = "Para"; rad.ID = "RB_0"; rad.Text = "系统参数"; rad.Checked = msg.PushDoc == "0"; Pub1.Add(rad); var tb = new TB(); tb.ID = "TB_" + PushMsgAttr.Tag; if (msg.PushDoc == "0") { tb.Text = msg.Tag; } else { tb.Text = "NoticeTo"; } Pub1.Add(tb); Pub1.Add(" 默认为NoticeTo"); Pub1.AddBR(); rad = new RadioBtn(); rad.GroupName = "Para"; rad.ID = "RB_1"; rad.Text = "表单字段参数"; rad.Checked = msg.PushDoc == "1"; Pub1.Add(rad); MapAttrs attrs = new MapAttrs(); attrs.Retrieve(MapAttrAttr.FK_MapData, "ND" + this.NodeID); MapAttrs attrNs = new MapAttrs(); foreach (MapAttr attr in attrs) { if (attr.IsBigDoc) { continue; } switch (attr.KeyOfEn) { case "Title": case "FK_Emp": case "MyNum": case "FK_NY": case WorkAttr.Emps: case WorkAttr.OID: case StartWorkAttr.Rec: case StartWorkAttr.FID: continue; default: break; } attrNs.AddEntity(attr); } ddl = new DDL(); ddl.ID = "DDL_" + PushMsgAttr.Tag; ddl.BindEntities(attrNs, MapAttrAttr.MyPK, MapAttrAttr.Name); ddl.AutoPostBack = false; if (msg.PushDoc == "1") { ddl.SetSelectItem(msg.Tag); } Pub1.Add(ddl); Pub1.AddTREnd(); #endregion break; case PushWay.NodeWorker: #region 照指定结点的工作人员 Pub1.AddTR(); Pub1.AddTDBegin("colspan='2'"); Pub1.Add("请选择要推送到的节点工作人员:<br />"); Nodes nds = new Nodes(this.FK_Flow); CheckBox cb = null; foreach (BP.WF.Node nd in nds) { if (nd.NodeID == int.Parse(this.NodeID)) { continue; } cb = new CheckBox(); cb.ID = "CB_" + nd.NodeID; cb.Text = nd.NodeID + " " + nd.Name; cb.Checked = msg.PushDoc.Contains("@" + nd.NodeID + "@"); Pub1.Add(cb); Pub1.AddBR(); } Pub1.AddTDEnd(); Pub1.AddTREnd(); #endregion break; case PushWay.SpecDepts: #region 照指定的部门 Pub1.AddTR(); Pub1.AddTDBegin("colspan='2'"); this.Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'"); this.Pub1.AddTR(); this.Pub1.AddTD("colspan='3' class='GroupTitle'", "部门选择"); this.Pub1.AddTREnd(); //NodeDepts ndepts = new NodeDepts(int.Parse(this.NodeID)); Depts depts = new Depts(); depts.RetrieveAll(); int i = 0; //foreach (NodeDept dept in ndepts) foreach (Dept dept in depts) { i++; if (i == 4) { i = 1; } if (i == 1) { Pub1.AddTR(); } cb = new CheckBox(); //cb.ID = "CB_" + dept.FK_Dept; //cb.Text = (depts.GetEntityByKey(dept.FK_Dept) as Dept).Name; cb.ID = "CB_" + dept.No; cb.Text = dept.Name; //if (msg.PushDoc.Contains("@" + dept.FK_Dept + "@")) if (msg.PushDoc.Contains("@" + dept.No + "@")) { cb.Checked = true; } this.Pub1.AddTD(cb); if (i == 3) { Pub1.AddTREnd(); } } switch (i) { case 1: Pub1.AddTD(); Pub1.AddTD(); Pub1.AddTREnd(); break; case 2: Pub1.AddTD(); Pub1.AddTREnd(); break; default: break; } this.Pub1.AddTableEnd(); Pub1.AddTDEnd(); Pub1.AddTREnd(); #endregion break; case PushWay.SpecEmps: #region 照指定的人员 Pub1.AddTR(); //Pub1.AddTDBegin("colspan='2'"); Pub1.AddTD("选择人员:"); Pub1.AddTDBegin(); tb = new TB(); tb.ID = "TB_Users"; tb.TextMode = TextBoxMode.MultiLine; tb.Style.Add("width", "99%"); tb.Rows = 4; tb.ReadOnly = true; var hf = new HiddenField(); hf.ID = "HID_Users"; //加载已经选择的人员 if (!string.IsNullOrWhiteSpace(msg.PushDoc)) { hf.Value = msg.PushDoc.Replace("@@", ",").Trim('@'); var emps = new Emps(); emps.RetrieveAll(); tb.Text = hf.Value.Split(',').Select(o => (emps.GetEntityByKey(o) as Emp).Name).Aggregate( string.Empty, (curr, next) => curr + next + ",").TrimEnd(','); } Pub1.Add(tb); Pub1.Add(hf); Pub1.AddBR(); Pub1.AddBR(); Pub1.Add( "<a class='easyui-linkbutton' data-options=\"iconCls:'icon-user'\" href='javascript:void(0)' onclick=\"showWin('../Comm/Port/SelectUser_Jq.aspx','" + tb.ClientID + "','" + hf.ClientID + "');\">选择人员...</a>"); Pub1.AddTDEnd(); //Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'"); //depts = new Depts(); //depts.RetrieveAll(); //var emps = new Emps(); //emps.RetrieveAll(); //var empDepts = new EmpDepts(); //empDepts.RetrieveAll(); //var nemps = new NodeEmps(int.Parse(this.NodeID)); //Emp emp = null; //foreach (Dept dept in depts) //{ // this.Pub1.AddTR(); // var mycb = new CheckBox(); // mycb.Text = dept.Name; // mycb.ID = "CB_D_" + dept.No; // this.Pub1.AddTD("colspan='3' class='GroupTitle'", mycb); // this.Pub1.AddTREnd(); // i = 0; // string ctlIDs = ""; // foreach (EmpDept ed in empDepts) // { // if (ed.FK_Dept != dept.No) // continue; // //排除非当前结点绑定的人员 // if (nemps.GetEntityByKey(NodeEmpAttr.FK_Emp, ed.FK_Emp) == null) // continue; // i++; // if (i == 4) // i = 1; // if (i == 1) // Pub1.AddTR(); // emp = emps.GetEntityByKey(ed.FK_Emp) as Emp; // cb = new CheckBox(); // cb.ID = "CB_E_" + emp.No; // ctlIDs += cb.ID + ","; // cb.Text = emp.Name; // if (msg.PushDoc.Contains("@" + emp.No + "@")) // cb.Checked = true; // Pub1.AddTD(cb); // if (i == 3) // Pub1.AddTREnd(); // } // mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')"; // switch (i) // { // case 1: // Pub1.AddTD(); // Pub1.AddTD(); // Pub1.AddTREnd(); // break; // case 2: // Pub1.AddTD(); // Pub1.AddTREnd(); // break; // default: // break; // } //} //Pub1.AddTableEnd(); //Pub1.AddTDEnd(); Pub1.AddTREnd(); #endregion break; case PushWay.SpecSQL: #region 照指定的SQL查询语句 Pub1.AddTR(); this.Pub1.AddTDBegin("colspan='2'"); this.Pub1.Add("SQL查询语句:<br />"); tb = new TB(); tb.ID = "TB_" + PushMsgAttr.PushDoc; tb.Columns = 50; tb.Style.Add("width", "99%"); tb.TextMode = TextBoxMode.MultiLine; tb.Rows = 4; tb.Text = msg.PushDoc; this.Pub1.Add(tb); this.Pub1.AddTDEnd(); Pub1.AddTREnd(); #endregion break; case PushWay.SpecStations: #region 照指定的岗位 Pub1.AddTR(); Pub1.AddTDBegin("colspan='2'"); if (BP.WF.Glo.OSModel == OSModel.WorkFlow) { SysEnums ses = new SysEnums("StaGrade"); Stations sts = new Stations(); sts.RetrieveAll(); string sql = "SELECT No,Name FROM Port_Station WHERE StaGrade NOT IN (SELECT IntKey FROM Sys_Enum WHERE EnumKey='StaGrade')"; DataTable dt = DBAccess.RunSQLReturnTable(sql); if (dt.Rows.Count != 0) { if (ses.Count == 0) { SysEnum se = new SysEnum(); se.EnumKey = "StaGrade"; se.Lab = "普通岗"; se.IntKey = 0; se.Insert(); ses.AddEntity(se); } foreach (Station st in sts) { st.StaGrade = 0; st.Save(); } } this.Pub1.AddTable("class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'"); foreach (SysEnum se in ses) { this.Pub1.AddTR(); CheckBox mycb = new CheckBox(); mycb.Text = se.Lab; mycb.ID = "CB_SG_" + se.IntKey; this.Pub1.AddTD("colspan='3' class='GroupTitle'", mycb); this.Pub1.AddTREnd(); i = 0; string ctlIDs = ""; foreach (Station st in sts) { if (st.StaGrade != se.IntKey) { continue; } i++; if (i == 4) { i = 1; } if (i == 1) { Pub1.AddTR(); } cb = new CheckBox(); cb.ID = "CB_S_" + st.No; ctlIDs += cb.ID + ","; cb.Text = st.Name; if (msg.PushDoc.Contains("@" + st.No + "@")) { cb.Checked = true; } Pub1.AddTD(cb); if (i == 3) { Pub1.AddTREnd(); } } mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')"; switch (i) { case 1: Pub1.AddTD(); Pub1.AddTD(); Pub1.AddTREnd(); break; case 2: Pub1.AddTD(); Pub1.AddTREnd(); break; default: break; } } this.Pub1.AddTableEnd(); } else { /*BPM 模式*/ BP.GPM.StationTypes tps = new BP.GPM.StationTypes(); tps.RetrieveAll(); BP.GPM.Stations sts = new BP.GPM.Stations(); sts.RetrieveAll(); string sql = "SELECT No,Name FROM Port_Station WHERE FK_StationType NOT IN (SELECT No FROM Port_StationType)"; DataTable dt = DBAccess.RunSQLReturnTable(sql); if (dt.Rows.Count != 0) { if (tps.Count == 0) { var stp = new BP.GPM.StationType { No = "01", Name = "普通岗" }; stp.Save(); tps.AddEntity(stp); } //更新所有对不上岗位类型的岗位,岗位类型为01或第一个 foreach (BP.GPM.Station st in sts) { st.FK_StationType = tps[0].No; st.Update(); } } this.Pub1.AddTable("class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'"); foreach (BP.GPM.StationType tp in tps) { this.Pub1.AddTR(); CheckBox mycb = new CheckBox(); mycb.Text = tp.Name; mycb.ID = "CB_ST_" + tp.No; this.Pub1.AddTD("colspan='3' class='GroupTitle'", mycb); this.Pub1.AddTREnd(); i = 0; string ctlIDs = ""; foreach (BP.GPM.Station st in sts) { if (st.FK_StationType != tp.No) { continue; } i++; if (i == 4) { i = 1; } if (i == 1) { Pub1.AddTR(); } cb = new CheckBox(); cb.ID = "CB_S_" + st.No; ctlIDs += cb.ID + ","; cb.Text = st.Name; if (msg.PushDoc.Contains("@" + st.No + "@")) { cb.Checked = true; } this.Pub1.AddTD(cb); if (i == 3) { Pub1.AddTREnd(); } } mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')"; switch (i) { case 1: Pub1.AddTD(); Pub1.AddTD(); Pub1.AddTREnd(); break; case 2: Pub1.AddTD(); Pub1.AddTREnd(); break; default: break; } } this.Pub1.AddTableEnd(); } #region 原逻辑,只考虑了一种模式,停用 //Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'"); //SysEnums ses = new SysEnums("StaGrade"); //Stations sts = new Stations(); //NodeStations nsts = new NodeStations(int.Parse(this.NodeID)); //sts.RetrieveAll(); //foreach (SysEnum se in ses) //{ // this.Pub1.AddTR(); // var mycb = new CheckBox(); // mycb.Text = se.Lab; // mycb.ID = "CB_SG_" + se.IntKey; // this.Pub1.AddTD("colspan=3 class='GroupTitle'", mycb); // this.Pub1.AddTREnd(); // i = 0; // string ctlIDs = ""; // foreach (Station st in sts) // { // if (st.StaGrade != se.IntKey) // continue; // //排除非当前结点的岗位 // if (nsts.GetEntityByKey(NodeStationAttr.FK_Station, st.No) == null) // continue; // i++; // if (i == 4) // i = 1; // if (i == 1) // Pub1.AddTR(); // cb = new CheckBox(); // cb.ID = "CB_S_" + st.No; // ctlIDs += cb.ID + ","; // cb.Text = st.Name; // if (msg.PushDoc.Contains("@" + st.No + "@")) // cb.Checked = true; // Pub1.AddTD(cb); // if (i == 3) // Pub1.AddTREnd(); // } // mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')"; // switch (i) // { // case 1: // Pub1.AddTD(); // Pub1.AddTD(); // Pub1.AddTREnd(); // break; // case 2: // Pub1.AddTD(); // Pub1.AddTREnd(); // break; // default: // break; // } //} //Pub1.AddTableEnd(); #endregion Pub1.AddTDEnd(); Pub1.AddTREnd(); #endregion break; } Pub1.AddTableEnd(); Pub1.AddBR(); Pub1.AddSpace(1); var btn = new LinkBtn(false, NamesOfBtn.Save, "保存"); btn.Click += new EventHandler(btn_Click); Pub1.Add(btn); if (!string.IsNullOrWhiteSpace(msg.MyPK)) { Pub1.AddSpace(1); btn = new LinkBtn(false, NamesOfBtn.Delete, "删除"); btn.Click += new EventHandler(btn_Delete_Click); btn.Attributes["onclick"] = "return confirm('你确定要删除此消息推送设置吗?');"; Pub1.Add(btn); } }
void btn_Save_Click(object sender, EventArgs e) { try { SysEnumMain main = new SysEnumMain(); if (this.RefNo == null) { main.No = this.Pub1.GetTBByID("TB_No").Text; if (main.IsExits) { //this.Alert("编号(枚举英文名称)[" + main.No + "]已经存在。"); this.Alert("编号(枚举英文名称)[" + main.No + "]已经存在。"); return; } SysEnum se = new SysEnum(); if (se.IsExit(SysEnumAttr.EnumKey, main.No) == true) { this.Alert("编号(枚举英文名称)[" + main.No + "]已经存在。"); return; } main = (SysEnumMain)this.Pub1.Copy(main); if (main.No.Length == 0 || main.Name.Length == 0) { throw new Exception("编号与名称不能为空"); } } else { main.No = this.RefNo; main.Retrieve(); main = (SysEnumMain)this.Pub1.Copy(main); if (main.No.Length == 0 || main.Name.Length == 0) { throw new Exception("编号与名称不能为空"); } } string cfgVal = ""; int idx = -1; while (idx < 19) { idx++; string t = this.Pub1.GetTBByID("TB_" + idx).Text.Trim(); if (t.Length == 0) { continue; } cfgVal += "@" + idx + "=" + t; } main.CfgVal = cfgVal; if (main.CfgVal == "") { throw new Exception("错误:您必须输入枚举值,请参考帮助。"); //错误:您必须输入枚举值,请参考帮助。 } main.Save(); //重新生成 SysEnums se1s = new SysEnums(); se1s.Delete(SysEnumAttr.EnumKey, main.No); SysEnums ses = new SysEnums(); ses.RegIt(main.No, cfgVal); string keyApp = "EnumOf" + main.No + WebUser.SysLang; BP.DA.Cash.DelObjFormApplication(keyApp); if (this.MyPK != null) { this.Response.Redirect("SysEnum.aspx?RefNo=" + main.No + "&MyPK=" + this.MyPK + "&IDX=" + this.IDX, true); } return; } catch (Exception ex) { this.ResponseWriteBlueMsg(ex.Message); //this.ToErrorPage(ex.Message); //this.Alert(ex.Message); } }
public void BindSysEnum(SysEnumMain en) { SysEnums ses = new SysEnums(); if (en.No.Length > 0) { //ses = new SysEnums(en.No); ses.Retrieve(SysEnumAttr.EnumKey, en.No); } this.Pub1.AddTable(); if (this.RefNo == null) { this.Pub1.AddCaptionLeft("<a href='Do.aspx?DoType=AddF&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'>增加新字段向导</a> - <a href='Do.aspx?DoType=AddSysEnum&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'>枚举字段</a> - 新建"); } else { this.Pub1.AddCaptionLeft("<a href='Do.aspx?DoType=AddF&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'>增加新字段向导</a> - <a href='Do.aspx?DoType=AddSysEnum&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'>枚举字段</a> - 编辑"); } if (this.RefNo == null) { this.Title = "新建枚举"; } else { this.Title = "编辑枚举类型"; } this.Pub1.AddTR(); this.Pub1.AddTDTitle(" "); this.Pub1.AddTDTitle(" "); this.Pub1.AddTDTitle("备注"); this.Pub1.AddTREnd(); this.Pub1.AddTRSum(); this.Pub1.AddTD("编号"); BP.Web.Controls.TB tb = new BP.Web.Controls.TB(); tb.ID = "TB_No"; tb.Text = en.No; if (this.RefNo == null) { tb.Enabled = true; } else { tb.Enabled = false; } this.Pub1.AddTD(tb); this.Pub1.AddTD("枚举英文名称"); this.Pub1.AddTREnd(); this.Pub1.AddTRSum(); this.Pub1.AddTD("名称"); tb = new BP.Web.Controls.TB(); tb.ID = "TB_Name"; tb.Text = en.Name; this.Pub1.AddTD(tb); this.Pub1.AddTD("枚举中文名称"); this.Pub1.AddTREnd(); int idx = 0; while (idx < 20) { this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx); tb = new BP.Web.Controls.TB(); tb.ID = "TB_" + idx; SysEnum se = ses.GetEntityByKey(SysEnumAttr.IntKey, idx) as SysEnum; if (se != null) { tb.Text = se.Lab; } // tb.Text = en.Name; this.Pub1.AddTD(tb); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); idx++; } this.Pub1.AddTRSum(); this.Pub1.Add("<TD colspan=3 align=center>"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_Add"; btn.Text = "添加到表单"; // "添加到表单"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Add_Click); if (this.RefNo == null) { btn.Enabled = false; } this.Pub1.Add(btn); btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_Del"; btn.Text = " 删除 "; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; if (this.RefNo == null) { btn.Enabled = false; } btn.Click += new EventHandler(btn_Del_Click); this.Pub1.Add(btn); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); }
public string SaveSysEnum(SysEnumInfo model) { if (string.IsNullOrWhiteSpace(model.EnumName)) { return(MC.Submit_Params_InvalidError); } if (string.IsNullOrWhiteSpace(model.EnumCode)) { return(MC.Submit_Params_InvalidError); } if (string.IsNullOrWhiteSpace(model.EnumValue)) { return(MC.Submit_Params_InvalidError); } Guid gId = Guid.Empty; Guid.TryParse(model.Id.ToString(), out gId); model.Id = gId; Guid parentId = Guid.Empty; Guid.TryParse(model.ParentId.ToString(), out parentId); model.ParentId = parentId; SysEnum bll = new SysEnum(); int effect = -1; if (!gId.Equals(Guid.Empty)) { effect = bll.Update(model); } else { using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.Suppress)) { if (bll.IsExist(model.EnumCode, model.ParentId, model.Id)) { effect = 110; } else { effect = bll.Insert(model); } scope2.Complete(); } scope.Complete(); } } if (effect == 110) { return(MC.Submit_Exist); } if (effect > 0) { return("1"); } else { return(MC.Submit_Error); } }