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)); }