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);
}
