using System;
using System.Data;
using System.Data.SqlClient;
![](/Images/OutliningIndicators/None.gif)
using SEM.DataEntity;
using COM.Makinfo.DataAccess;
namespace SEM.DataAccess.SysManage.RightManage
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// DASysUser 的摘要说明。
/// </summary>
public class DASysUser:DBAccess
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
private DataTable dataSysUser;
![](/Images/OutliningIndicators/InBlock.gif)
public DASysUser()
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
read#region read
public DataTable ReadAllData(string strIsUsed,string strusername,string strusercode,string strareacode)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.dataSysUser = OsdSysUser.NewDataTable();
![](/Images/OutliningIndicators/InBlock.gif)
//Generate where condition string.
string strWhereCo = "";
if(null != strIsUsed && strIsUsed != "")
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
strWhereCo += " and UserIsUse = '" + strIsUsed +"'";
}
![](/Images/OutliningIndicators/InBlock.gif)
if(null != strusername && strusername != "")
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
strWhereCo += " and UserName like '%" + strusername +"%'";
}
![](/Images/OutliningIndicators/InBlock.gif)
if(null != strusercode && strusercode != "")
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
strWhereCo += " and UserCode like '%" + strusercode.ToLower() +"%'";
}
![](/Images/OutliningIndicators/InBlock.gif)
if(null != strareacode && strareacode != "")
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
strWhereCo += " and AreaCode = '" + strareacode +"'";
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
string sql = " SELECT * from SysUser ";
![](/Images/OutliningIndicators/InBlock.gif)
if(strWhereCo != "")
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
strWhereCo = strWhereCo.Substring(4);
sql = sql + " Where " + strWhereCo;
}
![](/Images/OutliningIndicators/InBlock.gif)
this.InitDataSetTableBySQL(ref dataSysUser,sql);
![](/Images/OutliningIndicators/InBlock.gif)
return dataSysUser;
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 通过部门编码获取所有的用户,注意结构 必须是,aa,aaa,这种数据结构才行,否则数据会出错。
/// </summary>
/// <param name="depcode"></param>
/// <returns></returns>
//由于数据库设计的改变,这个方法有所改变,现在变成了从SysUserPost取数
public DataTable GetAllUserByDepCode(string depcode)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.dataSysUser = OsdSysUser.NewDataTable();
![](/Images/OutliningIndicators/InBlock.gif)
string sql = " SELECT * from SysUser where usercode in (select distinct usercode from SysUserDept where Depguid = '" + depcode +"')";
![](/Images/OutliningIndicators/InBlock.gif)
this.InitDataSetTableBySQL(ref dataSysUser,sql);
![](/Images/OutliningIndicators/InBlock.gif)
return dataSysUser;
}
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 读取人口职位关联表中的数据。
/// </summary>
/// <param name="postcode"></param>
/// <param name="deptcode"></param>
/// <returns></returns>
public DataTable ReadDataByUserPost(string strAreaCode,string strDepGuid,string strPostGuid)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.dataSysUser = OsdSysUser.NewDataTable();
![](/Images/OutliningIndicators/InBlock.gif)
string sql = " SELECT * from SysUser where usercode in "+
"(select distinct usercode from SysUserPost "+
" where areaCode='"+ strAreaCode+"' and DepGuid = '" + strDepGuid +"' and postGuid='" + strPostGuid + "')";
![](/Images/OutliningIndicators/InBlock.gif)
this.InitDataSetTableBySQL(ref dataSysUser,sql);
![](/Images/OutliningIndicators/InBlock.gif)
return dataSysUser;
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 读取人口角色关联表中的数据。
/// </summary>
/// <param name="strAreaCode"></param>
/// <param name="strRoleGuid"></param>
/// <returns></returns>
public DataTable ReadDataByUserRole(string strAreaCode,string strRoleGuid)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.dataSysUser = OsdSysUser.NewDataTable();
![](/Images/OutliningIndicators/InBlock.gif)
string sql = " SELECT * from SysUser where usercode in "+
"(select distinct usercode from SysUserRole "+
" where areaCode='"+ strAreaCode+"' and RoleGuid = '" + strRoleGuid + "')";
![](/Images/OutliningIndicators/InBlock.gif)
this.InitDataSetTableBySQL(ref dataSysUser,sql);
![](/Images/OutliningIndicators/InBlock.gif)
return dataSysUser;
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///
/// </summary>
/// <param name="aryIDs"></param>
/// <returns></returns>
public DataTable ReadDataByIDs(string[] aryIDs)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.dataSysUser = OsdSysUser.NewDataTable();
![](/Images/OutliningIndicators/InBlock.gif)
//Generate where condition string.
string strWhereCo = "";
foreach(string strValue in aryIDs)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
strWhereCo += " or UserCode = '" + strValue.ToLower() +"'";
}
strWhereCo = strWhereCo.Substring(4);
string sql = " SELECT * from SysUser "+
" Where " + strWhereCo;
this.InitDataSetTableBySQL(ref dataSysUser,sql);
![](/Images/OutliningIndicators/InBlock.gif)
return dataSysUser;
![](/Images/OutliningIndicators/InBlock.gif)
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 根据GUID(数组)查询人员信息(Daizh)
/// </summary>
/// <param name="aryGUIDs"></param>
/// <returns></returns>
public DataTable ReadDataByGUIDs(string[] aryGUIDs)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.dataSysUser = OsdSysUser.NewDataTable();
![](/Images/OutliningIndicators/InBlock.gif)
//Generate where condition string.
string strWhereCo = "";
foreach(string strValue in aryGUIDs)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
strWhereCo += " or UserGuid = '" + strValue.ToLower() +"'";
}
strWhereCo = strWhereCo.Substring(4);
string sql = " SELECT * from SysUser "+
" Where " + strWhereCo;
this.InitDataSetTableBySQL(ref dataSysUser,sql);
![](/Images/OutliningIndicators/InBlock.gif)
return dataSysUser;
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 根据GUID查询人员信息(Daizh)
/// </summary>
/// <param name="aryIDs"></param>
/// <returns></returns>
public DataTable ReadDataByGuid(string strGuid)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.dataSysUser = OsdSysUser.NewDataTable();
string sql = "SELECT * from SysUser Where UserGuid = '"+ strGuid + "'";
this.InitDataSetTableBySQL(ref dataSysUser,sql);
return dataSysUser;
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 根据Code查询人员信息(Daizh)
/// </summary>
/// <param name="aryIDs"></param>
/// <returns></returns>
public DataTable ReadUserNameByCode(string strCode)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.dataSysUser = OsdSysUser.NewDataTable();
string strSQLCommand = "SELECT * FROM SysUser Where UserCode = '" + strCode + "'";
this.InitDataSetTableBySQL(ref dataSysUser,strSQLCommand);
return dataSysUser;
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 得取地区数组和部门数组的所有用户 (Fenglx)
/// </summary>
/// <param name="strDept">部门数组</param>
/// <param name="strDept">部门数组</param>
/// <returns>用户</returns>
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
public DataTable ReadDataArrayUserCode(string[] strArea,string[] strDept)
{
this.dataSysUser = OsdSysUser.NewDataTable();
![](/Images/OutliningIndicators/InBlock.gif)
string strAreaCode = "",strDeptCode = "";
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
for (int i=0 ; i < strArea.Length ; i++)
{
strAreaCode += ",'" + strArea[i] + "'";
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
for (int i=0 ; i < strDept.Length ; i++)
{
strDeptCode += ",'" + strDept[i] + "'";
}
![](/Images/OutliningIndicators/InBlock.gif)
strAreaCode = strAreaCode.Substring(1);
strDeptCode = strDeptCode.Substring(1);
// string sql = " SELECT DISTINCT SysUser.UserName, SysUser.UserGuid" +
// " FROM SysUserDept INNER JOIN SysUser ON SysUserDept.AreaCode = SysUser.AreaCode AND SysUserDept.UserCode = SysUser.UserCode" +
// " WHERE SysUserDept.AreaCode IN (" + strAreaCode + ") AND SysUserDept.DepGuid IN (" + strDeptCode + ")";
string sql = " SELECT DISTINCT SysUser.UserName, SysUser.UserGuid" +
" FROM SysUserDept INNER JOIN SysUser ON SysUserDept.UserCode = SysUser.UserCode" +
" WHERE SysUserDept.AreaCode IN (" + strAreaCode + ") AND SysUserDept.DepGuid IN (" + strDeptCode + ")";
this.InitDataSetTableBySQL(ref dataSysUser,sql);
![](/Images/OutliningIndicators/InBlock.gif)
return dataSysUser;
}
![](/Images/OutliningIndicators/InBlock.gif)
#endregion read
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
create#region create
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// Create new income type info.
/// </summary>
/// <param name="defineData"></param>
public void Create(DataTable dataSysUser)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
IDbCommand[] insert = this.GetInsertCommand(dataSysUser);
//Excute command list.
this.ExcuteCmdList(insert);
}
#endregion create
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
update#region update
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// Create income type info.
/// </summary>
/// <param name="dataSysUser"></param>
public void Update(DataTable dataSysUser)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string[] strUpdateColumns = OsdSysUser.Columns;
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
string[] strPKColumns =
{OsdSysUser.Col_UserGuid};
IDbCommand[] update = this.GetUpdateCommand(dataSysUser,OsdSysUser.Columns,strPKColumns);
![](/Images/OutliningIndicators/InBlock.gif)
//Excute command list.
this.ExcuteCmdList(update);
}
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 修改密码
/// </summary>
/// <param name="dataSysUser"></param>
public void UpdatePass(DataTable dataSysUser)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
string[] strUpdateColumns =
{OsdSysUser.Col_UserCode,OsdSysUser.Col_UserPass};
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
string[] strPKColumns =
{OsdSysUser.Col_UserCode};
IDbCommand[] update = this.GetUpdateCommand(dataSysUser,strUpdateColumns,strPKColumns);
![](/Images/OutliningIndicators/InBlock.gif)
//Excute command list.
this.ExcuteCmdList(update);
}
#endregion update
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
delete#region delete
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
///
/// </summary>
/// <param name="aryIDs"></param>
public void DeleteDataByIDs(string[] aryIDs)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
IDbCommand delete = InstanceComm;
//Generate where condition string.
string strWhereCo = "";
foreach(string strValue in aryIDs)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
strWhereCo += " or UserCode ='" + strValue.ToLower() +"' ";
}
strWhereCo = strWhereCo.Substring(4);
if(strWhereCo == "")
return;
![](/Images/OutliningIndicators/InBlock.gif)
delete.CommandText =
" update SysUser set UserIsUse ='F' "+
" Where " + strWhereCo;
//Excute command list.
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
this.ExcuteCmdList(new IDbCommand[]
{delete});
}
#endregion delete
}
}
![](/Images/OutliningIndicators/None.gif)
posted on
2006-07-25 20:42
胡晓伟
阅读(
347)
评论()
编辑
收藏
举报