private void GetAUZList()
{
ST1005A.MDM_System_User_Authorization_GetListBySession_ID cls = new ST1005A.MDM_System_User_Authorization_GetListBySession_ID();
cls.hzyMessage = this.hzyMessage;
DataSet ds = cls.GetData();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (m_UpdateAUZ != "")
{
m_UpdateAUZ += " OR ";
}
if (m_DeleteAUZ != "")
{
m_DeleteAUZ += " OR ";
}
if (m_InsertAUZ != "")
{
m_InsertAUZ += " OR ";
}
if (m_ViewAUZ != "")
{
m_ViewAUZ += " OR ";
}
m_UpdateAUZ += " Update_AUZ LIKE '%【" + ds.Tables[0].Rows[i]["Authorization_Name"].ToString() + "】%'";
m_InsertAUZ += " Insert_AUZ LIKE '%【" + ds.Tables[0].Rows[i]["Authorization_Name"].ToString() + "】%'";
m_DeleteAUZ += " Delete_AUZ LIKE '%【" + ds.Tables[0].Rows[i]["Authorization_Name"].ToString() + "】%'";
m_ViewAUZ += " View_AUZ LIKE '%【" + ds.Tables[0].Rows[i]["Authorization_Name"].ToString() + "】%'";
}
}
/// <summary>
/// 获取权限，并拼接成为SQL语句
/// </summary>
/// <param name="pIsbody"></param>
/// <returns></returns>
private string GetAuzProperty(bool pIsbody)
{
string strReturn = "";
ST1005A.MDM_System_User_Authorization_GetListBySession_ID cls = new ST1005A.MDM_System_User_Authorization_GetListBySession_ID();
cls.hzyMessage = this.hzyMessage;
DataSet ds = cls.GetData();
if (ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string strAUZ = ds.Tables[0].Rows[i]["Authorization_Name"].ToString();
m_AUZList.Add(strAUZ);
if (strReturn != "")
{
strReturn += " OR ";
}
if (pIsbody == false) //属性权限
{
strReturn += " (Update_AUZ like '%【" + strAUZ + @"】%'";
strReturn += " OR View_AUZ like '%【" + strAUZ + @"】%')";
}
else
{
strReturn += " (Insert_AUZ like '%【" + strAUZ + @"】%'";
strReturn += " OR Delete_AUZ like '%【" + strAUZ + @"】%'";
strReturn += " OR Update_AUZ like '%【" + strAUZ + @"】%'";
strReturn += " OR View_AUZ like '%【" + strAUZ + @"】%')";
}
}
}
return strReturn;
}
