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 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); } } }
/// <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); }
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); }
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"]); } } }
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); }
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())); } } }
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 static decimal GetFormater(decimal value, string unitId, LibFormatType formatType = LibFormatType.Quantity) { //目前只实现数量的格式化 int retainDigits = LibSysUtils.ToInt32(LibFormatUnitCache.Default.GetFormatData(unitId)); return(decimal.Round(value, retainDigits)); }
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); }
protected override bool CheckModif(object[] pks) { DataRow masterRow = this.DataSet.Tables[0].Rows[0]; int dirType = LibSysUtils.ToInt32(masterRow["DIRTYPE"]); if (dirType == (int)DirTypeEnum.Private) { return(true);//个人目录不做控制 } return(CheckPermission(pks[0].ToString(), DMFuncPermissionEnum.Edit)); }
public bool IsExists(string pk) { string sqlById = string.Format("select count(*) from AXPRPTSEARCHFIELD where RPTSEARCHID = {0}", LibStringBuilder.GetQuotString(pk)); int num = LibSysUtils.ToInt32(DataAccess.ExecuteScalar(sqlById)); if (num > 0) { return(true); } return(false); }
/// <summary>验证数据有效性</summary> private void InvalidateValue() { if (ModelDesignProject.ExistId(LibSysUtils.ToInt32(this.txtDSID.Text.Trim()))) { ExceptionManager.ThrowError("该DSID已存在"); //return; } if (ModelDesignProject.ExistDSName(this.txtDSName.Text.Trim())) { ExceptionManager.ThrowError("该数据源名称已经存在"); } }
protected override bool CheckBrowseTo(object[] pks) { string sql = string.Format("select DIRTYPE from DMDIRECTORY where DIRID = '{0}'", pks[0]); object obj = this.DataAccess.ExecuteScalar(sql); int dirType = LibSysUtils.ToInt32(obj); if (dirType == (int)DirTypeEnum.Private) { return(true);//个人目录不做控制 } return(CheckPermission(pks[0].ToString(), DMFuncPermissionEnum.Browse)); }
protected override bool CheckDelete() { DataRow masterRow = this.DataSet.Tables[0].Rows[0]; string dirId = LibSysUtils.ToString(masterRow["DIRID"]); int dirType = LibSysUtils.ToInt32(masterRow["DIRTYPE"]); if (dirType == (int)DirTypeEnum.Private) { return(true);//个人目录不做控制 } return(CheckPermission(dirId, DMFuncPermissionEnum.Delete)); }
private static DataSet SetWorkLogRpt(DataSet newDataSet, DataSet bcfDataSet) { Dictionary <int, WorkLogRptModel> dic = new Dictionary <int, WorkLogRptModel>(); DataTable table = new DataTable(); table.Columns.Add("STARTDATE", typeof(int)); table.Columns.Add("STARTONTIMERATE", typeof(decimal)); table.Columns.Add("ENDONTIMERATE", typeof(decimal)); newDataSet.Tables.Add(table); foreach (DataRow item in bcfDataSet.Tables[0].Rows) { decimal startOnTimeCount = 0; decimal endOnTimeCount = 0; int key = LibSysUtils.ToInt32(item["STARTDATE"]); if (dic.ContainsKey(key)) { if (LibSysUtils.ToInt32(item["PLANSTARTTIME"]) > LibSysUtils.ToInt32(item["ACTSTARTTIME"])) { dic[key].StartOnTimeCount++; } if (LibSysUtils.ToInt32(item["PLANENDTIME"]) > LibSysUtils.ToInt32(item["ACTENDTIME"])) { dic[key].EndOnTimeCount++; } dic[key].TotalCount++; } else { if (LibSysUtils.ToInt32(item["PLANSTARTTIME"]) > LibSysUtils.ToInt32(item["ACTSTARTTIME"])) { startOnTimeCount++; } if (LibSysUtils.ToInt32(item["PLANENDTIME"]) > LibSysUtils.ToInt32(item["ACTENDTIME"])) { endOnTimeCount++; } dic.Add(key, new WorkLogRptModel() { StartOnTimeCount = startOnTimeCount, EndOnTimeCount = endOnTimeCount, TotalCount = 1 }); } } foreach (KeyValuePair <int, WorkLogRptModel> item in dic) { DataRow newDataRow = newDataSet.Tables[0].NewRow(); newDataRow["STARTDATE"] = item.Key; newDataRow["STARTONTIMERATE"] = item.Value.StartOnTimeCount / item.Value.TotalCount; newDataRow["ENDONTIMERATE"] = item.Value.EndOnTimeCount / item.Value.TotalCount; newDataSet.Tables[0].Rows.Add(newDataRow); } return(newDataSet); }
protected override void BeforeUpdate() { base.BeforeUpdate(); List <int> appTypeList = new List <int>(); int clientType = 0; //同一个账户下的UserApp子表中的App类型不能重复 foreach (DataRow curRow in this.DataSet.Tables[1].Rows) { switch (curRow.RowState) { case DataRowState.Added: case DataRowState.Modified: case DataRowState.Unchanged: clientType = LibSysUtils.ToInt32(curRow["CLIENTTYPE", DataRowVersion.Current]); if (appTypeList.Contains(clientType) == false) { appTypeList.Add(clientType); } else { this.ManagerMessage.AddMessage(LibMessageKind.Error, string.Format("APP明细,行号:{0},同一个账户下的UserApp子表中的App类型不能重复。", curRow["ROW_ID"])); } break; } } // 站点不能重复配置 List <string> siteIdList = new List <string>(); foreach (DataRow curRow in this.DataSet.Tables[2].Rows) { switch (curRow.RowState) { case DataRowState.Added: case DataRowState.Modified: case DataRowState.Unchanged: string siteId = curRow["SITEID", DataRowVersion.Current].ToString(); if (siteIdList.Contains(siteId) == false) { siteIdList.Add(siteId); } else { this.ManagerMessage.AddMessage(LibMessageKind.Error, string.Format("可访问站点配置,行号:{0},同一个账户下不能重复可访问站点。", curRow["ROW_ID"])); } break; } } }
public static Result GenerateCode(string userId, string phoneNo) { Result res = new Result(); try { // 生成四位数的验证码 Random r = new Random(); int i = (int)(r.NextDouble() * 10000); string code = i.ToString().PadLeft(4, '0'); // 查看是否存在该帐号对应的验证码 LibDataAccess access = new LibDataAccess(); string sql = string.Format("SELECT count(*) FROM AXPVERIFYCODE WHERE USERID = {0}", LibStringBuilder.GetQuotString(userId)); int count = LibSysUtils.ToInt32(access.ExecuteScalar(sql)); // 生成或者更新验证码 if (count == 0) { sql = string.Format("INSERT INTO AXPVERIFYCODE(USERID, VERIFYCODE, TIME) VALUES({0}, {1}, {2})", LibStringBuilder.GetQuotString(userId), LibStringBuilder.GetQuotString(code), LibDateUtils.GetCurrentDateTime()); } else if (count == 1) { sql = string.Format("UPDATE AXPVERIFYCODE SET VERIFYCODE={0}, TIME={1} WHERE USERID={2}", LibStringBuilder.GetQuotString(code), LibDateUtils.GetCurrentDateTime(), LibStringBuilder.GetQuotString(userId)); } access.ExecuteNonQuery(sql); // 发送短信 SendSMSParam sendSMSParam = new SendSMSParam(); sendSMSParam.Message = "验证码为:" + code; sendSMSParam.PhoneList.Add(phoneNo); LibSMSHelper.SendMsg(sendSMSParam); res.ReturnValue = true; res.Message = "成功!"; } catch (Exception ex) { res.ReturnValue = false; res.Message = "失败!" + ex.Message; } return(res); }
private LibBusinessTask GetBusinessTask(string taskId) { SqlBuilder sqlBuilder = new SqlBuilder("axp.ScheduleTask"); string sql = sqlBuilder.GetQuerySql(0, "A.TASKID,A.PROGID,A.BUSINESSTASKID,A.CALENDARID,A.ISJUSTWORKDAY,A.INTERVALTIME,A.EXECDATE,A.REPEATDATEMARK,A.EXECCONDITION,A.TITLE,A.MAINCONTENT,B.EXECTIME", string.Format("A.TASKID={0}", LibStringBuilder.GetQuotString(taskId)), "B.EXECTIME"); LibDataAccess dataAccess = new LibDataAccess(); LibBusinessTask task = null; using (IDataReader reader = dataAccess.ExecuteDataReader(sql)) { while (reader.Read()) { if (task == null) { task = new LibBusinessTask(); task.BusinessTaskId = LibSysUtils.ToString(reader["BUSINESSTASKID"]); task.CalendarId = LibSysUtils.ToString(reader["CALENDARID"]); task.ExecCondition = LibSysUtils.ToString(reader["ExecCondition"]); task.ExecDate = LibSysUtils.ToInt32(reader["EXECDATE"]); task.IntervalTime = LibSysUtils.ToInt32(reader["INTERVALTIME"]); task.IsJustWorkDay = LibSysUtils.ToBoolean(reader["ISJUSTWORKDAY"]); task.ProgId = LibSysUtils.ToString(reader["PROGID"]); task.Title = LibSysUtils.ToString(reader["TITLE"]); task.MainContent = LibSysUtils.ToString(reader["MAINCONTENT"]); task.RepeatDateMark = LibSysUtils.ToInt32(reader["REPEATDATEMARK"]); task.TaskId = taskId; } task.ExecTime.Add(LibSysUtils.ToInt32(reader["EXECTIME"])); } } sql = string.Format("select distinct A.TASKID,A.PERSONID,D.DEPTID,C.USERID from AXPSCHEDULETASKPERSON A " + "inner join AXPSCHEDULETASK B on B.TASKID=A.TASKID left join COMPERSON D on D.PERSONID=A.PERSONID inner join AXPUSER C on C.PERSONID=A.PERSONID " + "where B.TASKID={0}", LibStringBuilder.GetQuotString(taskId)); using (IDataReader reader = dataAccess.ExecuteDataReader(sql, false)) { while (reader.Read()) { task.Liaison.Add(new LibBusinessTaskLiaison() { PersonId = LibSysUtils.ToString(reader["PERSONID"]), DeptId = LibSysUtils.ToString(reader["DEPTID"]), UserId = LibSysUtils.ToString(reader["USERID"]) }); } } return(task); }
public bool savePurTraceData(purSupplyTrace PurSupplyTrace) { StringBuilder builder = new StringBuilder(); builder.AppendFormat(@"UPDATE PURSUPPLYTRACE SET CYCLETIME = {0}, PLANSTARTTIME = {1}, PLANENDTIME = {2}, PLANINWARETIME = {3}, PLANSENDTIME = {4}, STOCKQTY = {5}, REALSTARTTIME = {6}, REALENDTIME = {7}, REALINWARETIME = {8}, REALSENDTIME = {9}, INWAYQTY={10} WHERE PURBILLNO = '{11}' AND MATERIALID = '{12}' " , PurSupplyTrace.CycleTime, PurSupplyTrace.PlanStartTime, PurSupplyTrace.PlanEndTime, PurSupplyTrace.PlanInWareTime, PurSupplyTrace.PlanSendTime, PurSupplyTrace.StockQty, PurSupplyTrace.RealStartTime, PurSupplyTrace.RealEndTime, PurSupplyTrace.RealInWareTime, PurSupplyTrace.RealSendTime, PurSupplyTrace.InWareQty, PurSupplyTrace.PurBillNo, PurSupplyTrace.MaterialId ); int BackRow = LibSysUtils.ToInt32(this.DataAccess.ExecuteNonQuery(builder.ToString())); if (BackRow > 0) { return(true); } else { return(false); } }
/// <summary> /// 获取同步天数 /// </summary> /// <param name="supplierId"></param> /// <returns>同步天数</returns> public int getRollPlanCopyDate(string supplierId) { string sql = string.Empty; sql = string.Format("SELECT COPYDATE FROM AXPCOMPANYPARAM WHERE ORGID = {0}", LibStringBuilder.GetQuotString(supplierId)); int copyDateNumber = 0; copyDateNumber = LibSysUtils.ToInt32(this.DataAccess.ExecuteScalar(sql)); if (copyDateNumber > 0) { return(copyDateNumber); } else { return(3); } }
public static Result PictureUpload(pictureUploadModel model) { Result res = new Result(); try { //var result = ""; //将byte数组转为base64String //string base64String = "/9j/4AAQSkZJRgABAQEAkACQAAD/4QCMRXhpZgAATU0AKgAAAAgABQESAAMAAAABAAEAAAEaAAUAAAABAAAASgEbAAUAAAABAAAAUgEoAAMAAAABAAIAAIdpAAQAAAABAAAAWgAAAAAAAACQAAAAAQAAAJAAAAABAAOgAQADAAAAAQABAACgAgAEAAAAAQAAAHKgAwAEAAAAAQAAAHIAAAAA/9sAQwAfFRcbFxMfGxkbIyEfJS9OMi8rKy9fREg4TnBjdnRuY21rfIyyl3yEqYZrbZvTnam4vsjKyHiV2+rZwumyxMjA/9sAQwEhIyMvKS9bMjJbwIBtgMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDA/8AAEQgAcgByAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5+v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29/j5+v/aAAwDAQACEQMRAD8A6GiiigAooqF5scL+dAEpIHU4phmQepquSWOSc0UwJvPH939aPP8A9n9ahooAsCZT1yKeCG6HNVKASDkHFAFyioEm7N+dTAgjIpALRRRQAUUUUAFFFQzv/CPxoAbLJuOB0/nUdFFMAoopyIXPH50ANoqTES9SWPtR+6b1WgCOinPGU56j1ptABTo5Ch9vSm0UAWwQRkdKWq8L4O09DVikAUUUUAIx2qT6VUJycmp5zhQPWoKYBRRRQAdalkOxQi/jUaffX606b/WGgBlFFFAEkTZ+RuhpjDaxHpQn31+tOm/1hoAZRRRQAVajbcgPeqtS255I/GgCeiiikBBcfeA9qiqS4++PpUdMAooooAKlceYoZeo6ioqkjRh82do96AI6KmZoieRk+1N3xr91Mn3oAI12je3QdKjJyST3pXcueaSgAooooAKfD/rBTKfD/rBQBZooopAQ3A6GoasyruQiq1MAoopVG5gPWgB6KFXe34CmO5c5NOmPzbR0FMoAKKKKACpNoePKjkdRUdOiba49+KAG0U6RdrkU2gAqSAfOT6Co6sQLhM+tAElFFFIAqtKm1vY1ZprqHXBoAq06MhXBPSkZSpwaSmArHLE+ppKKKACiiigAooooAfKwZsj0plFABJwOtADkXe2KtdKZGmxffvT6QBRRRQAUUUUANdA4waruhQ89PWrVFAFOip2hU9OKYYXHTBpgR0U7Y/8AdNJsb+6fyoASiniFz2xUiwAfeOaAIVUscAVYjjCD1PrTgABgDFLSAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP/2Q=="; string base64String = model.PersonPicture; //将base64String 转为 byte数组 byte[] byteArray = Convert.FromBase64String(base64String); string saveFileName = DateTime.Now.ToFileTime().ToString() + '.' + model.FileExtension; //string saveFileName = DateTime.Now.ToFileTime().ToString() + ".jpg"; string dirPath = Path.Combine(EnvProvider.Default.RuningPath, "PersonPicture"); string path = Path.Combine(dirPath, saveFileName); //使用文件流读取byte数组中的数据 Stream saveStream = new FileStream(path, FileMode.Append); saveStream.Write(byteArray, 0, byteArray.Length); saveStream.Close(); string httpPath = "http://" + EnvProvider.Default.VisualHostName + ':' + EnvProvider.Default.CurrentPort + '/' + "PersonPicture" + '/' + saveFileName; string sql = string.Format("UPDATE COMPERSON SET HEADPORTRAIT = {0} WHERE PERSONID = {1}", LibStringBuilder.GetQuotString(httpPath), LibStringBuilder.GetQuotString(model.PrisonId)); LibDataAccess dataAccess = new LibDataAccess(); int count = -1; count = LibSysUtils.ToInt32(dataAccess.ExecuteNonQuery(sql)); if (count < 0) { res.ReturnValue = false; res.Message = "请求错误"; } else { res.ReturnValue = true; res.Info = httpPath; } } catch (Exception ex) { res.ReturnValue = false; res.Message = ex.Message; } return(res); }
public DataSet GetMyNews(string userId, string password) { SystemService server = new SystemService(); LibDataAccess access = new LibDataAccess(); string sql = string.Format("SELECT count(*) FROM AXPUSER WHERE USERID ='{0}' AND USERPASSWORD ='******'", userId, password); int count = LibSysUtils.ToInt32(access.ExecuteScalar(sql)); if (count > 0) { sql = string.Format("SELECT NEWSID ,USERID ,TITLE ,MAINCONTENT ,INFOID ,A.CREATETIME ,PERSONID ,ISREAD ,EXECTASKDATAID ,B.CREATETIME ,PROGID ,RESULTDATA FROM AXPUSERNEWS A LEFT JOIN AXAEXECTASKDATA B ON A.INFOID = B.EXECTASKDATAID WHERE A.USERID = {0} AND A.ISREAD = 0", LibStringBuilder.GetQuotString(userId)); return(access.ExecuteDataSet(sql)); } else { return(new DataSet()); } }
/// <summary> /// 检查用户账户是否存在 /// </summary> /// <param name="userId"></param> /// <returns></returns> public static bool CheckUserExist(string userId) { if (string.IsNullOrEmpty(userId)) { return(false); } try { LibDataAccess dataAccess = new LibDataAccess(); int count = LibSysUtils.ToInt32(dataAccess.ExecuteScalar(string.Format("select count(*) from AXPUSER where USERID={0} AND ISUSE=1", LibStringBuilder.GetQuotString(userId)))); return(count > 0); } catch (Exception exp) { LibCommUtils.AddOutput("CrossSiteCall", string.Format("error:{0}\r\nStacktrace:{1}", exp.Message, exp.StackTrace)); return(false); } }
private LibBusinessTask AddTask() { LibBusinessTask task = new LibBusinessTask(); DataRow masterRow = this.DataSet.Tables[0].Rows[0]; task.BusinessTaskId = LibSysUtils.ToString(masterRow["BUSINESSTASKID"]); task.CalendarId = LibSysUtils.ToString(masterRow["CALENDARID"]); task.ExecCondition = LibSysUtils.ToString(masterRow["ExecCondition"]); task.ExecDate = LibSysUtils.ToInt32(masterRow["EXECDATE"]); task.IntervalTime = LibSysUtils.ToInt32(masterRow["INTERVALTIME"]); task.IsJustWorkDay = LibSysUtils.ToBoolean(masterRow["ISJUSTWORKDAY"]); task.ProgId = LibSysUtils.ToString(masterRow["PROGID"]); task.Title = LibSysUtils.ToString(masterRow["TITLE"]); task.MainContent = LibSysUtils.ToString(masterRow["MAINCONTENT"]); task.RepeatDateMark = LibSysUtils.ToInt32(masterRow["REPEATDATEMARK"]); task.TaskId = LibSysUtils.ToString(masterRow["TASKID"]); foreach (DataRow curRow in this.DataSet.Tables[1].Rows) { if (curRow.RowState == DataRowState.Deleted) { continue; } task.ExecTime.Add(LibSysUtils.ToInt32(curRow["EXECTIME"])); } string sql = string.Format("select distinct A.TASKID,A.PERSONID,D.DEPTID,C.USERID from AXPSCHEDULETASKPERSON A " + "inner join AXPSCHEDULETASK B on B.TASKID=A.TASKID left join COMPERSON D on D.PERSONID=A.PERSONID inner join AXPUSER C on C.PERSONID=A.PERSONID " + "where B.TASKID={0}", LibStringBuilder.GetQuotString(task.TaskId)); using (IDataReader reader = this.DataAccess.ExecuteDataReader(sql, false)) { while (reader.Read()) { task.Liaison.Add(new LibBusinessTaskLiaison() { PersonId = LibSysUtils.ToString(reader["PERSONID"]), DeptId = LibSysUtils.ToString(reader["DEPTID"]), UserId = LibSysUtils.ToString(reader["USERID"]) }); } } LibBusinessTaskCache.Default.AddCacheItem(task); return(task); }
/// <summary> /// 手动排程 /// </summary> /// <returns></returns> public void funSchedule() { string sql = string.Empty; List <string> list = new List <string>(); int date = LibSysUtils.ToInt32(DateTime.Now.ToString("yyyyMMdd")); sql = "SELECT PROGID FROM AXPFUNCLIST WHERE BILLTYPE=0"; using (IDataReader reader = this.DataAccess.ExecuteDataReader(sql)) { while (reader.Read()) { list.Add(string.Format(@"UPDATE {0} SET ISVALIDITY=1 WHERE VALIDITYSTARTDATE<={1} AND (VALIDITYENDDATE>={1} OR VALIDITYENDDATE=0)", LibSqlModelCache.Default.GetSqlModel(LibSysUtils.ToString(reader["PROGID"])).Tables[0].TableName, date)); list.Add(string.Format(@"UPDATE {0} SET ISVALIDITY=0 WHERE VALIDITYSTARTDATE>{1} OR (VALIDITYENDDATE<{1} AND VALIDITYENDDATE>0)", LibSqlModelCache.Default.GetSqlModel(LibSysUtils.ToString(reader["PROGID"])).Tables[0].TableName, date)); } } this.DataAccess.ExecuteDataTables(list, this.DataSet); }
protected override void AfterUpdate() { base.AfterUpdate(); if (this.ManagerMessage.IsThrow) { return;//如果已经有错误发生则直接返回 } try { DataRow masterRow = this.DataSet.Tables[0].Rows[0]; //先定位到文档库根路径 string path = DMCommonMethod.GetDMRootPath((DirTypeEnum)LibSysUtils.ToInt32(masterRow["DIRTYPE"])); //string path = Path.Combine(EnvProvider.Default.DocumentsPath, (LibSysUtils.ToInt32(masterRow["DIRTYPE"]) == 0 ? "" : "my"));//根据是否为私有类型在路径下增加my string relativePath = string.Empty; if (masterRow.RowState == DataRowState.Added) { //添加时创建目录文件夹 DirLinkAddress dirLink = new DirLinkAddress(LibSysUtils.ToString(masterRow["DIRID"]), this.DataAccess); relativePath = dirLink.DirSavePath; path = Path.Combine(path, relativePath); Directory.CreateDirectory(path); } else { //update时检查父目录是否变化,如有变化根据将目录对应的文件夹移动到父目录文件夹下 string oldParentID = LibSysUtils.ToString(masterRow["PARENTDIRID", DataRowVersion.Original]); string currentParentID = LibSysUtils.ToString(masterRow["PARENTDIRID"]); if (oldParentID.Equals(currentParentID) == false) { DirLinkAddress dirLink = new DirLinkAddress(LibSysUtils.ToString(masterRow["DIRID"]), this.DataAccess); relativePath = dirLink.DirSavePath; string newDirPath = Path.Combine(path, relativePath); Directory.Move(_OldDirPath, newDirPath);//移动文件夹 } } } catch (Exception exp) { this.ManagerMessage.AddMessage(LibMessageKind.Error, "保存目录失败,原因:" + exp.Message); throw exp; } }
/// <summary> /// 异常报告单单据类型 删除前验证【不被异常报告单引用】 /// </summary> protected override void BeforeDelete() { base.BeforeDelete(); #region 当异常报告单单据类型删除时,确保原始的异常报告单单据类型不被异常报告单引用 DataRow masterRow = this.DataSet.Tables[0].Rows[0]; if (masterRow.HasVersion(DataRowVersion.Original)) { string typeId = LibSysUtils.ToString(masterRow["TYPEID", DataRowVersion.Original]); if (LibSysUtils.ToString(masterRow["TYPEID"]).CompareTo(typeId) != 0) { string sql = string.Format("SELECT COUNT(BILLNO) FROM COMABNORMALREPORT WHERE TYPEID={0}", LibStringBuilder.GetQuotString(typeId)); int count = LibSysUtils.ToInt32(this.DataAccess.ExecuteScalar(sql)); if (count > 0) { this.ManagerMessage.AddMessage(LibMessageKind.Error, string.Format("异常报告单单据类型{0}在异常报告单被引用,无法删除", typeId)); } } } #endregion }
public static Result SavePictureCalidateCode(string userId, string code) { Result result = new Result(); LibDataAccess dataAccess = new LibDataAccess(); string sql = string.Format("SELECT count(*) FROM AXPVERIFYCODE WHERE USERID = {0}", LibStringBuilder.GetQuotString(userId)); int count = LibSysUtils.ToInt32(dataAccess.ExecuteScalar(sql)); // 生成或者更新验证码 if (count == 0) { sql = string.Format("INSERT INTO AXPVERIFYCODE(USERID, VERIFYCODE, TIME) VALUES({0}, {1}, {2})", LibStringBuilder.GetQuotString(userId), LibStringBuilder.GetQuotString(code), LibDateUtils.GetCurrentDateTime()); } else if (count == 1) { sql = string.Format("UPDATE AXPVERIFYCODE SET VERIFYCODE={0}, TIME={1} WHERE USERID={2}", LibStringBuilder.GetQuotString(code), LibDateUtils.GetCurrentDateTime(), LibStringBuilder.GetQuotString(userId)); } dataAccess.ExecuteNonQuery(sql); return(result); }
public static Result GetCount(string userId, string handle) { Result res = new Result(); res.ReturnValue = true; string personId = "018427"; //LibHandle Handle = LibHandleCache.Default.IsExistsHandle(LibHandeleType.None, userId); //VerificationHandle(userId, handle, Handle, res); if (res.ReturnValue) { LibDataAccess access = new LibDataAccess(); try { string sql = string.Empty; //if (!string.IsNullOrEmpty(Handle.PersonId))//待优化 //{ CountModel model = new CountModel(); sql = string.Format("SELECT COUNT(*) AS TOTALNUM FROM AXPAPPROVETASK WHERE PERSONID = {0} AND AUDITSTATE = 0 and FLOWLEVEL=CURRENTLEVEL+1", LibStringBuilder.GetQuotString(personId)); model.ApprovelCount = LibSysUtils.ToInt32(access.ExecuteScalar(sql)); sql = string.Format("SELECT COUNT(*) FROM COMABNORMALREPORT A INNER JOIN COMABNORMALREPORTTYPEFLOW B ON B.TYPEID = A.TYPEID WHERE A.TRANSMITLEVEL = B.TRANSMITLEVEL AND B.PERSONID = {0} AND A.BILLNO NOT IN (select FROMBILLNO from COMABNORMALTRACE)", LibStringBuilder.GetQuotString(personId)); model.AbnormalCount = LibSysUtils.ToInt32(access.ExecuteScalar(sql)); res.Info = model; res.ReturnValue = true; //} //else //{ // res.Message = "请重新登录!"; // res.ReturnValue = false; //} } catch (Exception ex) { res.ReturnValue = false; res.Message = "失败!" + ex.Message; } } return(res); }