/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.m_announcement_user GetModel(string USER_ACCOUNT)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ANNOUNCEMENT_ID,USER_ACCOUNT,STATUS from m_announcement_user ");
strSql.Append(" where USER_ACCOUNT=@USER_ACCOUNT ");
SqlParameter[] parameters = {
new SqlParameter("@USER_ACCOUNT", SqlDbType.NVarChar,50)
};
parameters[0].Value = USER_ACCOUNT;
Models.m_announcement_user model = new Models.m_announcement_user();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
public bool AddList(Models.m_announcement model_m_announcement)
{
ArrayList toList = new ArrayList();
var items = model_m_announcement.DEPARTMENT.Split(new string[] {";#;"}, StringSplitOptions.None);
foreach(string item in items)
{
var attrs = item.Split(new string[] { "%;" }, StringSplitOptions.None);
if (attrs.Count() == 4)
{
string type = attrs[0].Substring(5);
string path = attrs[3].Substring(5);
string name = attrs[2].Substring(5);
string account = model_z_parameter.VALUE + "\\" + attrs[1].Substring(8);
if (type == "user" && !toList.Contains(account))
{
toList.Add(account);
}
else if(type == "group")
{
Models.ldap_cn model = new Models.ldap_cn();
model.TYPE = type;
model.PATH = path;
model.NAME = name;
model.EMAIL = "";
model.ACCOUNT = account;
addGroupList(model, toList);
}
}
}
DAL.m_announcement_user dal_m_announcement_user = new DAL.m_announcement_user();
dal_m_announcement_user.Delete(model_m_announcement.ID);
foreach (string toItem in toList)
{
if (toItem.Trim() != "")
{
Models.m_announcement_user model_m_announcement_user = new Models.m_announcement_user();
model_m_announcement_user.ANNOUNCEMENT_ID = model_m_announcement.ID;
model_m_announcement_user.USER_ACCOUNT = toItem.Trim();
model_m_announcement_user.STATUS = "";
dal_m_announcement_user.Add(model_m_announcement_user);
}
}
return true;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.m_announcement_user DataRowToModel(DataRow row)
{
Models.m_announcement_user model = new Models.m_announcement_user();
if (row != null)
{
if (row["ANNOUNCEMENT_ID"] != null && row["ANNOUNCEMENT_ID"].ToString() != "")
{
model.ANNOUNCEMENT_ID = new Guid(row["ANNOUNCEMENT_ID"].ToString());
}
if (row["USER_ACCOUNT"] != null)
{
model.USER_ACCOUNT = row["USER_ACCOUNT"].ToString();
}
if (row["STATUS"] != null)
{
model.STATUS = row["STATUS"].ToString();
}
}
return model;
}
