/// <summary>
/// 同步工作流冻结
/// 业务数据冻结同时调用
/// </summary>
/// <param name="tableName"></param>
/// <param name="rowId"></param>
/// <returns></returns>
public NFMT.Common.ResultModel SynDataFreeze(NFMT.Common.UserModel user, string tableName, int rowId)
{
Common.ResultModel result = new Common.ResultModel();
try
{
result = this.GetSourceId(tableName, rowId);
if (result.ResultStatus != 0)
return result;
int SourceId = Convert.ToInt32(result.ReturnValue);
NFMT.WorkFlow.BLL.DataSourceBLL dataSourceBll = new BLL.DataSourceBLL();
result = dataSourceBll.Get(user, SourceId);
if (result.ResultStatus != 0)
return result;
NFMT.WorkFlow.Model.DataSource dataSource = result.ReturnValue as NFMT.WorkFlow.Model.DataSource;
result = dataSourceBll.Freeze(user, dataSource);
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return result;
}
public NFMT.Common.ResultModel Create(Common.UserModel user, Common.IModel model)
{
NFMT.Common.ResultModel result = new Common.ResultModel();
try
{
WorkFlow.Model.Task task = new WorkFlow.Model.Task();
Model.Contract contract = model as Model.Contract;
Contract.TradeBorderEnum tradeBorder = (Contract.TradeBorderEnum)contract.TradeBorder;
Contract.TradeDirectionEnum tradeDirection = (TradeDirectionEnum)contract.TradeDirection;
task.TaskName = string.Format("{0}{1}合约审核", tradeBorder.ToString("F"), tradeDirection.ToString("F"));
NFMT.Data.Model.Asset asset = NFMT.Data.BasicDataProvider.Assets.FirstOrDefault(temp => temp.AssetId == contract.AssetId);
NFMT.Data.Model.MeasureUnit unit = NFMT.Data.BasicDataProvider.MeasureUnits.FirstOrDefault(temp => temp.MUId == contract.UnitId);
NFMT.Data.Model.Currency currency = NFMT.Data.BasicDataProvider.Currencies.FirstOrDefault(temp => temp.CurrencyId == contract.SettleCurrency);
task.TaskConnext = string.Format("{0} 于 {1} 提交审核。合约号：{2}，品种：{3}，签订数量：{4}{5}，升贴水：{6}{7}", user.EmpName, DateTime.Now.ToString(), contract.OutContractNo, asset.AssetName, contract.SignAmount, unit.MUName, contract.Premium.ToString("0.00"), currency.CurrencyName);
result.ReturnValue = task;
result.ResultStatus = 0;
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public virtual Common.ResultModel CreateAuthorityStr(Common.UserModel user)
{
Common.ResultModel result = new Common.ResultModel();
result.ResultStatus = 0;
result.Message = "";
result.ReturnValue = string.Empty;
return result;
}
public Common.ResultModel Create(Common.UserModel user, Common.IModel model)
{
NFMT.Common.ResultModel result = new Common.ResultModel();
try
{
WorkFlow.Model.Task task = new WorkFlow.Model.Task();
Model.PriceConfirm priceConfirm = model as Model.PriceConfirm;
task.TaskName = "价格确认单审核";
NFMT.Contract.BLL.ContractBLL contractBLL = new Contract.BLL.ContractBLL();
result = contractBLL.Get(user, priceConfirm.ContractId);
if (result.ResultStatus != 0)
return result;
//获取合约
NFMT.Contract.Model.Contract contract = result.ReturnValue as NFMT.Contract.Model.Contract;
if (contract == null)
{
result.ResultStatus = -1;
result.Message = "获取合约失败";
return result;
}
//获取币种
NFMT.Data.Model.Currency cur = NFMT.Data.BasicDataProvider.Currencies.SingleOrDefault(a => a.CurrencyId == contract.SettleCurrency);
if (cur == null)
{
result.ResultStatus = -1;
result.Message = "获取币种失败";
return result;
}
//获取单位
NFMT.Data.Model.MeasureUnit mu = NFMT.Data.BasicDataProvider.MeasureUnits.SingleOrDefault(a => a.MUId == contract.UnitId);
if (mu == null)
{
result.ResultStatus = -1;
result.Message = "获取单位失败";
return result;
}
task.TaskConnext = string.Format("{0} 于 {1} 提交审核。合约号：{2}，价格：{3}{4}/{5}", user.EmpName, DateTime.Now.ToString(), contract.OutContractNo, priceConfirm.SettlePrice, cur.CurrencyName, mu.MUName);
result.ReturnValue = task;
result.ResultStatus = 0;
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
/// <summary>
/// 购销权限
/// </summary>
/// <param name="user">当前用户</param>
/// <returns></returns>
public override Common.ResultModel CreateAuthorityStr(Common.UserModel user)
{
Common.ResultModel result = new Common.ResultModel();
if (user == null)
return result;
string str = string.Format(" and NFMT_User.dbo.TradeDirectionAuth({0},{1})=1", user.EmpId, this.AuthColumnNames[0]);
result.ResultStatus = 0;
result.ReturnValue = str;
return result;
}
public Common.ResultModel CreateAuthorityStr(Common.UserModel user)
{
Common.ResultModel result = new Common.ResultModel();
if (user == null)
{
result.ResultStatus = -1;
result.Message = "用户未登录";
}
result.ResultStatus = -1;
result.ReturnValue = string.Format(" and mt.CreatorId = {0}",user.EmpId);
return result;
}
public Common.ResultModel CreateAuthorityStr(Common.UserModel user)
{
Common.ResultModel result = new Common.ResultModel();
if (user == null)
{
result.ResultStatus = -1;
result.Message = "用户未登录";
}
int readyStatus = (int)NFMT.Common.StatusEnum.已生效;
result.ReturnValue = string.Format(" and mt.CreatorId in (select de1.EmpId from dbo.DeptEmp de1 inner join dbo.DeptEmp de2 on de1.DeptId = de2.DeptId and de2.RefStatus={1} and de2.EmpId={0} where de1.RefStatus={1} group by de1.EmpId)", user.EmpId,readyStatus);
return result;
}
public override Common.ResultModel CreateAuthorityStr(Common.UserModel user)
{
Common.ResultModel result = new Common.ResultModel();
if (user == null)
return result;
if (this.AuthColumnNames.Count == 0)
this.AuthColumnNames.Add("con.ContractId");
string str = string.Format(" and NFMT_User.dbo.ContractAuth({0},{1})=1", user.EmpId, this.AuthColumnNames[0]);
result.ResultStatus = 0;
result.ReturnValue = str;
return result;
}
public Common.ResultModel Create(Common.UserModel user, Common.IModel model)
{
NFMT.Common.ResultModel result = new Common.ResultModel();
try
{
WorkFlow.Model.Task task = new WorkFlow.Model.Task();
Model.StockIn stockIn = model as Model.StockIn;
task.TaskName = "入库登记审核";
NFMT.Data.Model.Asset asset = NFMT.Data.BasicDataProvider.Assets.SingleOrDefault(a => a.AssetId == stockIn.AssetId);
if (asset == null)
{
result.ResultStatus = -1;
result.Message = "获取品种失败";
return result;
}
NFMT.Data.Model.Brand brand = NFMT.Data.BasicDataProvider.Brands.SingleOrDefault(a => a.BrandId == stockIn.BrandId);
if (brand == null)
{
result.ResultStatus = -1;
result.Message = "获取品牌失败";
return result;
}
//获取单位
NFMT.Data.Model.MeasureUnit mu = NFMT.Data.BasicDataProvider.MeasureUnits.SingleOrDefault(a => a.MUId == stockIn.UintId);
if (mu == null)
{
result.ResultStatus = -1;
result.Message = "获取单位失败";
return result;
}
task.TaskConnext = string.Format("{0} 于 {1} 提交审核。毛重：{2}{3} {4} {5}", user.EmpName, DateTime.Now.ToString(), stockIn.GrossAmount, mu.MUName, asset.AssetName, brand.BrandName);
result.ReturnValue = task;
result.ResultStatus = 0;
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public Common.ResultModel Create(Common.UserModel user, Common.IModel model)
{
NFMT.Common.ResultModel result = new Common.ResultModel();
try
{
WorkFlow.Model.Task task = new WorkFlow.Model.Task();
Model.Interest interest = model as Model.Interest;
task.TaskName = "利息结算审核";
NFMT.Contract.BLL.ContractBLL contractBLL = new Contract.BLL.ContractBLL();
result = contractBLL.Get(user, interest.ContractId);
if (result.ResultStatus != 0)
return result;
//获取合约
NFMT.Contract.Model.Contract contract = result.ReturnValue as NFMT.Contract.Model.Contract;
if (contract == null)
{
result.ResultStatus = -1;
result.Message = "获取合约失败";
return result;
}
//获取币种
NFMT.Data.Model.Currency cur = NFMT.Data.BasicDataProvider.Currencies.SingleOrDefault(a => a.CurrencyId == interest.CurrencyId);
if (cur == null)
{
result.ResultStatus = -1;
result.Message = "获取币种失败";
return result;
}
task.TaskConnext = string.Format("{0} 于 {1} 提交审核。合约号：{2}，利息金额：{3}{4}", user.EmpName, DateTime.Now.ToString(), contract.OutContractNo,interest.InterestBala,cur.CurrencyName);
result.ReturnValue = task;
result.ResultStatus = 0;
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public static User.UserSecurity GetUserSecurity(string ticket, string accountName)
{
UserSecurity security = null;
if (Securities.ContainsKey(accountName))
{
security = Securities[accountName];
if (security != null)
{
return(security);
}
//if (security.CookieValue != ticket)
// return null;
}
Common.ResultModel result = RegisterUserSecurity(ticket, accountName);
return(result.ResultStatus == 0 ? Securities[accountName] : security);
}
public Common.ResultModel Create(Common.UserModel user, Common.IModel model)
{
NFMT.Common.ResultModel result = new Common.ResultModel();
try
{
WorkFlow.Model.Task task = new WorkFlow.Model.Task();
NFMT.Operate.Model.Apply apply = model as NFMT.Operate.Model.Apply;
BLL.PayApplyBLL payApplyBLL = new BLL.PayApplyBLL();
result = payApplyBLL.GetByApplyId(user, apply.ApplyId);
if (result.ResultStatus != 0)
{
result.ResultStatus = -1;
result.Message = "获取收款信息失败";
return result;
}
Model.PayApply payApply = result.ReturnValue as Model.PayApply;
task.TaskName = "付款申请审核";
NFMT.User.Model.Corporation corp = NFMT.User.UserProvider.Corporations.SingleOrDefault(a => a.CorpId == payApply.RecCorpId);
if (corp == null || corp.CorpId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取收款公司失败";
return result;
}
task.TaskConnext = string.Format("{0} 于 {1} 提交审核。收款公司：{2}，申请金额：{3}", user.EmpName, DateTime.Now.ToString(), corp.CorpName, payApply.ApplyBala);
result.ReturnValue = task;
result.ResultStatus = 0;
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public Common.ResultModel Create(Common.UserModel user, Common.IModel model)
{
NFMT.Common.ResultModel result = new Common.ResultModel();
try
{
WorkFlow.Model.Task task = new WorkFlow.Model.Task();
task.TaskName = "赎回申请单审核";
task.TaskConnext = string.Format("{0} 于 {1} 提交审核", user.EmpName, DateTime.Now.ToString());
result.ReturnValue = task;
result.ResultStatus = 0;
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public Common.ResultModel Create(Common.UserModel user, Common.IModel model)
{
NFMT.Common.ResultModel result = new Common.ResultModel();
try
{
WorkFlow.Model.Task task = new WorkFlow.Model.Task();
Model.DocumentOrder order = model as Model.DocumentOrder;
OrderTypeEnum orderType = (OrderTypeEnum)order.OrderType;
task.TaskName = string.Format("{0}审核",orderType.ToString("F"));
NFMT.User.Model.Corporation applyCorp = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == order.ApplyCorp);
string applyCorpName = string.Empty;
if (applyCorp != null && applyCorp.CorpId > 0)
applyCorpName = applyCorp.CorpName;
NFMT.Data.Model.MeasureUnit mu = NFMT.Data.BasicDataProvider.MeasureUnits.FirstOrDefault(temp => temp.MUId == order.UnitId);
string muName = string.Empty;
if (mu != null && mu.MUId > 0)
muName = mu.MUName;
NFMT.Data.Model.Currency currency = NFMT.Data.BasicDataProvider.Currencies.FirstOrDefault(temp => temp.CurrencyId == order.Currency);
string currencyName = string.Empty;
if (currency != null && currency.CurrencyId > 0)
currencyName = currency.CurrencyName;
task.TaskConnext = string.Format("{0} 于 {1} 提交审核。申请公司：[{2}]，客户公司：{3}，净重：{4}{5}，发票金额：{6}{7}", user.EmpName, DateTime.Now.ToString(), applyCorpName,order.BuyerCorpName,order.NetAmount.ToString(),muName,order.InvBala,currencyName);
result.ReturnValue = task;
result.ResultStatus = 0;
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public Common.ResultModel Create(Common.UserModel user, Common.IModel model)
{
NFMT.Common.ResultModel result = new Common.ResultModel();
try
{
WorkFlow.Model.Task task = new WorkFlow.Model.Task();
NFMT.Operate.Model.Apply apply = model as NFMT.Operate.Model.Apply;
task.TaskName = "发票申请审核";
NFMT.Invoice.BLL.InvoiceApplyBLL invoiceApplyBLL = new BLL.InvoiceApplyBLL();
result = invoiceApplyBLL.GetByApplyId(user, apply.ApplyId);
if (result.ResultStatus != 0)
return result;
Model.InvoiceApply invoiceApply = result.ReturnValue as Model.InvoiceApply;
if (invoiceApply == null)
{
result.ResultStatus = -1;
result.Message = "获取发票申请失败";
return result;
}
task.TaskConnext = string.Format("{0} 于 {1} 提交审核。开票总金额：{2}", user.EmpName, DateTime.Now.ToString(), invoiceApply.TotalBala);
result.ReturnValue = task;
result.ResultStatus = 0;
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
//internal static Common.UserModel GetUserModel(string accountName)
//{
// if (UserProvider.Users.ContainsKey(accountName))
// return UserProvider.Users[accountName];
// RegisterUserModel(accountName);
// return UserProvider.Users[accountName];
//}
private static Common.ResultModel RegisterUserSecurity(string ticket, string accountName)
{
Common.ResultModel result = null;
UserSecurity security = new UserSecurity();
security.CookieValue = ticket;
//Account
Model.Account account = null;
DAL.AccountDAL accountDal = new DAL.AccountDAL();
security.Account = accountDal.Find(acc => acc.AccountName == "accountName");
//Employee
Model.Employee emp = null;
DAL.EmployeeDAL empDal = new DAL.EmployeeDAL();
security.Emp = empDal.Find(e => e.EmpId == account.EmpId);
//Department
Model.Department dept = new Model.Department();
DAL.DepartmentDAL deptDal = new DAL.DepartmentDAL();
security.Dept = deptDal.Find(d => d.DeptId == emp.DeptId);
//Corporation
Model.Corporation corp = new Model.Corporation();
DAL.CorporationDAL corpDal = new DAL.CorporationDAL();
security.Corp = corpDal.Find(c => c.CorpId == dept.CorpId);
//Bloc
Model.Bloc bloc = new Model.Bloc();
DAL.BlocDAL blocDal = new DAL.BlocDAL();
if (security.Corp != null)
{
security.Bloc = blocDal.Find(b => b.BlocId == security.Corp.ParentId);
}
//Role
List <Model.Role> roles = new List <Model.Role>();
DAL.RoleDAL roleDal = new DAL.RoleDAL();
result = roleDal.Load(emp.EmpId);
if (result.ResultStatus == 0)
{
roles = result.ReturnValue as List <Model.Role>;
}
security.Roles = roles;
//Menu
List <Model.Menu> menus = new List <Model.Menu>();
DAL.MenuDAL menuDal = new DAL.MenuDAL();
result = menuDal.Load(emp.EmpId);
if (result.ResultStatus == 0)
{
menus = result.ReturnValue as List <Model.Menu>;
}
security.Menus = menus;
Common.UserModel user = security;
user.AccountId = security.Account.AccId;
user.AccountName = security.Account.AccountName;
user.EmpId = security.Emp.EmpId;
user.EmpName = security.Emp.Name;
user.CorpId = security.Corp.CorpId;
user.DeptId = security.Dept.DeptId;
lock (Securities)
{
if (!Securities.ContainsKey(accountName))
{
Securities.Add(accountName, security);
}
}
result.ResultStatus = 0;
return(result);
}
/// <summary>
/// 根据业务数据获取附件Id
/// </summary>
/// <param name="user"></param>
/// <param name="model"></param>
/// <param name="source"></param>
/// <returns></returns>
public Common.ResultModel GetAttachIds(Common.UserModel user, Common.IModel model)
{
Common.ResultModel result = new Common.ResultModel();
AttachType attachType = this.GetAttachTypeByModel(model);
if ((int)attachType == 0)
{
result.ResultStatus = -1;
result.Message = "获取附件失败，或无附件";
return result;
}
NFMT.Common.SelectModel select = this.GetAttachSelectModel(1, 200, "ca.AttachId asc", model.Id, (int)Common.StatusEnum.已生效, (int)attachType);
select.ColumnName = "ca.AttachId";
return attachDAL.Load(user, select);
}
public Common.ResultModel GetEmailInfo(Common.UserModel user)
{
Common.ResultModel result = new Common.ResultModel();
StringBuilder sb = new StringBuilder();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
switch (m_finType)
{
case FinType.质押:
sb.Clear();
DAL.PledgeApplyDAL pledgeApplyDAL = new DAL.PledgeApplyDAL();
result = pledgeApplyDAL.Get(user, m_id);
if (result.ResultStatus != 0)
return result;
Model.PledgeApply pledgeApply = result.ReturnValue as Model.PledgeApply;
if (pledgeApply == null)
{
result.ResultStatus = -1;
result.Message = "获取质押申请单失败";
return result;
}
NFMT.Data.Model.Bank bank = NFMT.Data.BasicDataProvider.Banks.SingleOrDefault(a => a.BankId == pledgeApply.FinancingBankId);
sb.Append(GetBanInfo(bank));
DAL.PledgeApplyCashDetailDAL pledgeApplyCashDetailDAL = new DAL.PledgeApplyCashDetailDAL();
result = pledgeApplyCashDetailDAL.LoadByPledgeApplyId(user, m_id);
if (result.ResultStatus != 0)
return result;
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
foreach (System.Data.DataRow dr in dt.Rows)
{
sb.Append("<span>");
sb.AppendFormat("We short {0} lots Copper at price USD{1}/MT, prompt date: {2} under contract {3};", dr["Hands"], dr["Price"], Convert.ToDateTime(dr["ExpiringDate"]).ToString("MMMM dd, yyyy", new CultureInfo("en-us")), dr["StockContractNo"]);
sb.Append("</span>");
sb.Append("<br>");
}
break;
case FinType.赎回:
sb.Clear();
DAL.RepoApplyDAL repoApplyDAL = new DAL.RepoApplyDAL();
result = repoApplyDAL.GetByPledgeApplyId(user, m_id);
if (result.ResultStatus != 0)
return result;
int bankId = (int)result.ReturnValue;
bank = NFMT.Data.BasicDataProvider.Banks.SingleOrDefault(a => a.BankId == bankId);
sb.Append(GetBanInfo(bank));
DAL.RepoApplyDetailDAL repoApplyDetailDAL = new DAL.RepoApplyDetailDAL();
result = repoApplyDetailDAL.LoadByRepoApplyId(user, m_id);
if (result.ResultStatus != 0)
return result;
dt = result.ReturnValue as System.Data.DataTable;
foreach (System.Data.DataRow dr in dt.Rows)
{
sb.Append("<span>");
sb.AppendFormat("We long {0} lots Copper at price USD{1}/MT, prompt date: {2} under contract {3};", dr["Hands"], dr["Price"], Convert.ToDateTime(dr["ExpiringDate"]).ToString("MMMM dd, yyyy", new CultureInfo("en-us")), dr["StockContractNo"]);
sb.Append("</span>");
sb.Append("<br>");
}
break;
default:
break;
}
if (result.ResultStatus == 0)
{
scope.Complete();
result.ReturnValue = sb.ToString();
}
}
}
catch(Exception e)
{
result.ResultStatus = -1;
result.Message = e.Message;
result.ReturnValue = sb.Clear();
}
return result;
}
private static void RegisterUserModel(string ticket, string accountName)
{
Common.ResultModel result = null;
Common.UserModel user = new Common.UserModel();
//cookie value
user.CookieValue = ticket;
//Account
Model.Account account = null;
DAL.AccountDAL accountDal = new DAL.AccountDAL();
result = accountDal.Get(Common.DefaultValue.SysUser, accountName);
if (result.ResultStatus == 0)
{
account = result.ReturnValue as Model.Account;
}
user.AccountId = account.AccId;
user.AccountName = account.AccountName;
//Employee
Model.Employee emp = null;
DAL.EmployeeDAL empDal = new DAL.EmployeeDAL();
result = empDal.Get(Common.DefaultValue.SysUser, account.EmpId);
if (result.ResultStatus == 0)
{
emp = result.ReturnValue as Model.Employee;
}
user.EmpId = emp.EmpId;
////Department
//List<Model.Department> depts = new List<Model.Department>();
//DAL.DepartmentDAL deptDal = new DAL.DepartmentDAL();
//result = deptDal.Load(Common.DefaultValue.SysUser, emp.EmpId);
//if (result.ResultStatus == 0)
// depts = result.ReturnValue as List<Model.Department>;
//foreach(Model.Department dept in depts)
//{
// user.DeptIds.Add(dept.DeptId);
//}
////Corporation
//List<Model.Corporation> corps = new List<Model.Corporation>();
//DAL.CorporationDAL corpDal = new DAL.CorporationDAL();
//result = corpDal.Load(Common.DefaultValue.SysUser, emp.EmpId);
//if (result.ResultStatus == 0)
// corps = result.ReturnValue as List<Model.Corporation>;
//foreach (Model.Corporation corp in corps)
//{
// user.CorpIds.Add(corp.CorpId);
//}
////Bloc
//Model.Bloc bloc = new Model.Bloc();
//DAL.BlocDAL blocDal = new DAL.BlocDAL();
//result = blocDal.Get(Common.DefaultValue.SysUser, emp.BlocId);
//if (result.ResultStatus == 0)
// bloc = result.ReturnValue as Model.Bloc;
//user.BlocId = bloc.BlocId;
////Role
//List<Model.Role> roles = new List<Model.Role>();
//DAL.RoleDAL roleDal = new DAL.RoleDAL();
//result = roleDal.Load(Common.DefaultValue.SysUser, emp.EmpId);
//if (result.ResultStatus == 0)
// roles = result.ReturnValue as List<Model.Role>;
////user.Roles = roles;
////Menu
//List<Model.Menu> menus = new List<Model.Menu>();
//DAL.MenuDAL menuDal = new DAL.MenuDAL();
//result = menuDal.Load(Common.DefaultValue.SysUser, emp.EmpId);
//if (result.ResultStatus == 0)
// menus = result.ReturnValue as List<Model.Menu>;
////user.Menus = menus;
////AuthOptionDetailEmpRef
//List<Model.AuthOptionDetailEmpRef> refs = new List<Model.AuthOptionDetailEmpRef>();
//DAL.AuthOptionDetailEmpRefDal refDal = new DAL.AuthOptionDetailEmpRefDal();
//result = refDal.Load(Common.DefaultValue.SysUser, emp.EmpId);
//if (result.ResultStatus == 0)
// refs = result.ReturnValue as List<Model.AuthOptionDetailEmpRef>;
////security.Refs = refs;
lock (Users)
{
if (!Users.ContainsKey(accountName))
{
Users.Add(accountName, user);
}
}
}
/// <summary>
/// 获取数据源主键值
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="rowId">key值</param>
/// <returns></returns>
private NFMT.Common.ResultModel GetSourceId(string tableName, int rowId)
{
Common.ResultModel result = new Common.ResultModel();
try
{
List<SqlParameter> paras = new List<SqlParameter>();
SqlParameter para = new SqlParameter("@tableName", tableName);
paras.Add(para);
para = new SqlParameter("@rowId", rowId);
paras.Add(para);
string cmdText = "select SourceId from dbo.DataSource where TableName=@tableName and RowId=@rowId and DataStatus in (2,4)";
object obj = NFMT.DBUtility.SqlHelper.ExecuteScalar(NFMT.DBUtility.SqlHelper.ConnectionStringNFMT, CommandType.Text, cmdText, paras.ToArray());
int count;
if (obj == null)
{
result.Message = "查询出错";
return result;
}
if (int.TryParse(obj.ToString(), out count))
{
result.ResultStatus = 0;
result.ReturnValue = obj;
result.Message = "查询成功";
}
else
{
result.Message = "查询出错";
return result;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return result;
}
