void DeleteDepart(Hashtable SQLString, StringBuilder strSql, ReviewOrderEntity.DepartEntity depart)
{
strSql = new StringBuilder( );
strSql.Append("DELETE FROM DETDBA ");
strSql.AppendFormat("WHERE DBA001='{0}' AND DBA002='{1}' AND DBA003='{2}'", depart.DBA001, depart.DBA002, depart.DBA003);
SQLString.Add(strSql, null);
}
/// <summary>
/// 保存部门信息
/// </summary>
/// <param name="departList"></param>
/// <returns></returns>
public bool SaveDepart(List <Depart> departList)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = strSql = new StringBuilder( );
strSql.Append("DELETE FROM DETDBA");
SqlHelper.ExecuteNonQuery(strSql.ToString( ));
foreach (Depart depart in departList)
{
if (ExistsDepart(depart.id))
{
EditDepart(SQLString, strSql, depart);
}
else
{
AddDepart(SQLString, strSql, depart);
}
}
DataTable dt = getDepart( );
if (dt != null && dt.Rows.Count > 0)
{
ReviewOrderEntity.DepartEntity depart = new ReviewOrderEntity.DepartEntity( );
for (int i = 0; i < dt.Rows.Count; i++)
{
depart.DBA001 = dt.Rows [i] ["DBA001"].ToString( );
depart.DBA002 = dt.Rows [i] ["DBA002"].ToString( );
depart.DBA003 = dt.Rows [i] ["DBA003"].ToString( );
if (depart.DBA003 == null || string.IsNullOrEmpty(depart.DBA003))
{
return(false);
}
if (departList.Exists(( Depart d ) => d.id.Equals(depart.DBA001) && d.name.Equals(depart.DBA002) && d.parentId.Equals(depart.DBA003)) == false)
{
DeleteDepart(SQLString, strSql, depart);
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
