private void Init()
{
//加载所有机构信息
scanDataSet = new Business.OrgInfo().GetOrgByStr("");
//创建根节点
if (scanDataSet.BaseOrgInfo.Rows.Count > 0)
{
//获取河南省为根节点
DataRow[] drArrayRoot = scanDataSet.BaseOrgInfo.Select("orgid=1");
DataRow rootRow;
if (drArrayRoot.Length > 0)
{
rootRow = drArrayRoot[0];
}
else
{
MessageBox.Show("获取根节点错误");
return;
}
this.OrgTreeView.Nodes.Clear();
TreeNode root = new TreeNode();
root.Text = rootRow["orgname"].ToString();
root.Collapse(true);
root.Tag = rootRow;
this.OrgTreeView.Nodes.Add(root);
root.Expand();
}
}
public ScanDataSet GetOrgByStr(string str)
{
ScanDataSet scanDataSet = new ScanDataSet();
SqlConnection sqlConnection = SqlHelper.GetConnection();
sqlConnection.Open();
try
{
using (SqlCommand sqlCommand = new SqlCommand("select * from base_org_info where status=1 " + str, sqlConnection))
{
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
{
sqlDataAdapter.SelectCommand = sqlCommand;
sqlDataAdapter.Fill(scanDataSet, scanDataSet.BaseOrgInfo.TableName);
}
}
}
finally
{
SqlHelper.CloseConnection(sqlConnection);
}
return(scanDataSet);
}
public ScanDataSet GetConfigInfoByStr(string str)
{
ScanDataSet scanDataSet = new ScanDataSet();
SqlConnection sqlConnection = SqlHelper.GetConnection();
sqlConnection.Open();
try
{
using (SqlCommand sqlCommand = new SqlCommand("select t1.*,t2.orgname ,(CASE WHEN t1.status=1 THEN '启用' ELSE '注销' END ) statusname from hzyl_wz_config t1,base_org_info t2 where t1.forgid=t2.orgid /*and t1.status=1 and t2.status=1*/ " + str, sqlConnection))
{
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
{
sqlDataAdapter.SelectCommand = sqlCommand;
sqlDataAdapter.Fill(scanDataSet, scanDataSet.ConfigInfo.TableName);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
SqlHelper.CloseConnection(sqlConnection);
}
return(scanDataSet);
}
public ScanDataSet GetUserByID(string id)
{
ScanDataSet scanDataSet = new ScanDataSet();
SqlConnection sqlConnection = SqlHelper.GetConnection();
sqlConnection.Open();
try
{
using (SqlCommand sqlCommand = new SqlCommand("select t1.*,t2.orgname ,(CASE WHEN t1.status=1 THEN '启用' ELSE '注销' END ) statusname from hzyl_wz_user t1,base_org_info t2 where t1.forgid=t2.orgid /*and t1.status=1 and t2.status=1*/ and t1.id=@id", sqlConnection))
{
sqlCommand.Parameters.Add("@id", SqlDbType.VarChar, 20).Value = id;
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
{
sqlDataAdapter.SelectCommand = sqlCommand;
sqlDataAdapter.Fill(scanDataSet, scanDataSet.UserInfo.TableName);
}
}
}
finally
{
SqlHelper.CloseConnection(sqlConnection);
}
return(scanDataSet);
}
public ScanDataSet GetUserByUserInfo(string userCode, string password)
{
ScanDataSet scanDataSet = new ScanDataSet();
SqlConnection sqlConnection = SqlHelper.GetConnection();
sqlConnection.Open();
try
{
using (SqlCommand sqlCommand = new SqlCommand("select t1.*,t2.orgname from hzyl_wz_user t1,base_org_info t2 where t1.forgid=t2.orgid and usercode=@usercode and password=@password", sqlConnection))
{
sqlCommand.Parameters.Add("@usercode", SqlDbType.VarChar, 20).Value = userCode;
sqlCommand.Parameters.Add("@password", SqlDbType.VarChar, 20).Value = password;
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
{
sqlDataAdapter.SelectCommand = sqlCommand;
sqlDataAdapter.Fill(scanDataSet, scanDataSet.UserInfo.TableName);
}
}
}
finally
{
SqlHelper.CloseConnection(sqlConnection);
}
return(scanDataSet);
}
public void GetItemDict(ScanDataSet ds)
{
string commandText = xmlHelper.GetTextByAttribute(Util.Util.GetXMLPath(fileName), "select", "ID", "GetItemDict");
using (SqlConnection sqlConnection = new SqlConnection(Util.SqlHelper.GetConnSting()))
{
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(commandText, sqlConnection))
{
sqlDataAdapter.Fill(ds, ds.ItemDict.TableName);
}
}
}
public void GetItemDict(ScanDataSet ds)
{
IDcitProcess iDictProcess = new SqlServer.DictProcess();
iDictProcess.GetItemDict(ds);
}
public void GetCenterData(ScanDataSet ds)
{
IDcitProcess iDictProcess = new SqlServer.DictProcess();
iDictProcess.GetCenterData(ds);
}
