protected override void AfterUpdate() { base.AfterUpdate(); if (!this.ManagerMessage.IsThrow) { if (EnvProvider.Default.ScheduleTaskOpened) { DataRow masterRow = this.DataSet.Tables[0].Rows[0]; string taskId = LibSysUtils.ToString(masterRow["TASKID"]); LibBusinessTask task = null; PostAccountWay way = PostAccountHelper.GetPostAccountWay(PostAccountState.Release, masterRow); switch (way) { case PostAccountWay.Diff: string oldTaskId = LibSysUtils.ToString(masterRow["TASKID", DataRowVersion.Original]); LibBusinessTaskCache.Default.RemoveCacheItem(oldTaskId); LibScheduleTaskHost.Default.DeleteTask(oldTaskId); task = AddTask(); LibScheduleTaskHost.Default.AddTask(task); break; case PostAccountWay.Positive: task = AddTask(); LibScheduleTaskHost.Default.AddTask(task); break; case PostAccountWay.Reverse: LibBusinessTaskCache.Default.RemoveCacheItem(LibSysUtils.ToString(masterRow["TASKID"])); LibScheduleTaskHost.Default.DeleteTask(taskId); break; } } } }
/// <summary> /// 构造跨站点调用的临时登录 /// </summary> /// <param name="userId"></param> /// <returns></returns> public LibHandle GetCrossCallHandle(string userId) { if (string.IsNullOrEmpty(userId)) { return(null); } LibHandle handle = new LibHandle(LibHandeleType.CrossSiteCall, userId, ""); SqlBuilder builder = new SqlBuilder("axp.User"); string sql = builder.GetQuerySql(0, "A.PERSONID,A.PERSONNAME,A.ROLEID,A.WALLPAPER,A.WALLPAPERSTRETCH", string.Format("A.USERID={0} And A.ISUSE=1", LibStringBuilder.GetQuotString(userId))); LibDataAccess dataAccess = new LibDataAccess(); bool exist = false; using (IDataReader reader = dataAccess.ExecuteDataReader(sql)) { if (reader.Read()) { handle.PersonId = LibSysUtils.ToString(reader[0]); handle.PersonName = LibSysUtils.ToString(reader[1]); handle.RoleId = LibSysUtils.ToString(reader[2]); exist = true; } } if (exist) { this.Set(handle.Handle, handle); return(handle); } else { return(null); } }
private static Boolean SetWorkProcessInfo(string billNo) { Boolean ret = false; ProduceData produceData = LibProduceCache.Default.GetProduceData(billNo); if (produceData != null) { foreach (DataRow curRow in produceData.WorkOrder.Tables[3].Rows) { ret = true; DataRow parentRow = produceData.WorkOrder.Tables[2].Rows.Find(new object[] { curRow["BILLNO"], curRow["PARENTROWID"] }); if (!LibSysUtils.ToBoolean(parentRow["NEEDGATHER"])) { continue; } string workstationId = LibSysUtils.ToString(curRow["WORKSTATIONID"]); if (!_ProductScheduling.WsRelWorkOrder.ContainsKey(workstationId)) { _ProductScheduling.WsRelWorkOrder.Add(workstationId, new List <string>() { billNo }); } if (!_ProductScheduling.WsRelWorkOrder[workstationId].Contains(billNo)) { _ProductScheduling.WsRelWorkOrder[workstationId].Add(billNo); } if (produceData.FirstWorkProcessNo.Contains(LibSysUtils.ToInt32(parentRow["WORKPROCESSNO"])) && !_ProductScheduling.FirstWs.Contains(workstationId)) { _ProductScheduling.FirstWs.Add(workstationId); } } } return(ret); }
public SetPwdResult SetPassword(string handle, string oldPwd, string newPwd) { SetPwdResult result = new SetPwdResult(); LibHandle libHandle = LibHandleCache.Default.GetCurrentHandle(handle) as LibHandle; if (libHandle == null) { throw new Exception("用户句柄无效。"); } string sql = string.Format("select USERID from AXPUSER where USERID={0} and USERPASSWORD={1}", LibStringBuilder.GetQuotString(libHandle.UserId), LibStringBuilder.GetQuotString(oldPwd)); LibDataAccess dataAccess = new LibDataAccess(); string userId = LibSysUtils.ToString(dataAccess.ExecuteScalar(sql)); if (string.IsNullOrEmpty(userId)) { result.Msg = "输入的旧密码与系统不匹配。"; result.Success = false; } else { dataAccess.ExecuteNonQuery(string.Format("update AXPUSER set USERPASSWORD={2} where USERID={0} and USERPASSWORD={1}", LibStringBuilder.GetQuotString(libHandle.UserId), LibStringBuilder.GetQuotString(oldPwd), LibStringBuilder.GetQuotString(newPwd))); result.Success = true; } return(result); }
/// <summary> /// 获取用户可访问的站点 /// </summary> /// <param name="userHandle"></param> /// <returns></returns> public List <LinkSiteInfo> GetLinkSites(string userHandle) { // 判断userHandle存不存在 LibHandle handle = LibHandleCache.Default.GetCurrentHandle(userHandle); if (handle == null) { throw new Exception("用户句柄无效"); } List <LinkSiteInfo> linkSiteInfoList = new List <LinkSiteInfo>(); string sql = string.Format("select B.SITEID, B.SITENAME, B.SHORTNAME, B.SITEURL, B.SVCURL, B.ISSLAVE,B.ISSENDTO from AXPUSERSITE A join AXPLINKSITE B on A.SITEID = B.SITEID where A.USERID = {0}", LibStringBuilder.GetQuotString(handle.UserId)); LibDataAccess dataAccess = new LibDataAccess(); using (IDataReader reader = dataAccess.ExecuteDataReader(sql)) { while (reader.Read()) { var siteInfo = new LinkSiteInfo() { SiteId = LibSysUtils.ToString(reader["SITEID"]), SiteName = LibSysUtils.ToString(reader["SITENAME"]), ShortName = LibSysUtils.ToString(reader["SHORTNAME"]), SiteUrl = LibSysUtils.ToString(reader["SITEURL"]), SvcUrl = LibSysUtils.ToString(reader["SVCURL"]), IsSlave = LibSysUtils.ToBoolean(reader["ISSLAVE"]), IsSendTo = LibSysUtils.ToBoolean(reader["ISSENDTO"]), }; linkSiteInfoList.Add(siteInfo); } } return(linkSiteInfoList); }
private void 多语言配置ToolStripMenuItem_Click(object sender, EventArgs e) { SDPCRL.COM.ModelManager.LibDataSource ds = null; SDPCRL.COM.ModelManager.FormTemplate.LibFormPage fm = null; SDPCRL.COM.ModelManager.LibKeyValueCollection keyvaluecollection = null; TabPage page = this.libTabControl1.SelectedTab; if (page != null) { string[] nameAndtype = page.Name.Split(SysConstManage.Underline); NodeType ntype = LibSysUtils.ConvertToEnumType <NodeType>(nameAndtype[1]); switch (ntype) { case NodeType.DataModel: ds = ModelDesignProject.GetDataSourceById(nameAndtype[0]); break; case NodeType.FormModel: fm = ModelDesignProject.GetFormSourceByFormId(nameAndtype[0]); if (fm != null && !string.IsNullOrEmpty(fm.DSID)) { ds = ModelDesignProject.GetDataSourceById(fm.DSID); } break; case NodeType.KeyValues: keyvaluecollection = ModelDesignProject.GetKeyvaluesByid(nameAndtype[0]); break; } } WakeUpForm <LanguageConfig>("language", ds, fm, keyvaluecollection); }
public static decimal GetFormater(decimal value, string unitId, LibFormatType formatType = LibFormatType.Quantity) { //目前只实现数量的格式化 int retainDigits = LibSysUtils.ToInt32(LibFormatUnitCache.Default.GetFormatData(unitId)); return(decimal.Round(value, retainDigits)); }
public object fuzzySearchField(HttpContext context) { ExecuteBcfMethodResult result = new ExecuteBcfMethodResult(); string data = context.Request["data"]; MDictionary <string, string> dic = new MDictionary <string, string>(); if (!string.IsNullOrEmpty(data)) { dic = JsonConvert.DeserializeObject <MDictionary <string, string> >(data); } BillService service = new BillService(); string handle = dic["Handle"]; string relSource = dic["RelSource"]; string query = dic["Query"]; string condition = dic["Condition"]; Int16 tableIndex = LibSysUtils.ToInt16(dic["TableIndex"]); string selectSql = dic["SelectSql"]; string selectFields = dic["SelectFields"]; result.Result = service.FuzzySearchField1(handle, relSource, selectFields, query, condition, tableIndex, selectSql); //result.Result = service.FuzzySearchField(handle, relSource, query, condition, tableIndex); return(result); }
/// <summary> /// 根据部门标识和关键词,查找部门任职表中的岗位信息,返回IdName形式的数组供前端展示选择 /// Zhangkj 20170323 /// </summary> /// <param name="deptId"></param> /// <param name="queryKey"></param> /// <returns></returns> public IList <FuzzyResult> SearchDutyIdNameFromDept(string deptId, string queryKey) { List <FuzzyResult> list = new List <FuzzyResult>(); try { if (string.IsNullOrEmpty(deptId)) { return(list); } string querySql = string.Format("Select distinct A.DUTYID,B.DUTYNAME from COMDEPTDUTYPERSON A left join COMDUTY B on A.DUTYID = B.DUTYID " + " where A.DEPTID = {0} and ( A.DUTYID like {1} or B.DUTYNAME like {1} ) ", LibStringBuilder.GetQuotString(deptId), LibStringBuilder.GetQuotString(string.Format("%{0}%", queryKey)) ); int count = 0; using (IDataReader reader = this.DataAccess.ExecuteDataReader(querySql)) { while (reader.Read()) { list.Add(new FuzzyResult(LibSysUtils.ToString(reader[0]), LibSysUtils.ToString(reader[1]))); count++; if (count == 30) { break; } } } } catch (Exception exp) { // to do Log } return(list); }
protected override void AfterDelete() { base.AfterDelete(); DataRow masterRow = this.DataSet.Tables[0].Rows[0]; LibApproveFlowCache.Default.RemoveCacheItem(LibSysUtils.ToString(masterRow["PROGID"]), LibSysUtils.ToBoolean(masterRow["ISAPPROVEROW"])); }
protected override void AfterCommintData() { base.AfterCommintData(); if (!this.ManagerMessage.IsThrow) { List <AxCRL.Core.Mail.LibMailParam> list = new List <AxCRL.Core.Mail.LibMailParam>(); foreach (DataRow curRow in this.DataSet.Tables[0].Rows) { if (curRow.RowState == DataRowState.Modified) { if (LibSysUtils.ToBoolean(curRow["ISUSE"]) && !LibSysUtils.ToBoolean(curRow["ISUSE", DataRowVersion.Original])) { AxCRL.Core.Mail.LibMailParam param = new AxCRL.Core.Mail.LibMailParam(); param.Content = string.Format("您的账号 {0} 已开通。", curRow["USERID"]); param.MailKind = AxCRL.Core.Mail.LibMailKind.Info; param.Subject = "智慧工厂账号开通"; param.To = new List <string>() { LibSysUtils.ToString(curRow["PERSONID"]) }; list.Add(param); } } } if (list.Count > 0) { ThreadPool.QueueUserWorkItem(LibMailHelper.SendMail, list); } } }
public CalendarData(string calendarId) { if (string.IsNullOrEmpty(calendarId)) { return; } LibDataAccess dataAccess = new LibDataAccess(); SqlBuilder sqlBuilder = new SqlBuilder("com.Calendar"); string sql = sqlBuilder.GetQuerySql(1, "B.YEAR,B.MONTH,B.WORKMARK", string.Format("B.CALENDARID={0}", LibStringBuilder.GetQuotString(calendarId))); using (IDataReader reader = dataAccess.ExecuteDataReader(sql)) { while (reader.Read()) { int year = LibSysUtils.ToInt32(reader[1]); if (!WorkDayList.ContainsKey(year)) { WorkDayList.Add(year, new int[12]); } int[] items = WorkDayList[year]; int month = LibSysUtils.ToInt32(reader["MONTH"]); items[month - 1] = LibSysUtils.ToInt32(reader["WORKMARK"]); } } }
protected override void BeforeUpdate() { base.BeforeUpdate(); HashSet <string> hasSet = new HashSet <string>(); foreach (DataRow curRow in this.DataSet.Tables[1].Rows) { if (curRow.RowState == DataRowState.Deleted) { continue; } DataRow[] subRows = curRow.GetChildRows("AXPPERMISSIONGROUPDETAIL_AXPOPERATEPOWER", DataRowVersion.Current); int mark = 0; foreach (DataRow subRow in subRows) { if (LibSysUtils.ToBoolean(subRow["CANUSE"])) { mark += LibSysUtils.ToInt32(subRow["OPERATEPOWERID"]); } } curRow["OPERATEMARK"] = mark; string progId = LibSysUtils.ToString(curRow["PROGID"]); if (hasSet.Contains(progId)) { this.ManagerMessage.AddMessage(LibMessageKind.Error, string.Format("行{0}的功能标识重复", curRow["ROWNO"])); } else { hasSet.Add(progId); } } }
private static DataSet SetAbnormalRpt(DataSet newDataSet, DataSet bcfDataSet) { Dictionary <int, int> dic = new Dictionary <int, int>(); DataTable table = new DataTable(); table.Columns.Add("ABNORMALPROTOTYPE", typeof(int)); table.Columns.Add("ORDERCOUNT", typeof(int)); newDataSet.Tables.Add(table); foreach (DataRow item in bcfDataSet.Tables[0].Rows) { int key = LibSysUtils.ToInt32(item["ABNORMALPROTOTYPE"]); if (dic.ContainsKey(key)) { dic[key]++; } else { dic.Add(key, 1); } } foreach (KeyValuePair <int, int> item in dic) { DataRow newDataRow = newDataSet.Tables[0].NewRow(); newDataRow["ABNORMALPROTOTYPE"] = item.Key; newDataRow["ORDERCOUNT"] = item.Value; newDataSet.Tables[0].Rows.Add(newDataRow); } return(newDataSet); }
/// <summary> /// 获取文档所在的目录Id和文档的文件夹名称(仅文档自身的文件夹名称) /// </summary> /// <param name="docId"></param> /// <param name="docDirName">文档的文件夹名称,仅文档自身的文件夹名称</param> /// <param name="maxModifyVerId">最大修订号</param> /// <returns></returns> protected string GetDirId(string docId, out string docDirName, out int maxModifyVerId, out string docType, out string docName, out bool isDocLocked) { string dirId = string.Empty; docDirName = string.Empty; maxModifyVerId = 1; docType = string.Empty; docName = string.Empty; isDocLocked = true; string sql = string.Format("select A.DIRID,A.SAVEPATH,A.DOCTYPE,A.DOCNAME,A.LOCKSTATE,(select max(DOCMODIFYID) from DMDOCMODIFYHISTORY where DOCID='{0}') as MaxDOCMODIFYID from DMDOCUMENT A where A.DOCID = '{0}'", docId); DataSet ds = this.DataAccess.ExecuteDataSet(sql); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { return(string.Empty); } DataRow row = ds.Tables[0].Rows[0]; dirId = LibSysUtils.ToString(row["DIRID"]); docDirName = LibSysUtils.ToString(row["SAVEPATH"]); maxModifyVerId = LibSysUtils.ToInt32(row["MaxDOCMODIFYID"]); docType = LibSysUtils.ToString(row["DOCTYPE"]); docName = LibSysUtils.ToString(row["DOCNAME"]); docName = docName.EndsWith(docType) ? docName.Substring(0, docName.Length - docType.Length) : docName; int lockState = LibSysUtils.ToInt32(row["LOCKSTATE"]); isDocLocked = lockState == 1; return(dirId); }
public ActionResult Bill(string progId, int funType) { this.ViewBag.ProgId = LibSysUtils.ToString(progId); this.ViewBag.FunType = funType; this.ViewBag.VclClass = string.Format("{0}Vcl", this.ViewBag.ProgId.Replace(".", string.Empty)); return(View()); }
protected override void AfterDelete() { base.AfterDelete(); if (this.isDeleteSubs) { //删除文件夹目录。sql中的表单记录操作可以回滚,磁盘上的文件目录和文档操作统一处理,失败了也不用回滚。 DataRow masterRow = this.DataSet.Tables[0].Rows[0]; if (masterRow == null) { return; } string dirId = LibSysUtils.ToString(masterRow["DIRID"]); //DirLinkAddress dirLink = new DirLinkAddress(dirId, this.DataAccess); if (dirLink.DirSavePath == string.Empty) { return; } //先定位到文档库根路径 //string path = Path.Combine(EnvProvider.Default.DocumentsPath, (LibSysUtils.ToInt32(masterRow["DIRTYPE"]) == 0 ? "" : "my"));//根据是否为私有类型在路径下增加my string path = DMCommonMethod.GetDMRootPath((DirTypeEnum)LibSysUtils.ToInt32(masterRow["DIRTYPE"])); path = Path.Combine(path, dirLink.DirSavePath); try { if (Directory.Exists(path)) { Directory.Delete(path, true);//删除目录文件夹及其子目录文件夹、文件等。 } } catch (Exception exp) { //对于删除文档目录在磁盘上的文件夹的动作,因为文件系统的删除无法回滚,不再向上抛出异常(以免触发本级事务回滚),仅记录异常信息,以便后续手动清理 DMCommonMethod.WriteLog("DeleteDirectory", string.Format("DirID:{0}\r\nPath:{1}\r\nError:{2}", dirId, path, exp.ToString())); } } }
protected override void AfterDelete() { base.AfterDelete(); DataRow masterRow = this.DataSet.Tables[0].Rows[0]; LibRolePermissionCache.Default.RemoveCacheItem(LibSysUtils.ToString(masterRow["ROLEID"])); }
/// <summary> /// 验证验证码是否正确 /// </summary> /// <param name="userId"></param> /// <param name="code"></param> /// <returns></returns> private static Result VerifyCode(string userId, string code) { Result res = new Result(); try { string sql = string.Format("SELECT VERIFYCODE FROM AXPVERIFYCODE WHERE USERID={0}", LibStringBuilder.GetQuotString(userId)); LibDataAccess access = new LibDataAccess(); string realCode = LibSysUtils.ToString(access.ExecuteScalar(sql)); if (realCode == string.Empty) { res.ReturnValue = false; res.Message = "该帐号没有对应的验证码"; return(res); } if (code != null && code.Equals(realCode)) { res.ReturnValue = true; return(res); } else { res.ReturnValue = false; res.Message = "验证码错误"; return(res); } } catch (Exception ex) { res.ReturnValue = false; res.Message = "注册失败!" + ex.Message; return(res); } }
/// <summary> /// 登录 /// </summary> /// <param name="info"></param> /// <returns></returns> public static Result Login(UserInfo info) { Result res = new Result(); try { LibDataAccess access = new LibDataAccess(); SystemService server = new SystemService(); if (APPCache.CacheDic.ContainsKey(info.CodeId)) { if (string.Equals(APPCache.CacheDic[info.CodeId], info.Code, StringComparison.CurrentCultureIgnoreCase)) { LoginInfo loginInfo = server.Login(info.UserId, info.Password, false); LibHandle handle = LibHandleCache.Default.IsExistsHandle(LibHandeleType.PC, info.UserId); if (loginInfo.PersonId == null) { res.ReturnValue = false; res.Message = "登录失败!"; } else if (handle == null) { res.ReturnValue = false; res.Message = "请重新登录!"; } else { string sql = string.Format("SELECT B.PHONENO,B.MAIL FROM AXPUSER A LEFT JOIN COMPERSON B ON B.PERSONID=A.PERSONID WHERE A.USERID={0}", LibStringBuilder.GetQuotString(info.UserId)); using (IDataReader reader = access.ExecuteDataReader(sql)) { if (reader.Read()) { //loginInfo.UserPhone = LibSysUtils.ToString(reader["PHONENO"]); loginInfo.UserEMail = LibSysUtils.ToString(reader["MAIL"]); } } loginInfo.Handle = handle.Handle; res.Info = loginInfo; res.ReturnValue = true; APPCache.RemoveAPPCache(info.CodeId); } } else { res.Message = "验证码错误!"; res.ReturnValue = false; } } else { res.Message = "验证码失效!"; res.ReturnValue = false; } } catch (Exception ex) { res.Message = ex.Message; res.ReturnValue = false; } return(res); }
private static bool DoIsExistIdEx(object dsNmOrId, Mode mode) { XMLOperation xmlOperation = new XMLOperation(SysConstManage.DSListFile); ILibXMLNodeRead noderead = xmlOperation.NodeRead("/DSList/DSInfoCollection/DSInfo"); while (!noderead.EOF) { if (mode == Mode.ByDSID) { int id = LibSysUtils.ToInt32(noderead.Attributions["DSID"].ToString()); if (id == LibSysUtils.ToInt32(dsNmOrId)) { return(true); } } else if (mode == Mode.ByDSName) { string dsName = noderead.InnerText.Trim(); if (string.Compare(dsNmOrId.ToString(), dsName, true) == 0) { return(true); } } noderead.ReadNext(); } return(false); }
public List <LibBusinessTask> InitTempTask() { List <LibBusinessTask> list = new List <LibBusinessTask>(); LibDataAccess dataAccess = new LibDataAccess(); using (IDataReader reader = dataAccess.ExecuteDataReader("select TASKID,PROGID,BUSINESSTASKID,EXECDATE,EXECTIME,EXECCONDITION,INTERNALID from AXPBUSINESSTEMPTASK", false)) { while (reader.Read()) { LibBusinessTask task = new LibBusinessTask() { TaskType = LibTaskType.TempTask, TaskId = LibSysUtils.ToString(reader["TASKID"]), ProgId = LibSysUtils.ToString(reader["PROGID"]), BusinessTaskId = LibSysUtils.ToString(reader["BUSINESSTASKID"]), ExecDate = LibSysUtils.ToInt32(reader["EXECDATE"]), ExecCondition = LibSysUtils.ToString(reader["EXECCONDITION"]), InternalId = LibSysUtils.ToString(reader["INTERNALID"]) }; task.ExecTime.Add(LibSysUtils.ToInt32(reader["EXECTIME"])); list.Add(task); } } return(list); }
protected override void AfterDelete() { base.AfterDelete(); DataRow masterRow = this.DataSet.Tables[0].Rows[0]; LibPermissionGroupCache.Default.RemoveCacheItem(LibSysUtils.ToString(masterRow["PERMISSIONGROUPID"])); }
private static DataSource DoGetDataSourceEx(object dsNmOrId, Mode mode) { DataSource datasource = null; XMLOperation xmlOperation = new XMLOperation(SysConstManage.DSListFile); ILibXMLNodeRead noderead = xmlOperation.NodeRead("/DSList/DSInfoCollection/DSInfo"); string dsname = null; string package = null; while (!noderead.EOF) { if (mode == Mode.ByDSID) { int id = LibSysUtils.ToInt32(noderead.Attributions["DSID"].ToString()); if (LibSysUtils.ToInt32(dsNmOrId) == id) { dsname = noderead.Attributions["Name"].ToString(); package = noderead.Attributions["PACKAGE"].ToString(); break; } } else if (mode == Mode.ByDSName) { dsname = noderead.Attributions["Name"].ToString(); if (string.Compare(dsname, dsNmOrId.ToString(), true) == 0) { package = noderead.Attributions["PACKAGE"].ToString().Trim(); break; } } noderead.ReadNext(); } InstanceDataSource(ref datasource, dsname, package); return(datasource); }
protected override void BeforeUpdate() { base.BeforeUpdate(); DataRow masterRow = this.DataSet.Tables[0].Rows[0]; #region 检查部门下的同一人员是否担任了重复的职务 HashSet <string> hasSet = new HashSet <string>(); foreach (DataRow curRow in this.DataSet.Tables[1].Rows) { if (curRow.RowState == DataRowState.Deleted) { continue; } string duty_PersonID = string.Format("{0}_{1}", LibSysUtils.ToString(curRow["DUTYID"]), LibSysUtils.ToString(curRow["PERSONID"])); if (hasSet.Contains(duty_PersonID)) { this.ManagerMessage.AddMessage(LibMessageKind.Error, string.Format("岗位任职行{0}的任职岗位与人员已存在。", curRow["ROWNO"])); } else { hasSet.Add(duty_PersonID); } } #endregion }
/// <summary> /// 直接创建目录 /// </summary> /// <param name="dirId"></param> /// <param name="dirName"></param> /// <returns></returns> protected bool AddDirDirectly(ref string dirId, string dirName, DirTypeEnum dirType, string parentDirId) { if (string.IsNullOrEmpty(dirName)) { return(false); } if (parentDirId == null) { parentDirId = string.Empty; } Dictionary <string, LibChangeRecord> dicChanges = new Dictionary <string, LibChangeRecord>(); Dictionary <string, object> dicChangeColumns = new Dictionary <string, object>(); LibEntryParam entryParam = new LibEntryParam(); entryParam.ParamStore.Add("ParentDirId", parentDirId); entryParam.ParamStore.Add("ParentDirType", (int)dirType); this.DataSet.Clear(); this.AddNew(entryParam); if (this.ManagerMessage.IsThrow) { return(false); } if (string.IsNullOrEmpty(dirId)) { dirId = LibSysUtils.ToString(this.DataSet.Tables[0].Rows[0]["DIRID"]); } object[] pks = new object[] { dirId }; //因对于Add的对象Save方法中会检查Add的第一条记录数据并做相关处理,因此需要模拟生成前端传递来的change数据 LibChangeRecord record = new LibChangeRecord(); foreach (DataColumn col in this.DataSet.Tables[0].Columns) { dicChangeColumns.Add(col.ColumnName, this.DataSet.Tables[0].Rows[0][col.ColumnName]);//将文档主表的第一行数据变成change数据 } dicChangeColumns["DIRID"] = dirId; dicChangeColumns["DIRNAME"] = dirName; dicChangeColumns["DIRTYPE"] = (dirType == DirTypeEnum.Public) ? 0 : 1; dicChangeColumns["PARENTDIRID"] = parentDirId; record.Add.Add(dicChangeColumns); dicChanges.Add("DMDIRECTORY", record); this.DataSet.Clear();//将通过addNew添加的数据全清空,以免和通过change数据添加的重复了。 this.Save(BillAction.AddNew, pks, dicChanges, null); if (this.ManagerMessage.IsThrow) { return(false); } else { return(true); } }
protected override void AfterDelete() { base.AfterDelete(); //清空部门任职表的缓存数据 DataRow masterRow = this.DataSet.Tables[0].Rows[0]; LibDeptDutyPersonCache.Default.RemoveCacheItem(LibSysUtils.ToString(masterRow["DEPTID"])); }
public string getSupplIer(string supplyUserId) { string supplierId = string.Empty; LibDataAccess dataAccess = new LibDataAccess(); string sql = string.Format("SELECT SUPPLIERID FROM COMPERSON WHERE PERSONID = '{0}'", supplyUserId); supplierId = LibSysUtils.ToString(dataAccess.ExecuteScalar(sql)); return(supplierId); }
protected override void AfterDelete() { base.AfterDelete(); DataRow masterRow = this.DataSet.Tables[0].Rows[0]; string progId = LibSysUtils.ToString(masterRow["PROGID"]); LibCodingRuleCache.Default.Remove(progId); LibCodingNoCache.Default.RemoveCacheByProgId(progId); }
public static string SetAPPCache(string appCode) { string codeId = LibSysUtils.ToString(Guid.NewGuid()); if (!string.IsNullOrEmpty(appCode)) { CacheDic.Add(codeId, appCode); } return(codeId); }