/// <summary>
/// 删除操作(支持多表)
/// </summary>
/// <param name="tables">表名集合(字符串形式)</param>
/// <param name="delkeys">对应主键集合(字符串形式)</param>
/// <param name="swhere">主键值集合(字符串形式)</param>
/// <returns>CommandResult对象</returns>
public CommandResult DeleteObject(string tables, string delkeys, string swhere)
{
CommandResult result = new CommandResult();
try
{
var parameters = new[] {
new SqlParameter("@tables", tables),
new SqlParameter("@Delkeys", delkeys),
new SqlParameter("@swhere", swhere)
};
List <ProcResult> listResult = DataProvider.LoadData <ProcResult>("usp_DeleteObject", parameters);
if (listResult.Count > 0)
{
result.IntResult = listResult[0].ResultID;
result.Message = listResult[0].ErrorMsg;
}
else
{
result.IntResult = 0;
result.Message = "操作失败，请重试！";
}
result.Result = result.IntResult == 1;
}
catch (ApplicationException ex)
{
result.Result = false;
result.Message = ex.Message;
}
return(result);
}
public CommandResult UpdateRoleMedules(string roleID, string sSourceIDs)
{
CommandResult result = new CommandResult()
{
Result = false, Message = "更新失败。"
};
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@RoleId", roleID),
new SqlParameter("@Reources", sSourceIDs),
new SqlParameter("@AddBy", Account.User.UserName)
};
List <ProcResult> listResult = DataProvider.LoadData <ProcResult>("usp_AddPermissionToRole", parameters);
// int iRow = DataProvider.ExecuteNonQuery("usp_AddPermissionToRole", parameters);
if ((listResult != null) && (listResult.Count > 0))
{
if (listResult[0].ResultID == 1)
{
result.Result = true;
result.Message = "更新成功。";
return(result);
}
}
return(result);
}
public List <EAP_ErrorMsg> GetErrorMsgConfig()
{
// string pp = searchID.ToUpper();
string strsql = string.Format(" select * from EAP_ErrorMsg ");
List <EAP_ErrorMsg> _errormsgls = DataProvider.LoadData <EAP_ErrorMsg>(strsql);
return(_errormsgls);
}
public NavigatorMeta GetNavigator(int appId)
{
var nm = new NavigatorMeta();
string sql = string.Format("exec [usp_GetNavigateMeta] {0}, {1}", appId, Account.User.UserID);
DataSet ds = DataProvider.ExecuteDataSet(sql);
nm.Nodes.AddRange(DataProvider.LoadData <EAP_Navigator_Node>(ds.Tables[0]));
nm.Asso.AddRange(DataProvider.LoadData <EAP_Navigator_Asso>(ds.Tables[1]));
return(nm);
}
public List <WMS_DEPARTMENT> GetDepSecList()
{
string sSql = string.Format("SELECT * FROM WMS_DEPARTMENT");
List <WMS_DEPARTMENT> lst = DataProvider.LoadData <WMS_DEPARTMENT>(sSql);
if (lst != null)
{
return(lst);
}
return(null);
}
//查询所有EAP_Org
public EAP_User GetOrgList()
{
EAP_User user = new EAP_User();
string sSql = string.Format("SELECT * FROM EAP_Org");
List <EAP_Org> _List = DataProvider.LoadData <EAP_Org>(sSql);
if (_List != null)
{
user.OrgList = _List;
}
return(user);
}
public SearchMeta GetSearchMeta(string searchID)
{
string pp = searchID.ToUpper();
string strsql = string.Format(" select * from EAP_Search where upper(searchId)='{0}' and FlagDelete=0", pp);
SearchMeta result = DataProvider.GetEntity <SearchMeta>(strsql);
if (result != null)
{
strsql = string.Format(" select * from EAP_SearchField where upper(searchId)='{0}' and FlagDelete=0", pp);
result.Add(DataProvider.LoadData <SearchField>(strsql));
}
return(result);
}
/// <summary>
/// 获取控制的按钮权限
/// </summary>
/// <param name="Controller"></param>
/// <returns></returns>
public TJsonList <EAP_Resource> GetMenuOperate(string Controller)
{
//string sql = string.Format(" exec [usp_GetResourceByUser] {0},{1} ", 0, Account.User.UserID);
//lxt 20101102 改为传参数的方式 AppID int,UserID
// object o = 0;
var parameters = new[] {
new SqlParameter("@UserID", Account.User.UserID),
new SqlParameter("@Pageid", Controller),
};
//var listResult = DataProvider.LoadData<T>("usp_GetResourceByUser", parameters);
var resource = new TJsonList <EAP_Resource>(DataProvider.LoadData <EAP_Resource>("usp_GetOpResourceByUser2", parameters));
return(resource);
}
public TJsonList <EAP_Resource> GetAllResource(int parent_id, int IsUser, int loginUserID)
{
//string sql = string.Format(" exec usp_GetAllResource {0}", parent_id);
//var resource = new TJsonList<EAP_Resource>(DataProvider.LoadData<EAP_Resource>(sql));
var parameters = new[] {
new SqlParameter("@AppID", parent_id),
new SqlParameter("@isuser", IsUser),
new SqlParameter("@LoginUserID", loginUserID),
};
//var listResult = DataProvider.LoadData<T>("usp_GetResourceByUser", parameters);
var resource = new TJsonList <EAP_Resource>(DataProvider.LoadData <EAP_Resource>("usp_GetAllResource", parameters));
return(resource);
}
public LookupData GetAllookupID()
{
string sSQL = @"select distinct lookupid as K from app_lookup
where flagdelete=0
order by lookupid";
LookupData result = new LookupData()
{
LookupID = "AllLookupID"
};
var _Items = DataProvider.LoadData <LookupDataItem>(sSQL);
result.Items.AddRange(_Items);
return(result);
}
public TJsonList <EAP_Resource> GetMyMenu(int appid = 0, int PResID = 0)
{
//string sql = string.Format(" exec [usp_GetResourceByUser] {0},{1} ", 0, Account.User.UserID);
//lxt 20101102 改为传参数的方式 AppID int,UserID
// object o = 0;
var parameters = new[] {
new SqlParameter("@AppID", appid),
new SqlParameter("@UserID", Account.User.UserID),
new SqlParameter("@ResID", PResID),
};
//var listResult = DataProvider.LoadData<T>("usp_GetResourceByUser", parameters);
var resource = new TJsonList <EAP_Resource>(DataProvider.LoadData <EAP_Resource>("usp_GetResourceByUser2", parameters));
return(resource);
}
public WMS_ACCOUNTSET SetCurrAccountSet(WMS_ACCOUNTSET item)
{
var parameters = new[] {
new SqlParameter("@ID", item.ID),
new SqlParameter("@ORGID", item.ORGID),
new SqlParameter("@OpUser", login.User.UserName)
};
List <WMS_ACCOUNTSET> listResult = DataProvider.LoadData <WMS_ACCOUNTSET>("usp_SetCurrAccountSet", parameters);
if (listResult.Count > 0)
{
return(listResult[0]);
}
item.ResultID = -1;
return(item);
}
public CommandResult ExportExcelAccountSet(string AccountYear, int Orgid)
{
// int CostSourceType = -1; // 0：订单1：退货单2：费用3:收货调整4、专柜销售
CommandResult _result = new CommandResult();
string sf = "AccountYear";
string sql = string.Format("select * from uv_kct_accountest where {0}={1} ", sf, AccountYear);
List <KCT_ACCOUNTSET> _contents = DataProvider.LoadData <KCT_ACCOUNTSET>(sql);
if (_contents.Count == 0)
{
_result.Result = false;
_result.Message = "无数据";
return(_result);
}
StringBuilder title = new StringBuilder();
string fileName = AccountYear + "_" + Guid.NewGuid().ToString();
string _localPath = string.Format(@HostingEnvironment.ApplicationPhysicalPath + "data/{0}.xls", fileName);
FileStream fs = new FileStream(_localPath, FileMode.OpenOrCreate);
//FileStream fs1 = File.Open(file, FileMode.Open, FileAccess.Read);
StreamWriter sw = new StreamWriter(new BufferedStream(fs), System.Text.Encoding.Default);
try
{
title.AppendLine("帐套时间" + "\t" + "是否使用" + "\t" +
"备注"
);
foreach (KCT_ACCOUNTSET item in _contents)
{
title.AppendLine(item.ACCOUNTYEAR + "\t" + " " + item.ISCURRACCOUNT_G + "\t" + " " + item.REMARK);
}
sw.Write(title.ToString());
}
finally
{
sw.Close();
fs.Close();
fs = null;
}
_result.IntResult = 1;
_result.Result = true;
_result.Message = fileName;
return(_result);
}
/// <summary>
///
/// </summary>
/// <param name="sUserName"></param>
/// <param name="nametype">0:用户名登录 1：caid登录</param>
/// <returns></returns>
public EAP_User GetUserByUserName(string sUserName, int nametype = 0)
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@UserName", sUserName),
new SqlParameter("@nametype", nametype)
};
EAP_User user = DataProvider.GetEntity <EAP_User>("usp_GetUserByUserName2", parameters);
if (user != null)
{
string sSql = string.Format("SELECT * FROM uv_UserRole WHERE UserID='{0}'", user.ID);
List <EAP_Role> _List = DataProvider.LoadData <EAP_Role>(sSql);
user.Roles.Clear();
user.Roles.AddRange(_List);
}
return(user);
}
public LookupData GetLookup(LookupCriteria criteria)
{
string sSQL = ""; //= criteria.SQL;
if (!string.IsNullOrEmpty(criteria.LookupID))
{
sSQL = string.Format("SELECT Code AS K,Value AS V,Par1 as P1,Par2 as P2 FROM APP_LookUp WHERE LookupID='{0}' and flagDelete=0", criteria.LookupID);
sSQL += criteria.SQL;
sSQL += " order by [SORTBY]";
}
LookupData result = new LookupData()
{
LookupID = string.IsNullOrEmpty(criteria.LookupID) ? string.Empty : criteria.LookupID
};
List <LookupDataItem> _Items = DataProvider.LoadData <LookupDataItem>(sSQL);
result.Items.AddRange(_Items);
return(result);
}
public TJsonList <EAP_Role> GetAllRoles()
{
string strSQL = "select * from EAP_Role";
return(new TJsonList <EAP_Role>(DataProvider.LoadData <EAP_Role>(strSQL)));
}
public TJsonList <EAP_User> GetAllUsers()
{
string strSQL = "select * from EAP_User";
return(new TJsonList <EAP_User>(DataProvider.LoadData <EAP_User>(strSQL)));
}
private List <string> GetPermissionByRole(int roleID)
{
string sSql = string.Format("SELECT * FROM uv_RoleModule WHERE RoleID='{0}'", roleID);
return(DataProvider.LoadData <string>(sSql));
}
public LoginInfo Login(string sUserName, string sPassword, string clientIP, string clientName,
int port, string ukeyid = "000000", int nametype = 0)
{
string sLoginMessage = "";
LoginStatus ls = LoginStatus.Failed;
if (nametype == 0)
{
if (string.IsNullOrEmpty(sUserName))
{
sLoginMessage = "登录失败，用户名输入为空。";
}
if (string.IsNullOrEmpty(sPassword))
{
sLoginMessage = "登录失败，密码输入为空。";
}
}
else if (nametype == 1)
{
if (string.IsNullOrEmpty(ukeyid))
{
sLoginMessage = "登录失败，用户iD为空。";
}
}
EAP_User user = null;
if (nametype == 1)
{
user = GetUserByUserName(ukeyid, 1);
}
else
{
user = GetUserByUserName(sUserName);
}
if (null == user)
{
sLoginMessage = "登录失败，用户不存在。";
}
else if ((nametype == 0) && (sPassword != DESEncrypt.Decrypt(user.Password)))
{
sLoginMessage = "登录失败，密码不正确。";
}
else if (user.IsLock)
{
sLoginMessage = "该用户名已经已经停止使用。";
}
else
{
//加上检验是否进行ukey验证的代码
bool blok = true;
if (user.isUseKey_G >= 1)
{
if (string.IsNullOrEmpty(ukeyid))
{
sLoginMessage = "没有检测到UKey，请重试！";
blok = false;
}
else if (ukeyid != "000000") //当传入000000时，表示是后台调用，不需要校验
{
if (user.isUseKey_G == 1) //一个组织可以使用多个ukey，不分用户；
{
string sSql = string.Format("select ID from EAP_OrgUKey where orgid={0} and ukeyid='{1}'", user.OrgId, ukeyid);
List <int> _ukeyls = DataProvider.LoadData <int>(sSql);
if ((_ukeyls == null) || (_ukeyls.Count == 0))
{
sLoginMessage = "UKey认证失败！";
blok = false;
}
}
else if (user.isUseKey_G == 2) //一个用户一个ukey
{
if (string.Compare(user.BarCode, ukeyid, true) != 0)
{
sLoginMessage = "UKey认证失败！";
blok = false;
}
}
}
}
if (blok)
{
sLoginMessage = "登录成功。";
ls = LoginStatus.Successed;
}
}
#region get client pc info
string serverIP, serverName;
DateTime myNow = DateTime.Now;
serverName = Dns.GetHostEntry("localhost").HostName;
//System.Net.Dns.GetHostName();
System.Net.IPAddress[] addressList = Dns.GetHostEntry(serverName).AddressList;
if (addressList.Length > 0)
{
int _k = addressList.Length - 1;
serverIP = addressList[_k].ToString();
}
else
{
serverIP = addressList[0].ToString();
}
serverIP = "1";
#endregion
LoginInfo login = new LoginInfo()
{
//ClientIP = clientIP,
ClientName = string.IsNullOrEmpty(clientName) ? "No get." : clientName,
//ServerIP = string.IsNullOrEmpty(serverIP) ? "No get." : serverIP,
ServerName = string.IsNullOrEmpty(serverName) ? "No get." : serverName,
LoginPort = port,
Status = ls,
Message = string.IsNullOrEmpty(sLoginMessage) ? "No Message." : sLoginMessage,
User = user,
};
//user.Roles.ForEach(e =>
//{
// List<String> _List = this.GetPermissionByRole(e.ID);
// _List.ForEach(c =>
// {
// if (!login.Permission.Contains(c))
// {
// login.Permission.Add(c);
// }
// });
//});
SaveLoginInfo(login);
return(login);
}
